How To Set Up Database Replication In MySQL
About MySQL replication
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help in othe situations
- protect against hardware failures as part of your database failover strategy.
- Reducing load on production master server by running expensive report queries on the slave server. In these setup, you should only allow accept write queries on the master server, other wise those changes made on a specific slave server won't be replicated across all instances of replication servers.
MySQL Server setup
Consider a very simple example of mysql replicatio
Note: Some of these shortcuts have been remapped for my own convenience (Preferences->Keymap). These are Mac shortcuts, just use the Windows/Linux equivalent of the Cmd/Option/Ctrl/Del keys.
####Search, Go to, Navigation ####
Cmd + P - Search file
Cmd + Shift + O - Search everywhere
(I swapped the above two recently because I use Cmd + P to search for files most of the time).