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

	Facebook
	Twitter
	Linkedin
	E-Mail

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

Cloud Spanner

Author: Venkata Sudhakar

Google Cloud Spanner is a fully managed, mission-critical relational database service that offers transactional consistency at global scale. It combines the benefits of relational databases (ACID transactions, SQL queries) with the horizontal scalability of NoSQL databases.

Key Features:

1. Global distribution - Replicate data across regions and continents with strong consistency.

2. 99.999% availability - Five nines SLA with zero planned downtime for maintenance.

3. Horizontal scaling - Scale reads and writes linearly by adding nodes.

4. ACID transactions - Supports serializable isolation across distributed nodes.

5. Standard SQL - ANSI SQL with extensions; supports interleaved tables for performance.

The below example shows how to insert and query data in Cloud Spanner using the Java client library.

import com.google.cloud.spanner.*;
import java.util.Arrays;

public class CloudSpannerExample {
    public static void main(String[] args) {
        SpannerOptions options = SpannerOptions.newBuilder().build();
        Spanner spanner = options.getService();
        DatabaseId db = DatabaseId.of("my-project", "my-instance", "my-database");

try (DatabaseClient client = spanner.getDatabaseClient(db)) {
            // Write using mutation
            client.write(Arrays.asList(
                Mutation.newInsertOrUpdateBuilder("Employees")
                    .set("EmployeeId").to(1L)
                    .set("Name").to("Jane Doe")
                    .set("Department").to("Engineering")
                    .set("Salary").to(120000.0)
                    .build()
            ));
            System.out.println("Employee inserted successfully");

// Query using SQL
            try (ResultSet rs = client.singleUse().executeQuery(
                    Statement.of("SELECT EmployeeId, Name, Department, Salary FROM Employees ORDER BY Salary DESC"))) {
                System.out.println("Employees:");
                while (rs.next()) {
                    System.out.printf("  %d | %-15s | %-15s | $%.2f%n",
                        rs.getLong("EmployeeId"), rs.getString("Name"),
                        rs.getString("Department"), rs.getDouble("Salary"));
                }
            }
        } finally {
            spanner.close();
        }
    }
}

It gives the following output,

Employee inserted successfully
Employees:
  1 | Jane Doe        | Engineering     | $120000.00

When to use Cloud Spanner:

Use Cloud Spanner when you need global scale, strong consistency, and high availability for mission-critical OLTP workloads such as financial ledgers, global inventory management, and multi-region user data stores that cannot tolerate data inconsistency or downtime.

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