Google lets three enterprise cloud databases loose

Google lets three enterprise cloud databases loose

Google has made three new enterprise database offerings generally available, hoping to lure customers currently on Amazon Web Services and Microsoft’s Azure platforms over to its Compute Engine service.

The three offerings include the fully managed Cloud SQL Second Generation with MySQL instances, the Cloud Bigtable noSQL wide-column service with Apache HBase compability, and the Cloud Datastore, a scalable, NoSQL document database.

Pricing for Cloud SQL 2nd Generation starts at US$0.015 per hour for 0.6 gigabytes of memory, shared virtual processor, and maximum 3TB capacity for the smallest, db-f1-micro instance.

This goes up to US$2.012 per hour for the db-n-highmem-16 instance, with 16 VCPUs, 104GB of RAM and up to 10TB of storage. In addition, Google charges US$0.17 per GB and month for storage capacity, and US$0.08 per GB and month for backups.

Bigtable nodes cost US$0.65 per node and hour, with a minimum of three required per cluster. Each node can delivery up to 10,000 queries per second and 10 Mbps data transfers.

Storage for Bigtable on solid state disks is charged at US$0.17 per GB and month, with the hard drive equivalent service costing US$0.026 per GB and month. Australian customers pay US$0.19 per GB for up to 1TB of internet egress traffic, which drops to US$0.18/GB for 1 to 10TB, and US$0.15/GB for more than 10TB.

Cloud Datastore is free for up to 1GB of storage, 50,000/20,000/20,000 entity reads/writes/deletes, with additional charges once those limits are reached.

Customers wanting to run their own databases on the Google Compute Engine can now use Microsoft SQL Service images with built-in licenses. Business can also use their own, existing application licenses.

Google claimed that its Cloud SQL 2nd Gen database provides substantially better performance than Amazon’s RDS MSQL Multi-Availability Zone and RDS Aurora databases – up to 16 concurrent threads, as measured with the Sysbench benchmark.

Beyond 16 concurrent threads the AWS databases were slightly better than Cloud SQL 2nd Gen. In terms of transactions per second, Sysbench testing showed AWS Aurora to be the leader beyond 16 concurrent threads.

Some of the performance difference is due to design decisions for the databases: Google’s SQL 2nd Gen emphasises performance and allows for replication lag which can increase failover times albeit won’t put data at risk, Google said.

AWS Aurora, meanwhile, is designed with replication technology that exhibits minimal performance variation and consistent lag.

Google also said the Cloud SQL 2nd Gen replicated database had about half the end-to-end latency for single client threads compared to AWS RDS for MySQL Multi-Availability Zone, at 32.02ms – substantially better than the 70.12ms measured for AWS RDS Aurora.