MySQL builds master-slave on a single server

Note: This environment performs rm-rf/usr/local/mysql in advance to facilitate the experiment.

1. Master and Slave, similar to a machine and B machine connection, data connection via Bin_log and Rpel_log

2.:

3. Enter/etc/init.d/mysqld for editing.

4. Regenerate the table of contents, two OK if successful, or later use Ls/data/mysql to see if MySQL and test files appear

5. Startup success

6. The master is configured to use the CP to copy the cp/etc/my.conf.

Enter vim/etc/my.conf to edit port, Socket,datadir

7. Enter Vim/etc/init.d/mysqld to modify MySQL to Mysql_slave

8. Start successfully, view the MySQL process:

MySQL builds master-slave on a single server