MySQL is one of the most popular open source relational databases, offering robust transaction processing at low costs. For a general overview of MySQL, see What is MySQL.
There are several ways that you can deploy MySQL as part of your Google Cloud project:
- Cloud SQL offers MySQL as a web service. You can use Cloud SQL to host your MySQL database in Google's cloud, and let Google Cloud handle administrative duties like replication, patch management, and database management. For an overview, see Cloud SQL overview.
Google Cloud Marketplace lets you click to install MySQL onto a Compute Engine instance. To browse available MySQL installation options from Cloud Marketplace in the Google Cloud console:
You can manually install and customize MySQL on Compute Engine. For manual installation instructions, see Install MySQL on Compute Engine. To optimize your configuration of MySQL, follow the guide at Configure MySQL on Compute Engine.
Choose the best MySQL deployment option for your needs
To understand which MySQL deployment option best fits your needs, consider the options as follows:
Try Cloud SQL (recommended)
If you want the convenience of having Google Cloud take care of the backend database and server administration chores, we recommend that you use Cloud SQL. Cloud SQL provides the following advantages:
- Automated backups
- Point-in-time recovery
- Replication of your data across multiple zones for greater availability and resiliency.
If you require MySQL features that Cloud SQL doesn't support, such as user defined functions or the SUPER privilege, you can explore the options that follow. For more information about the features that Cloud SQL supports, see the Cloud SQL FAQ.
Explore Google Cloud Marketplace deployment options
Cloud Marketplace offers several options for MySQL installations, including:
- A standalone MySQL installation
- LAMP stacks
- LEMP stacks
- Nginx stacks
- A Percona MySQL Cluster installation
Browse available MySQL installation options from Cloud Marketplace in the Google Cloud console:
Go to Google Cloud Marketplace
Manually install MySQL
If the previous options don't fit your requirements, such as if you want to deploy MySQL on a custom image you created, or if you want complete control of the installation process, you can manually install MySQL by creating a Compute Engine instance and installing MySQL directly onto it. For more detailed instructions, see Install MySQL on Compute Engine.
What's next
- For best practices and tips for running MySQL workloads on Compute Engine, see Configure MySQL on Compute Engine.
- For more information about Cloud SQL, see the Cloud SQL for MySQL documentation.
Browse the MySQL installation options from Cloud Marketplace in the Google Cloud console:
To manually install MySQL on a Compute Engine instance, see Install MySQL on Compute Engine.