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 December 2007, 05:08
hareem hareem is offline
Junior Member
 
Join Date: Dec 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Query regarding replication of Mysql


I followed a link from google and it landed me to the following page.
http://www.howtoforge.com/mysql_database_replication

Now it all looks quite easy to do . I dont think there should be a million problems to solve.

However, my boss is on my case regarding replication. I got one question for you all. If the master sends database info to replicate onto the slave is it possible to add as many slaves as a i need and what happens if the master dies.

How can i promote one of the slaves to become a new master or if thats not possible then if the master is down or dies out what procedure should i follow to resolve the problem fast.

Thanks
Hareem. Haque
Reply With Quote
Sponsored Links
  #2  
Old 7th December 2007, 06:57
tfunky tfunky is offline
Member
 
Join Date: Jan 2007
Posts: 85
Thanks: 4
Thanked 2 Times in 2 Posts
 
Default

Warning...I'm no expert...but,

Have you taken a look at this:

http://www.howtoforge.com/mysql5_mas...on_debian_etch

That howto covers master/master replication and may solve your problem with master/slave promotions, etc.

You might take a look and see if that helps you. If not I'm sure there's a guru somewhere around here that can help you out!

Good Luck!!!
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
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Help with MySQL Query jvilches Server Operation 5 4th September 2006 17:20
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql... snowfly HOWTO-Related Questions 4 7th July 2006 04:19
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 23:47.


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