locked
Load Balanced Wordpress Installation RRS feed

  • Question

  • User-2097772566 posted

    Hi

    We are exploring the option of using the Web Farm to provide a load balanced Wordpress Installation.Has anybody tried this?

    My thought is to have a Primary Server  with full Wordpress and MYSQL installation which is not accessible by users but used as 'deployment server' so that published content on this server is copied accross automatically over to the secondary servers (also having full Wordpress Installs) accessible to users.

    We hope to use MYSQL and so also asking about the simplest way to replicate teh database from Primary to secondary servers - or it is better to use SQL Server ?

    Any help would be appreciared

     

    Thursday, October 4, 2012 10:33 PM

Answers

  • User1080221284 posted
    Yes, this would work, but the best method would be to have at least 3 servers. Two for web content and one for SQL. You'd need to sync the web content and IIS configuration between the web nodes (either manually, or via some automated method like IIS shared config and DFS). If you require database redundancy, a cluster is best. MySQL is the easiest option for Wordpress.
    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, October 5, 2012 1:23 AM

All replies

  • User1080221284 posted
    Yes, this would work, but the best method would be to have at least 3 servers. Two for web content and one for SQL. You'd need to sync the web content and IIS configuration between the web nodes (either manually, or via some automated method like IIS shared config and DFS). If you require database redundancy, a cluster is best. MySQL is the easiest option for Wordpress.
    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Friday, October 5, 2012 1:23 AM
  • User1994556403 posted

    You can replicate your MySQL database with a wpdb replacement called HyperDB:

    http://codex.wordpress.org/HyperDB, http://wordpress.org/extend/plugins/hyperdb/

    Friday, January 11, 2013 9:46 AM