2012-12-02
2012-11-22
2012-09-26
2012-06-10
2012-05-29
2012-04-23
2012-04-22
2012-04-19
2012-04-12
2012-04-04
Database Replication with MySQL5.5.x on Windows
On master server :
In section [mysqld] of my.cnf/my.ini file add :
server-id=1
binlog-do-db='database1_to_replicate'
binlog-do-db='database2_to_replicate'
...
binlog-do-db='databaseN_to_replicate'
Then start the master server and connect to it to create the account that will be used for the replication process :
CREATE USER 'repl_login'@'server_address' identified by 'repl_password';
GRANT REPLICATION SLAVE ON database1_to_replicate.* to 'repl_login'@'server_address';
On the slave :
In section [mysqld] of my.cnf/my.ini file add :
server-id=2
Start the slave, connect to it and type :
STOP SLAVE;
Define the master server with the following command :
CHANGE MASTER TO MASTER_HOST='server_address', MASTER_USER='intratool_repl', MASTER_PASSWORD='intratool_repl', MASTER_PORT=server_port;
Start the slave process :
START SLAVE;
Repeat theses command if you need to add other slave server.
In section [mysqld] of my.cnf/my.ini file add :
server-id=1
binlog-do-db='database1_to_replicate'
binlog-do-db='database2_to_replicate'
...
binlog-do-db='databaseN_to_replicate'
Then start the master server and connect to it to create the account that will be used for the replication process :
CREATE USER 'repl_login'@'server_address' identified by 'repl_password';
GRANT REPLICATION SLAVE ON database1_to_replicate.* to 'repl_login'@'server_address';
On the slave :
In section [mysqld] of my.cnf/my.ini file add :
server-id=2
Start the slave, connect to it and type :
STOP SLAVE;
Define the master server with the following command :
CHANGE MASTER TO MASTER_HOST='server_address', MASTER_USER='intratool_repl', MASTER_PASSWORD='intratool_repl', MASTER_PORT=server_port;
Start the slave process :
START SLAVE;
Repeat theses command if you need to add other slave server.
2012-03-25
2012-01-08
Subscribe to:
Comments (Atom)