Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


mysql replication
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.

mysql replication

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.

  • CloudxtnyHostCloudxtnyHost Member, Host Rep

    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

  • @robohost said:
    Just replicate all db

    Yes . thats all the solution for this . replicate all databases

Sign In or Register to comment.