Skip to main content

Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More - InfoQ.com

xmlns="http://www.w3.org/1999/xhtml" id="emailbody" style="margin:0 2em;font-family:Georgia,Helvetica,Arial,Sans-Serif;line-height:140%;font-size:13px;color:#000000;">

Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More - InfoQ.com


xmlns="">

Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More - InfoQ.com

Posted: 01 May 2020 07:01 AM PDT

In a recent blog post, Google announced a slew of new features for Cloud Spanner. The public cloud provider released the service with new updates including the managed backup-restore feature, foreign key support, query optimizer versioning feature, a C++ client library, and a local emulator.

Cloud Spanner is a globally distributed, scalable, multi-version database service on the Google Cloud Platform (GCP).  Since its inception, Google keeps evolving the database service since its beta with updates such as updates to its data manipulating (DML) SQL language, and new regions, and multi-region configurations. Now, it further enhances Cloud Spanner with another set of updates.

The most important new feature is the managed backup-restore, which is now generally available and provides protection against user or application errors that result in logical data corruption. With the managed backup-restore users can take a consistent, on-demand backup of databases in their regional or multi-regional configurations and restore those backups onto the same or different instance with the same instance configuration. Furthermore, these restores are optimized to reduce the time to first-byte access to the data in a backup – which means users can get access to terabytes of data being restored from a backup within minutes after failure according to the blog post.

Users can get access to the managed backup-restore via client libraries, gcloud, and cloud console, and use the feature to back up and restore their databases, regardless of size.


Source: https://cloud.google.com/blog/products/databases/native-cloud-database-spanner-adds-features

Next to the introduction of the managed backup-restore capability, Google also added new features to add more reliability, flexibility, and ease of use when developing applications with Spanner. These new generally available features are:

  • Foreign keys: Allowing users to define referential integrity constraints between columns in different tables.
  • C++ client library: Supporting C++ application development for Spanner and including best practices such as session pool management and retry logic.
  • Query optimizer versioning: Allowing users more control running their database, application, and queries with specific optimizer versions that produce the best performance, and switching between the new version or prior versions at their convenience. Also, Jaana Dogan, engineer on Spanner at Google, said in a tweet:

You can also write standalone tools to see the improvements/regressions for your queries via the execution stats. http://github.com/rakyll/spannerbench

Lastly, another update is the new local emulator feature, which is currently in beta and useful for local testing purposes. The emulator can run in an offline environment and emulates the Spanner API (both REST and gRPC) and SQL layer. Sneha Shah, software engineer at Google, stated in a Medium blog post on the Cloud Spanner local emulator:

Cloud Spanner emulator reduces application development cost and improves developer productivity for Cloud Spanner customers. We plan to continue building, and supporting customer-requested features, and you can follow Cloud Spanner emulator on GitHub for more updates.

For more details about the pricing of Cloud Spanner, see the pricing page.


Comments

Popular posts from this blog

30+ Fashion Brands Pivoting To Make Stylish Coronavirus Masks - Forbes

xmlns="http://www.w3.org/1999/xhtml" id="emailbody" style="margin:0 2em;font-family:Georgia,Helvetica,Arial,Sans-Serif;line-height:140%;font-size:13px;color:#000000;"> 30+ Fashion Brands Pivoting To Make Stylish Coronavirus Masks - Forbes xmlns=""> 30+ Fashion Brands Pivoting To Make Stylish Coronavirus Masks - Forbes Posted: 12 Apr 2020 04:25 PM PDT Aplat custom face mask Aplat For many fashion, handbag and accessories brands, the spread of COVID-19 has meant shuttering their brick and mortar shops and facing dwindling online sales. By pivoting to make face masks instead, many are finding a way to keep their businesses going while also serving a great need. With healthcare workers facing critical shortages of face masks during the coronavirus pandemic, people like fashion designer Dexter Flawk are dealing with their own anxiety by directing their energy towards making ...

Apple's new iCloud feature for iPhone, iPad and Mac will have you kissing Dropbox goodbye - CNET

xmlns="http://www.w3.org/1999/xhtml" id="emailbody" style="margin:0 2em;font-family:Georgia,Helvetica,Arial,Sans-Serif;line-height:140%;font-size:13px;color:#000000;"> Apple's new iCloud feature for iPhone, iPad and Mac will have you kissing Dropbox goodbye - CNET xmlns=""> Apple's new iCloud feature for iPhone, iPad and Mac will have you kissing Dropbox goodbye - CNET Posted: 13 Apr 2020 03:29 PM PDT Jason Cipriani/CNET At the end of March , Apple gave  iPhone , iPad  and  Mac owners yet another option to share folders of important documents and photos. Instead of relying on third-party service such as Dropbox , a software update from Apple  added the ability to use your iCloud Drive storage to share a folder, whether it's a work presentation, a collection of GIFs between friends or your kid's remote learning homework.  Not too long ago, Dropbox ...

HPAPI Drug Manufacturing Trends - Contract Pharma

Highly potent API (HPAPI) drugs make up a growing percentage of the small molecule drug development pipeline and this group of products is growing faster than the overall small molecule segment, 1 largely due to their usefulness in cancer treatments. Many of these drugs have accelerated timelines for approval and commercial development, which can be challenging for drug developers to keep up with. On the front-end, new technologies such as in-silico prediction tools contribute to shortening candidate selection, 2 while Artificial Intelligence (AI) has already brought a first candidate into clinical development. 3 On the back-end, regulatory drug approval timelines are being increasingly shortened: when analyzing drug approvals in 2019, almost three-quarters of drugs approved (71%) were approved under Priority Review. 4 A related trend is increasing competition in the oncology field, with 80% of new IND’s now belonging to small, emerging or virtual biotech companies. 5 These firms o...