Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th September 2008, 22:05
wxman wxman is offline
Senior Member
 
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
Default Master to Master Replication with more than one DB

Now that I solved mi file backup problem, I ended up with a new one.
Following the instructions at http://www.howtoforge.com/mysql5_mas...on_debian_etch, I was able to get it to work great.

My question is how do I add more databases? I need this for a backup/mirror system for my server. I'll have several databases going that will all need to be backed up. I realize that this isn't the best system to use for a server failover, but I can't afford to get two more servers to set up a load balancer/failover system.
Reply With Quote
Sponsored Links
  #2  
Old 8th September 2008, 11:58
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

http://www.howtoforge.com/forums/sho...t=binlog-do-db
http://www.howtoforge.com/forums/sho...t=binlog-do-db
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 8th September 2008, 17:36
wxman wxman is offline
Senior Member
 
Join Date: May 2007
Posts: 189
Thanks: 11
Thanked 2 Times in 2 Posts
 
Default

Thanks. I didn't find those when I searched.

I had already added the replicate-do-db and binlog-do-db to the my.cnf file but I couldn't find if I needed to do any more.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 17:07
named.conf.master ISPconfig duplication hypertec_hope Installation/Configuration 0 18th July 2008 18:23
mysql master master replication not working SoftDux HOWTO-Related Questions 5 29th March 2007 14:31
Mysql Master Master replication stormrider HOWTO-Related Questions 5 16th February 2007 18:18
DNS: Multiple IPs, want to setup a "private" nameserver on each IP for resellers bpmee Server Operation 8 17th September 2006 09:35


All times are GMT +2. The time now is 12:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.