	In Browser
	StumbleUpon
	del.icio.us
	Google
	Google Buzz
	reddit
	LinkedIn

	Facebook
	Twitter
	Linkedin
	E-Mail

Cloud Platforms > Google Cloud Platform (GCP) > Cloud SQL

Cloud SQL

Author: Venkata Sudhakar

Google Cloud SQL is a fully managed relational database service that supports MySQL, PostgreSQL, and SQL Server. It handles replication, patch management, and database management so you can focus on building applications.

Key Features:

1. Fully managed - Automated backups, replication, encryption, and failover.

2. Multiple engines - Supports MySQL 5.7/8.0, PostgreSQL 9.6 - 15, SQL Server 2017/2019.

3. High availability - Regional persistent disk ensures 99.95% uptime SLA.

4. Scalable - Scale storage up to 64TB and compute up to 96 vCPUs.

5. Secure - Data encrypted at rest and in transit; IAM integration for access control.

The below example shows how to connect to Cloud SQL PostgreSQL and run queries using Java.

import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class CloudSQLExample {
    public static void main(String[] args) throws Exception {
        HikariConfig config = new HikariConfig();

// Use Cloud SQL Socket Factory for secure connection
        config.setJdbcUrl("jdbc:postgresql:///my_database");
        config.setUsername("app_user");
        config.setPassword("app_password");
        config.addDataSourceProperty("socketFactory",
            "com.google.cloud.sql.postgres.SocketFactory");
        config.addDataSourceProperty("cloudSqlInstance",
            "my-project:us-central1:my-postgres-instance");

HikariDataSource ds = new HikariDataSource(config);

try (Connection conn = ds.getConnection()) {
            // Create table
            conn.createStatement().execute(
                "CREATE TABLE IF NOT EXISTS employees (" +
                "id SERIAL PRIMARY KEY, name VARCHAR(100), department VARCHAR(50), salary DECIMAL)");

// Insert data
            PreparedStatement ps = conn.prepareStatement(
                "INSERT INTO employees (name, department, salary) VALUES (?, ?, ?)");
            ps.setString(1, "Alice Smith"); ps.setString(2, "Engineering"); ps.setDouble(3, 95000);
            ps.executeUpdate();
            System.out.println("Inserted employee record");

// Query data
            ResultSet rs = conn.createStatement().executeQuery(
                "SELECT name, department, salary FROM employees ORDER BY salary DESC");
            while (rs.next()) {
                System.out.printf("%-15s %-15s $%.2f%n",
                    rs.getString("name"), rs.getString("department"), rs.getDouble("salary"));
            }
        }
        ds.close();
    }
}

It gives the following output,

Inserted employee record
Alice Smith     Engineering     $95000.00

Cloud SQL vs Cloud Spanner:

Cloud SQL - Regional relational database; best for traditional OLTP workloads up to a few TB. Lower cost, familiar MySQL/PostgreSQL/SQL Server engines.

Cloud Spanner - Globally distributed, horizontally scalable relational database; best for planet-scale workloads requiring strong consistency and 99.999% availability.

Send your comments, suggestions or queries regarding this site to [email protected].