MySQL Tidbits

Allow Slave to connect master:

C:\mysql>create user 'replica'@'' identified by '<YOUR PASSWORD>';

NOTE: which is the SLAVE machine‟s address.

i. mysql>grant create,insert,select,update,delete on ejbca.* to 'replica'@'';

Checking if Slave can connect to Master:

C:\>mysql –u replica –h –p

C:\>Enter password: <YOUR VALUES>

NOTE: If the mysql prompt opens then the Master machine can be accessed from the Slave machine.




MySQL Replication by MySQL

The easiest and most straightforward method for setting up replication is to use new master and slave servers.

You can also use this method if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new master, the data will be automatically replicated to the slaves.

To set up replication between a new master and slave:

  1. Configure the MySQL master with the necessary configuration properties. See Section, “Setting the Replication Master Configuration”.

  2. Start up the MySQL master.

  3. Set up a user. See Section, “Creating a User for Replication”.

  4. Obtain the master status information. See Section, “Obtaining the Replication Master Binary Log Coordinates”. Continue reading “MySQL Replication by MySQL” »


MySQL Replication

MySQL is the relational database system of choice for open sourcers. Replication is the process of replicating data from one MySQL database server (the master) into another (the slave). We’ll go into why you would want to replicate a MySQL database in another article.

MySQL Replication
Using the master-slave configuration mentioned above, only the changes made to the master are replicated in the slave. Changes made to the slave do not affect the master.

If you follow the steps below, you can set up MySQL replication in a matter of minutes. Continue reading “MySQL Replication” »