Possible Duplicate:
Regarding Mysql Master-slave configuration
Hi to all,
I have some doubs regarding Mysql master-slaves
For example , if i setup 2 slaves to Master.In between production ,i want to add another slave to that master.at that time,what i have to do?
thanks in advance
From stackoverflow
-
The process of setting up a slave to a live server is simple:
- use mysqldump to get a snapshot from the master in a specific point in time
- configure your new slave as per your needs, with replication down
- integrate the master snapshot
- shutdown the slave server
- configure replication
- start the slave
You can do all this perfectly well on a running production server, as the only intervention required on existing servers is taking the snapshot from the master which is a rather painless process.
0 comments:
Post a Comment