Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th February 2013, 01:38
InTimber InTimber is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Wordpress site in a cluster

Hi,

I would like to run a Wordpress site in a cluster environment and would like to know what you think about that. Will it work like this? Anything special to consider?

Here are the details:
- 1 Wordpress blog
- 2 Debian 6 servers, Apache, PHP, MySQL, ISPConfig 3
- MySQL replication (master/slave)
- File replication via unison every 5 minutes via cron
- DNS entry (blog.domain.com) that refers to both server IP addresses

So users get randomly redirected to the first or the second cluster node, but the replication (file and MySQL) keeps both servers in sync.

This scenario works with simple websites but I have no experience with Wordpress sites. Please let me know what you think about that.

Thanks,
Denis
Reply With Quote
Sponsored Links
  #2  
Old 18th February 2013, 08:57
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 186
Thanks: 7
Thanked 47 Times in 41 Posts
Default

Hi Denis,

it should work. But make sure, that new Posts and Commencts are always written to the mysql-Master. I prefer master-master in such a scenario instead of using a remote mysql-on the slave.
__________________
regards
Florian

blog.schaal-24.de
Reply With Quote
  #3  
Old 18th February 2013, 16:10
InTimber InTimber is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That's exactly why I ask: Why should I write it to the MySQL master? Why do think it is not good to write to the slave? Shouldn't it be replicated instantly to the master?

Thanks,
Denis
Reply With Quote
  #4  
Old 18th February 2013, 16:16
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 186
Thanks: 7
Thanked 47 Times in 41 Posts
Default

Changes made on the slave will NOT be sent to the master.
__________________
regards
Florian

blog.schaal-24.de
Reply With Quote
  #5  
Old 18th February 2013, 16:30
InTimber InTimber is offline
Junior Member
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Alright, thanks for the explanation. I'm pretty new to MySQL replication and still have some problems with the terminology. It seems like I have already set up a master/master replication and thought it's a master/slave setup. I just tested it (made changes on both sides) and it worked out well.

Thanks for the explanation.

Any other thoughts about my scenario? It looks like with a master/master replication this should work great?!
Reply With Quote
  #6  
Old 18th February 2013, 17:42
florian030 florian030 is offline
Senior Member
 
Join Date: Oct 2012
Posts: 186
Thanks: 7
Thanked 47 Times in 41 Posts
 
Default

As long as you use auto-increment and the slave-lag is not too high....
__________________
regards
Florian

blog.schaal-24.de
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
Problem Updating and Uploading to Wordpress website on ISPConfig3 - Fedora 13 MrCompTech Tips/Tricks/Mods 7 7th January 2014 01:07
Internal server errors on Wordpress only (rest of site is working fine) kyle30 Installation/Configuration 1 8th April 2012 14:05
Heartbeat on FreeBSD7.2 not changing to Virtual IP jodizzz Server Operation 1 15th April 2010 07:46
ispconfig wordpress and directory/file permissions willebanks Installation/Configuration 4 9th March 2010 21:52
MySQL Cluster - Tables not synced tfunky Server Operation 4 6th April 2007 22:22


All times are GMT +2. The time now is 06:44.


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