Playing with Cloud SQL - 2 | Scribe

    Playing with Cloud SQL - 2

    • Hafeez Baig |
    • 33 steps |
    • 3 minutes
    information ordinal icon
    Refer to this guide to learn about Playing with Cloud SQL\ <https://scribehow.com/shared/Playing_with_Cloud_SQL__CVgt3U6OS-Cscv-h8a5UlA>
    1
    Sign in into the **Google Cloud Platform**
    2
    Type "**SQL**" in the search bar and click on the **SQL** option
    information ordinal icon
    **What is SQL?**\ \ In Google Cloud Platform (GCP), SQL refers to the managed relational database services provided through Cloud SQL. Cloud SQL supports popular SQL-based databases like MySQL, PostgreSQL, and SQL Server, allowing users to set up, maintain, manage, and administer relational databases in the cloud. It offers automatic backups, scaling, patch management, and high availability, making it easier to run and manage SQL databases without handling the underlying infrastructure.
    3
    **Instances** wizard will open, click on the **my-first-cloud-sql-instance**
    4
    **my-first-cloud-sql-instances** wizard will open, on the right side you can view the monitoring chart for the sql
    5
    Scroll to the **Connect to this instances** section, here you can view the details to connect to your sql instance
    6
    Scroll to the **Configuration** section, here you can view the configuration details of the instance
    7
    Scroll to the **Operations and logs** section, here you can view the logs and operations details
    information ordinal icon
    **What is Operations and logs?**\ \ In GCP Cloud SQL, "Operations and logs" provide essential monitoring and management tools for SQL instances. Operations record administrative actions like instance creation, configuration changes, and backups, helping track changes over time. Logs include error, general query, and slow query logs, offering insights into performance and helping diagnose issues. Together, they help maintain the health, performance, and security of your Cloud SQL instances.
    8
    Scroll to the **Maintenance** section, here you can view the Maintenance details
    9
    Click on the **Connections** from the left bar
    information ordinal icon
    **What are Connections?**\ \ In GCP Cloud SQL, "Connections" are the network links between clients (applications, services, or users) and the Cloud SQL instance. They enable interaction with the database for executing queries and retrieving data. GCP provides connection methods like Public IP for internet access, Private IP for secure internal access via VPC, and Cloud SQL Proxy for simplified, encrypted connections. Proper management of these connections is essential for maintaining database performance and security.
    10
    **Connections** wizard will open, here you can view all the connections details
    11
    Click on the **Users** from the left bar
    information ordinal icon
    **Whar are Users?**\ \ In Google Cloud Platform (GCP) Cloud SQL, "Users" are database accounts that have specific permissions and roles to interact with the SQL instance. Each user has a unique username and password, which they use to authenticate and connect to the database. Users can be granted varying levels of access, such as reading, writing, or administering data, allowing for secure and controlled interactions with the database. Managing users effectively helps ensure data security and proper access control within the Cloud SQL environment.
    12
    **Users** wizard will open, here you can view all the User Account details
    13
    Click on the **Databases** from the left bar
    information ordinal icon
    **What are Databases?**\ \ In Google Cloud Platform (GCP) Cloud SQL, "Databases" are organized collections of structured data within a Cloud SQL instance. They store data in tables with rows and columns, enabling efficient data management, querying, and analysis. A single Cloud SQL instance can host multiple databases, each with its own schema, tables, and data. These databases can be managed using SQL commands to perform operations like data retrieval, updates, and deletions. Managing databases in Cloud SQL allows for scalable, secure, and reliable storage and access to structured data.
    14
    **Databases** wizard will open, here you can view all the Databases for the SQL Instance