Managed cloud database services: what was new in 2020

2020 was a 12 months not like every other, and all its unexpectedness introduced foundational enterprise know-how into the highlight. Companies wanted their databases to be dependable, scalable, and persistently well-performing. In consequence, migration plans accelerated, inflexible licensing fell additional out of favor, and transformative utility improvement sped up. This was clear even in 2019, when cloud database administration system (DBMS) revenues have been $17 billion, up 54% from 2018, in response to Gartner Predicts. We’ll be desperate to see what Gartner stories from 2020, however from our perspective, progress accelerated considerably this 12 months. 

We consider that our knowledge imaginative and prescient of openness and suppleness was mirrored within the first-ever DBMS Magic Quadrant this 12 months. Gartner named Google Cloud a Chief in DBMS for 2020. 

We heard from prospects throughout industries that this was the 12 months they began or stepped up their database modernization. To assist them meet their mission-critical targets, Google Cloud continued to launch new merchandise and options. Right here’s what was new and notable this 12 months.

New choices, new flexibility entered the cloud database scene

Database migration service now obtainable for Cloud SQL
Database migrations could be a problem for enterprises. We give our prospects a uniquely simple, safe, and dependable expertise with the current launch of our serverless Database Migration Service (DMS), which supplies high-fidelity, minimal downtime migrations for MySQL and PostgreSQL workloads and is designed to be really cloud-native. Our weblog asserting the launch has extra information, and steps to get you began. 

SQL Server, managed within the cloud
Enterprise corporations usually inform us how vital the flexibility emigrate to Cloud SQL for SQL Server is to their bigger targets of infrastructure modernization and a multi-cloud technique. Cloud SQL for SQL Server is now typically obtainable globally that will help you preserve your SQL Server workloads operating. Our weblog on the topic lists the 5 steps to get began migrating, a hyperlink to the total migration information, and a useful video for extra particulars. 

Naked Steel Answer for Oracle databases comes to 5 new Google Cloud areas
Naked Steel Answer lets companies run specialised workloads reminiscent of Oracle databases in Google Cloud Regional Extensions, whereas reducing general prices and lowering dangers related to migration. Final 12 months we introduced the provision of Naked Steel Answer in 5 extra areas: Ashburn, Virginia; Frankfurt; London; Los Angeles, California; and Sydney. We additionally launched 4 extra websites this 12 months: Amsterdam, São Paulo, Singapore, and Tokyo. 

Clients did wonderful issues with cloud databases in 2020

We’ve seen some clear tendencies emerge in cloud migration. We’ve seen prospects observe what we’re referring to as a three-phase journey: migration, once they transition massive industrial and open supply databases; modernization, which entails transferring from legacy to open supply databases; and transformation, constructing next-gen functions and opening up new prospects. Wherever you’re on this journey, Google Cloud is concentrated on supporting you with the providers, greatest practices, and tooling ecosystem to allow your success.

At pharmaceutical and pharmacy know-how large McKesson, groups selected Cloud SQL to modernize their legacy surroundings. 3D printing and design firm Makerbot shared how they architected Google Cloud’s tightly built-in instruments—together with Google Kubernetes Engine (GKE), Pub/Sub, and Cloud SQL—for an progressive autoscaling answer.

We heard from Bluecore, developer of a advertising platform for big retailers that delivers campaigns by means of predictive knowledge fashions, about how they turned to Cloud SQL for a totally managed answer that provided marketing campaign creation performance with out slowing down the retail model’s web site. Clients like Handshake, supplier of a platform to attach universities, additionally selected a Cloud SQL migration. Monetary options supplier Freedom Monetary Community switched from Rackspace to Cloud SQL to fulfill rising demand. 

And at Google Cloud Subsequent ‘20: OnAir, we heard from ShareChat and The New York Occasions concerning the successes they’ve discovered utilizing our cloud-native databases. We additionally heard from Khan Academy, which makes use of Cloud Firestore to assist meet the rising demand for on-line studying. 

Enterprise readiness arrived for open supply databases

