- Published on
Google Cloud Platform - GCP
- Authors
- Name
- Jackson Chen
Cloud SQL
Cloud SQL scales up in minutes and replicates data across zones and regions. It uses agents for maintenance, logging, monitoring, and configuration, with services backed by a 24/7 SRE team. Manage your database via the console, CLI, or REST API and connect your app via standard database drivers.
Features
No matter where your database is located—whether on-premises, on Compute Engine, or in other clouds—Database Migration Service (DMS) can migrate it securely and with minimal downtime. DMS leverages the native replication capabilities of the source database to maximize the reliability of your migration. And it’s available at no additional charge for migrations to Cloud SQL.
Integration Cloud SQL seamlessly integrates with Google Cloud services such as Compute Engine, Cloud Run, Google Kubernetes Engine, and Cloud IAM, allowing developers to build and deploy applications with ease. Provision your database via APIs and third-party tools, and use federated queries from BigQuery and low-latency database replication with Datastream for near real-time insights on operational data.
Open and stanards-based Cloud SQL supports the most popular open source and commercial engines, including MySQL, PostgreSQL, and SQL Server with rich support for extensions, configuration flags, and popular developer tools. It's easy to get started—simply bring your existing skills over and enjoy the flexibility to work the way you want. You can create a database with just a few clicks in the console and connect your application.
Easy migrations No matter where your database is located—whether on-premises, on Compute Engine, or in other clouds—Database Migration Service (DMS) can migrate it securely and with minimal downtime. DMS leverages the native replication capabilities of the source database to maximize the reliability of your migration. And it’s available at no additional charge for migrations to Cloud SQL.
Secure access and connectivity Cloud SQL data is encrypted when on Google’s internal networks and when stored in database tables, temporary files, and backups. It supports private connectivity with Virtual Private Cloud (VPC), and every Cloud SQL instance includes a network firewall, allowing you to control public network access.
Database migration
https://cloud.google.com/sql#database-migration
Self-managing a database such as MySQL, PostgreSQL, or SQL Server can be inefficient and expensive, with significant effort around patching, hardware maintenance, backups, and tuning. Migrating to a fully managed solution has never been simpler—you can lift and shift your database from any on-premises or cloud location using Database Migration Service with minimal downtime.
Cloud SQL documentation
https://cloud.google.com/sql/docs
postgres SQL
https://cloud.google.com/sql/docs/postgres
Cloud SQL for PostgreSQL is a fully-managed database service that helps you set up, maintain, manage, and administer your PostgreSQL relational databases on Google Cloud Platform.
SQL
https://cloud.google.com/sql/docs/sqlserver
Cloud SQL for SQL Server is a managed database service that helps you set up, maintain, manage, and administer your SQL Server databases on Google Cloud. For information specific to Microsoft SQL Server.
gcloud CLI
https://cloud.google.com/sdk/gcloud
https://cloud.google.com/sql/docs/mysql/cloud-sdk
Use gcloud CLI to manage the cloud SQL instances, he gcloud CLI uses the Cloud SQL Admin API to access Cloud SQL, so you must enable the API before you can use the gcloud CLI to access Cloud SQL.
Getting started with the gcloud CLI
To start with the gcloud CLI, review the gcloud CLI Documentation. You can get help for the tool, resources, and commands
gcloud sql --help
gcloud sql instances --help
gcloud sql instances create --help
Configure a project as your default project with two commands. The first command below lists the configuration for the gcloud CLI, including any default project already set. The second command sets the default project.
gcloud config list
gcloud config set project [PROJECT_ID]
gcloud sql reference
https://cloud.google.com/sdk/gcloud/reference/sql