Replication MySQL multiple DBs
============================= MASTER: add lines to my.cnf ============================= binlog-do-db=database_name_1 binlog-do-db=database_name_2 binlog-do-db=database_name_3 ============================= MASTER: SQL SYNTAX ============================= GRANT REPLICATION SLAVE ON *.* TO ‘user’@’%’ IDENTIFIED BY ‘password’; FLUSH PRIVILEGES; FLUSH TABLES WITH READ LOCK; UNLOCK TABLES; SHOW MASTER STATUS; output> file | Position | Binlog_Do_DB mysql-bin.000963 1570 database_name_1,database_name_2,database_name_3 ============================= SLAVE: add lines to my.cnf ============================= replicate-do-db=database_name_1 replicate-do-db=database_name_2… Leer más »