Within the occasion of a regional outage in Google Cloud, you need your utility and database to rapidly begin serving your prospects in one other obtainable area. This 12 months, we launched Cloud SQL cross-region replication, obtainable for MySQL and PostgreSQL database engines. We’ve labored intently with Cloud SQL prospects dealing with enterprise continuity challenges to simplify the expertise, and our weblog explains get began and affords a have a look at how Main League Baseball places cross-region replication to make use of.

As well as, Cloud SQL added dedicated use reductions in addition to extra upkeep controls, serverless exports, and point-in-time-recovery for Postgres.

This previous fall, we introduced that Cloud SQL now helps MySQL eight. You now have entry to a wide range of highly effective new options for higher productiveness—reminiscent of on the spot DDL statements (e.g. ADD COLUMN), atomic DDL, privilege assortment utilizing roles, window capabilities, and prolonged JSON syntax. Try the total record of latest options. 

Cloud SQL database service provides PostgreSQL 13
We additionally launched assist in Cloud SQL for PostgreSQL 13, providing you with entry to the most recent options of PostgreSQL whereas letting Cloud SQL deal with the heavy operational lifting. Latest PostgreSQL 13 efficiency enhancements throughout the board embrace enhanced partitioning capabilities, elevated index and vacuum effectivity, and higher prolonged monitoring. Our current weblog has extra particulars, extra options, and directions for getting began. 

Instruments for measuring efficiency of Memorystore for Redis
A preferred open supply in-memory knowledge retailer, Redis is used as a database, cache, and message dealer. Memorystore for Redis is Google Cloud’s totally managed Redis service. Memorystore not too long ago added assist for Redis 5.zero, in addition to VPC service controls, Redis Auth and TLS encryption. You’ll see how one can measure the efficiency of Memorystore for Redis, in addition to efficiency tuning greatest practices for reminiscence administration, question optimizations, and extra. 

Cloud-native databases: trusted for enterprise workloads, higher for builders 

Google Cloud Spanner is the one managed relational database with limitless scale, robust consistency, and 99.999% availability. (Try extra particulars on what’s new in Spanner.) In 2020, we introduced new enterprise capabilities for Spanner, together with the overall availability of managed backup-restore and 9 new multi-regions of Spanner that provide 99.999% availability. Spanner additionally launched assist for brand new SQL capabilities, together with question optimizer versioning, international keys, examine constraints, and generated columns. Plus, Spanner launched the C++ consumer library for C++ utility builders and native Emulator that permits you to develop and take a look at your functions utilizing a neighborhood emulator, serving to cut back utility improvement prices. 

Bigtable, our totally managed NoSQL database service, now affords managed backups for top enterprise continuity and lets customers add knowledge safety to workloads with minimal administration overhead. Bigtable expanded its assist for smaller workloads, letting you create manufacturing cases with one or two nodes per cluster, down from the earlier minimal of three nodes per cluster.

Firestore, which lets cellular and internet builders construct apps simply, added new options such because the Guidelines Playground, letting you take a look at your up to date Firebase Safety guidelines rapidly. The Firestore Unity SDK, added this 12 months, makes it simple for recreation builders to undertake Firestore. As well as, Firestore launched a C++ consumer library and affords a richer question language with a variety of latest operators, together with not-in, array-contains, not-equal, lower than, better than, and others. 

That’s a wrap for the 12 months in databases. Keep tuned to the Google Cloud Weblog for up-to-the-minute bulletins, launches, and greatest practices for 2021. 

^{Gartner, Magic Quadrant for Cloud Database Administration Methods, November 23, 2020, Donald Feinberg, Adam Ronthal, Merv Adrian, Henry Cook dinner, Rick Greenwald}

^{Gartner doesn’t endorse any vendor, services or products depicted in its analysis publications and doesn’t advise know-how customers to pick solely these distributors with the best scores or different designation. Gartner analysis publications include the opinions of Gartner’s analysis group and shouldn’t be construed as statements of truth. Gartner disclaims all warranties, expressed or implied, with respect to this analysis, together with any warranties of merchantability or health for a selected objective}