Separate Database Setup

  • wpwdc

    (@wpwdc)


    8 years, 3 months ago

    Hi all
    My customer requires that we setup multiple public facing web servers balanced with an F5 but the database servers should be separate behind a firewall and encrypted. My question is. Should we setup web and separate db servers one to one , that is each web server has its own database server and use something like rsynch to keep the databases in synch or place another f5 in front of the database servers and have fewer database servers that is 5 web servers and three database servers ans use rsynch. Will WP allow this type of configuration or each instance of wp requires a dedicated database ?

    Any help will be appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Geraint Palmer

    (@geraint)

    8 years, 3 months ago

    Hi

    Are you trying to host 5 different WordPress websites, or one site, just load balanced across 5 web servers?

    Either way you your going to need as many db servers as load and hardware specs require.

    Depending on the load your expecting you could probably suffice with less, even just one db server depending on the RAM/CPU available to it.

    If you’re going to the trouble of balancing the http server for uptime/availability a secondary failover db server is probably a must.

    I should now clarify that I’ve never actually deployed anything like (multiple db servers) this but I have looked into it before.

    And last time I checked I think wordpress.com was originally just running on one super massive sql server for writing requests with secondary’s slave servers for read requests and somewhere I found a plugin by automattic that tunes wordpress to work in that way, mysql writes to x and read to yz etc.. now I think its clustered too. but you get the idea.

    https://en-gb.wordpress.org/plugins/hyperdb/

    Vanilla wordpress is not designed to work with multiple db server at all and id be very afraid of trying to keep multiple primarys in sync.

    You can have as many different wordpress database running in the same sql server as you like/ you can fit so if their five different sites you can again stack them all in one server or spread them out as required.

    Give this tutorial a look

    http://net-load.com/how-to-setup-mysql-database-master-and-slave-with-hyperdb-on-wordpress/

    Hope it helps

    Thread Starter wpwdc

    (@wpwdc)

    8 years, 3 months ago

    Thanks a bunch.
    We have 5 web servers hosting the same website, they are duplicates of each other. We also have an F5 in front of them to balance the traffic.
    The database the customer picked is MariaDB, but they want it behind the firewall and they also want high availability. In the scenario you described with a primary and a failover DB Server , the failover must be seamless to the web servers. So all the 5 WP web servers must point to a primary DB, which replicates to the failover DB and then I must come up with a mechanism to automatically switch the servers in case the primary fails.
    I know SQLServer has mirroring and witnessing tools. But not sure about MariaDB.
    Best>>

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Separate Database Setup’ is closed to new replies.