#1  
Old 2nd August 2010, 19:37
admins admins is offline
Senior Member
 
Join Date: Apr 2009
Location: Switzerland
Posts: 210
Thanks: 6
Thanked 3 Times in 3 Posts
Default MYSQL Replication

Hi all

I've one webserver with a mysql server. Now I wan't to set up a backup webserver with a backup mysql server. Now I need a howto.

If the master webserver is not online, the loadbalancer put the users to the backupwebserver. He must be every time synced with the masterwebserver. If he is down and someone makes changes in its database, the backupwebserver must sync it back to the master webserver.

Thanks
admins

Last edited by admins; 2nd August 2010 at 21:04.
Reply With Quote
Sponsored Links
  #2  
Old 2nd August 2010, 20:12
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,424
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

You mix the terms web, mysql and mailserver in your post. Do you want to sync a webserver or a mailserver or a database server? Aditionally your post title is talking about mysql replication which is only relkevant for a databse server. This are 3 different tasks, so I need to know exactly what you want to mirror to give you some hints on how to achieve this.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 2nd August 2010, 21:06
admins admins is offline
Senior Member
 
Join Date: Apr 2009
Location: Switzerland
Posts: 210
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Thanks Till. I've correct ist. :

Master MYSQLServer --> Backup MYSQL Server

Replication:
Master MYSQLServer <----> Backup MYSQL Server

Databases:
all of the MYSQL Server

Thanks
admins
Reply With Quote
  #4  
Old 2nd August 2010, 21:11
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,424
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
 
Default

Ok. In this case there are two options available as far as I know:

1) Master / master replication, so that every change in the master gets written to the slave and every chnage in the slave gets written to the master automatically. You can even use both servers at the same time r.g. for loadbalancing. Falko has written a few tutorials about this topic.

2) Use a mysql cluster server for all website databases of the master and the slave server:

http://www.mysql.com/products/database/cluster/faq.html
http://dev.mysql.com/tech-resources/...o-servers.html
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 20:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
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 08:30.


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