Setting Up a SQL Database- Process
Step 1: Create Instance
Visit console.cloud.google.com and Log in with your valid credentials. Then on the left sidebar select SQL.
On the next page click on create instance.
Step 2: Choose Database Engine
When creating a Cloud SQL instance on Google Cloud Platform (GCP), you have the flexibility to choose from several database engines based on your specific requirements. Select the database engine that suites your requirement (e.g., MySQL, PostgreSQL, SQL Server).
Step 3: Configure Database Instance
An instance refers to a single, isolated database running on a cloud server. It includes the database engine, storage, and configuration settings.
Give your instance a name and set a secure password to prevent un-authorized access. Select Database version as MySQL 8.0.
Set Availability Zone as your nearest and explore other configurations, you can change accordingly or left unchanged. For further more customization scroll down to customize your instance and explore other customization options like Machine configuration, Storage, etc.
Once done, click on create.
Step 4: Check Database Instance
Wait for sometime, until the instance is created. You will notice a tick mark before your instance name, once it is created.
Now you have successfully created a Relational Database using Cloud SQL on GCP.
How to Use Cloud SQL to Create and Manage Relational Databases
Data is everywhere, and managing data is a challenge. Most web websites and applications, businesses, and organizations use databases to store their data. while everything is moving online in a rapid manner managing databases becomes a challenge for organizations. Google Cloud Platform solves all major Relational database problems by introducing their Cloud SQL. Cloud SQL supports all major RDBMS and provides migration from offline databases. In this article, we will learn how businesses can use Cloud SQL to create databases and manage Relational Databases and use their most of time on business logic rather than investing in managing Databases.