Title: Separate Database Setup
Last modified: August 31, 2016

---

# Separate Database Setup

 *  [wpwdc](https://wordpress.org/support/users/wpwdc/)
 * (@wpwdc)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/separate-database-setup/)
 * 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](https://wordpress.org/support/users/geraint/)
 * (@geraint)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/separate-database-setup/#post-6938116)
 * 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/](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/](http://net-load.com/how-to-setup-mysql-database-master-and-slave-with-hyperdb-on-wordpress/)
 * Hope it helps
 *  Thread Starter [wpwdc](https://wordpress.org/support/users/wpwdc/)
 * (@wpwdc)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/separate-database-setup/#post-6938174)
 * 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.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [encrypted](https://wordpress.org/support/topic-tag/encrypted/)
 * [F5](https://wordpress.org/support/topic-tag/f5/)
 * [firewall](https://wordpress.org/support/topic-tag/firewall/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [wpwdc](https://wordpress.org/support/users/wpwdc/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/separate-database-setup/#post-6938174)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics