====== MySQL - Replication ======

===== Master =====

<file bash my.cnf>
log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=exampledb
server-id=1 
</file>

In addition, we allow remote locking tables and receiving calls from outside.


<code mysql>
GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY '<some_password>'; (Replace <some_password> with a real password!)
FLUSH PRIVILEGES; 
SHOW MASTER STATUS;
</code>

Result

<code>
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_do_db | Binlog_ignore_db |
+---------------+----------+--------------+------------------+
| mysql-bin.006 | 183      | exampledb    |                  |
+---------------+----------+--------------+------------------+
1 row in set (0.00 sec) UNLOCK TABLES;
</code>


===== Slave =====

<file bash my.cnf>
server-id=2
</file>

The rest of the things will be directly in the database.  Some tutorials indicate that you can also here, too.

<code mysql>
LOAD DATA FROM MASTER;
</code>

Do this if there is already some data.

<code mysql>
SLAVE STOP; 
CHANGE MASTER TO MASTER_HOST='192.168.0.100', MASTER_USER='slave_user', MASTER_PASSWORD='<some_password>', MASTER_LOG_FILE='mysql-bin.006', MASTER_LOG_POS=183;
</code>

To see what this returns:

<code mysql>
\h CHANGE MASTER TO
</code>


===== Summary =====

MASTER_HOST - Address of the master server
MASTER_USER - user
MASTER_PASSWORD - password
MASTER_LOG_FILE - 
MASTER_LOG_POS - 

<code mysql>
START SLAVE;
</code>