Archivo por meses: noviembre 2009

This tutorial will go through the setup of MySQL database replication. I will also talk about how to get everything working smoothly again after a server crash, or if you wish to switch databases. I will try to explain what is going on behind the scenes for every step (something I’ve found missing from other… Leer más »

============================= 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 »