{"id":8971,"date":"2026-09-18T06:21:15","date_gmt":"2026-09-18T06:21:15","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=8971"},"modified":"2026-09-19T15:56:33","modified_gmt":"2026-09-19T15:56:33","slug":"creating-cloud-sql-instance","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/cloud-sql\/creating-cloud-sql-instance\/","title":{"rendered":"Creating Cloud SQL instance"},"content":{"rendered":"\r\n

Creating a Cloud SQL Instance in the Console<\/h1>\r\n

Cloud SQL<\/b><\/strong>\u00a0is Google Cloud’s managed relational database service for MySQL, PostgreSQL, and SQL Server, handling patching, backups, and maintenance so you do not have to run a database server yourself. This walks through creating an instance directly in the console, which is the more visual option when you are still deciding between settings, compared to typing the equivalent gcloud command blind.<\/p>\r\n

Reaching for the console over the command line makes the most sense the first few times you create an instance, or whenever you want to see every available option laid out rather than needing to already know the right flag name for it. Once you know exactly what you want, the gcloud command line path, covered in a separate guide, becomes the faster option.<\/p>\r\n

This covers choosing a database engine and edition, setting the instance’s core configuration, and deleting an instance you no longer need.<\/p>\r\n

Step by Step Process of Creating a Cloud SQL Instance<\/h2>\r\n

Step One: Open the SQL Section<\/h3>\r\n

Open the console, then the menu, then SQL, under Storage.<\/p>\r\n\r\n\r\n\r\n

Menu > SQL<\/a><\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Two: Create an Instance<\/h3>\r\n

Click Create Instance.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Three: Choose a Database Engine<\/h3>\r\n

Choose the database engine you need, MySQL, PostgreSQL, or SQL Server. This example uses MySQL.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Four: Name the Instance and Set a Password<\/h3>\r\n

Give the instance an ID and a password, and choose the database version you want.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Five: Choose an Edition<\/h3>\r\n

Choose Enterprise for standard workloads, or Enterprise Plus if you need its extra performance, availability, and observability features, such as longer running Query Insights history and finer grained metrics. Enterprise Plus also unlocks a slightly different set of available machine series. If you are not sure which you need, Enterprise covers the vast majority of everyday use cases, and you can upgrade an existing instance to Enterprise Plus later with only sub second downtime, so this choice is not entirely locked in.<\/p>\r\n

Step Six: Choose a Region and Zone<\/h3>\r\n

Choose the region and zone for your instance.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Seven: Show Configuration Options<\/h3>\r\n

Click Show Configuration Options.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Eight: Choose a Machine Type<\/h3>\r\n

Choose the machine type and specification for the instance. This decides its available memory and CPU. Note that you cannot change an instance’s machine series after it is created, so pick with some headroom rather than the absolute minimum you think you need today.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Nine: Choose Storage<\/h3>\r\n

Choose the storage type and capacity.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Ten: Choose Connectivity<\/h3>\r\n

Choose how you want to connect to this instance. If you enable a public IP here, plan to either restrict which addresses can reach it under Authorized Networks or connect through the Cloud SQL Auth Proxy instead of leaving it open broadly, covered in more depth in the Creating a Cloud SQL Instance With gcloud guide.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Eleven: Set a Backup Window<\/h3>\r\n

If you want backups, choose a backup window.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Twelve: Set a Maintenance Window<\/h3>\r\n

Choose a day for maintenance when your instance typically sees less traffic.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Step Thirteen: Create the Instance<\/h3>\r\n

Click Create Instance.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

The instance will be created.<\/p>\r\n

Deleting a Cloud SQL Instance<\/h2>\r\n

In the SQL instances list, click the three dots next to the instance, then Delete.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n\r\n\r\n\r\n

Type the instance ID to confirm, then press Delete.<\/p>\r\n\r\n\r\n\r\n

\"\"<\/figure>\r\n

 <\/p>\r\n

Common Mistakes to Avoid<\/h2>\r\n