Featured AI Products
Compute
Build, deploy, and scale cloud compute resources
Containers and Images
Safely store and manage containers and backups
Managed Databases
Fully managed resources running popular database engines
Management and Dev Tools
Control infrastructure and gather insights
Networking
Secure and control traffic to apps
Security
Help protect your account and resources with these security features
Storage
Store and access any amount of data reliably in the cloud
Browse all products
AI/ML
CMS
Data and IoT
Developer Tools
Gaming and Media
Hosting
Security and Networking
Startups and SMBs
Web and App Platforms
See all solutions
Community
Documentation
Developer Tools
Get Involved
Utilities and Help
Become a Partner
Marketplace
Pricing

- Community
- DigitalOcean
- Community
- DigitalOcean

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.

Multiple Sites - Accessing One Database

Question

Posted on June 4, 2015

By a2842e06675140ea9c90d3ac8f3eb0

I have an interesting scenario that i am trying to figure out the best approach for. I have searched digital ocean community a bit to see if this topic has already been discussed and wasn’t able to locate anything. My apologies if this scenario has already been discussed.

I have a Word Press site (SITE A) that is our main site. This site is used for real estate and downloads all of the listing information into the local WordPress database using a php we have written. The script runs every hour.

We also have several other sites (SITES B, C, D, E &F) that are all hosted on their own droplets. These sites have their own local database on their own respective droplets. These sites also reference the SITE A database in order to pull in information about certain properties.

Our idea is this. We would like to Separate the WordPress Installation and Database for SITE A. We will create a separate Droplet that we can easily scale for SITE A allowing SQL to not have to share resources.

Our question is simply, understanding that SITES B,C,D,E & F also access the database from SITE A, including that they access their own respective database, what is the best way to configure this where there is efficiency and speed without having a huge lag time between response from sql and the application displaying in the browser. Which is an issue we currently suffer from.

Any advise and help would be greatly appreciated.