mysql| Data | database
MySQL Version: 4.1
Environment Introduction: Main Library 192.168.0.205 from library 192.168.0.206
1, the main library to create/ETC/MY.CNF, modify [mysqld] inside the key value increase
2, the main library to increase the user to read the main library log from the library.
Grant replication Slave,reload,super on *.* to ' slave ' @ ' 192.168.0.206 ' identified by ' 123456 '
3, from the library to connect the main library for testing.
4, stop from the library, modify from the library/etc/my.cnf, add options:
5, starting from the library, the master-slave database data synchronization
Description: This step can also be used to pour into the database or direct catalogue test.
6, the test:
The main library creates the table,
Open from library, view:
7, master-slave Database related commands:
Purge master logs to ' binlog.000004 '; This command is very careful to delete the binary log files that are not used by the primary database. If you mistakenly delete, then there is no way to automatically update from the library.
Change Master to modify the parameter usage from the server.