Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st May 2013, 01:15
davefrooney davefrooney is offline
Junior Member
 
Join Date: Apr 2011
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Best Mysql Replication Solution?

I am running 3 am running 3 web/db servers. I originally setup master master replication so that all my webservers could use localhost as this was speeding up the sites considerably. The problem was I was getting mysql errors from some of the table and I had to setup the replication from scratch again and again which is not ideal. I also noticed that the mysql database wasn't replicating properly itself. This was a real pain when adding user. It meant I had to add the user manually to all the servers

I tried mysql-proxy using read/write splitting which would run fine for a short time but once an error occurred the system would crash and have to be restarted manually.

I'm wondering what the most reliable system is to keep my 3 databases synchronized?

Many thanks in advance for your help
Reply With Quote
Sponsored Links
  #2  
Old 21st May 2013, 07:41
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 229
Thanks: 8
Thanked 62 Times in 53 Posts
Default

If i add a new user to mysql using ispconfig, the user is created on all sql-servers. But i skip the mysql-db in the replication since i wont the same data for i.e. the root-user on all systems.
__________________
regards
Florian

blog.schaal-24.de
Reply With Quote
  #3  
Old 21st May 2013, 13:08
davefrooney davefrooney is offline
Junior Member
 
Join Date: Apr 2011
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for getting back to me Florian. I was originally set up this way too, however, if a database was added through ISPConfig and replication was set up,MySQL would crash as the database was being added twice.

How are you replicating your databases?
Reply With Quote
  #4  
Old 21st May 2013, 13:14
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 229
Thanks: 8
Thanked 62 Times in 53 Posts
Default

Thats a known problem. Mysql can stop the replication with error 1007 (Cant create database). I played around with some possibilities to use the mysql-replication with ispconfig and finally im now skipping the errors 1007 and 1008 in mysql.

For more see http://blog.schaal-24.de/?p=1921&lang=en
__________________
regards
Florian

blog.schaal-24.de
Reply With Quote
  #5  
Old 21st May 2013, 13:23
davefrooney davefrooney is offline
Junior Member
 
Join Date: Apr 2011
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Nice blog! There are some really good posts in there. I will test out this configuration and hopefully get a nice reliable system.

Would you recommend setting these servers up in a ring configuration or what do you find to be the most resilient topology?

Thanks for your help
Reply With Quote
  #6  
Old 21st May 2013, 13:28
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 229
Thanks: 8
Thanked 62 Times in 53 Posts
 
Default

Im running master-master-slave-setup for ISPConfig.

Maybe you find some hints here: http://dev.mysql.com/doc/refman/5.1/...ti-master.html
__________________
regards
Florian

blog.schaal-24.de
Reply With Quote
Reply

Bookmarks

Tags
multi server setup, mysql, replication

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
ISPConfig 3 system installation script Mark_NL Tips/Tricks/Mods 12 7th March 2014 06:30
help cant access anything locally or from ip jimmie Installation/Configuration 14 5th March 2013 07:58
ISPConfig 3 - MultiServer Setup - With Dedicated Control Panel - How? SuperJC Installation/Configuration 4 16th October 2012 20:03
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


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


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