Recommended configuration for MySQL replication in the production environment

Question: How many steps can an elephant be taken to the refrigerator?
Answer:: Open the refrigerator, put it in the elephant, and close the refrigerator.
The three-step strategy, haha, and secure configuration replication are also the same.



(I) Create a copy account

Master/Slave:

gant replication slave,replication client on *.* to 'cdio'@'192.168.47.%' identified by '2010cdio'

(Ii) Configure active/standby

Master database:

   log-bin=/home/mysql/mysql/binlog/mysql-bin   server_id=10   sync_binlog=1   innodb_flush_logs_at_trx_commit=2   innodb_support_xa=1

Slave database:

   log_bin=/home/mysql/mysql/binlog/mysql-bin   server_id=2   relay_log=/home/mysql/mysql/relaylog/mysql-relay-bin   log_slave_updates=1   read_only=1   skip_slave_start   sync_master_info=1   sync_relay_log=1   sync_relay_log_info=1

(Iii) Start Replication

Slave Database: Change master to master_host = 'node3 .cdio.com ', master_user = 'kic', master_password = '2010ic', master_log_file = 'mysql-bin.000001', master_log_pos = 0; Start slave; show slave status \ G; Master/Slave: Show processlist \ G;