New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
mysql replication
HostGliders
Member
in Tutorials
HI,
I have around 30 databases need to replicate on my new db(slave) server , this si my first time am doing such replication , i have got some tutorials over google , but how can we mention around 30 DB in my.cnf file , would that possible?
Need useful suggestions.
Comments
Depending on your storage, it may make the most sense to make a binary snapshot then tell the slave to catch up. 30 isn't that bad unless they're pushing gigs of traffic with no hope of the slave ever catching up.
If you don't care what gets replicated across, you don't have to specify a database and then mysql will replicate all databases.
Just replicate all db
Yes . thats all the solution for this . replicate all databases