We earn commission when you buy through affiliate links.
This does not influence our reviews or recommendations.Learn more.
Managing heavy-traffic WordPress sites has many challenges, and one of them is adatabase.
A typical WordPress site would be something like below.
Where all the software like Nginx/Apache, PHP, WordPress, MySQL/MariaDB is running on the same server.
There are two possible ways to do that.
What is Google Cloud SQL?
Cloud SQL is ahigh-performance managed database(MySQL, PostgreSQL, SQL server) service by Google.
You dont have to worry about installation, managing, performance optimization.
You pay what you use and let Google handle the database infrastructure.
Google Cloud SQL can beintegratedwith App Engine, Compute Engine, or any other hosting/service including your local workstation.
Readyto see how Cloud SQL works with WordPress?
I will do the following to separate the database.
However, If your WordPress is not on Google Cloud then choose the nearest location from your server.
Getting Data Export from existing Database
There are some more procedures to export as explained inGoogle docs.
There are two parts.
User account good to have a separate user account created for the WordPress database.
You havesuccessfullyseparated the WordPress database.
attempt to access to ensure it works.
Once all right, you may want tostop the MySQLon WordPress server.
Getting managed MySQL on Google Cloud is quitestraightforward, and I didnt encounter any issue.
If you oughta split the database from a WordPress server, Google Cloud SQL would be a good option.
Give it a take a stab at see how it works.
Not comfortable with configuration modification, server administration-related stuff?
Leverage managedGoogle Cloud platform for WordPress.
