PlanetScale introduces Rewind feature to ‘undo’ bad schema migrations

A man looks displeased/stressed/frustrated and pinches his brow while using a computer at work.

PlanetScale is adding a Rewind feature to its serverless MySQL databases-as-a-services, permitting end users to ‘revert changes’ up to 30 minutes immediately after a schema migration deployment ask for is made.

PlanetScale desires to enable database administrators or devops pros to very easily ‘undo’ poor schema migrations earlier, with no the discomfort of manually rolling back and triggering downtime or data reduction issues for the small business.

PlanetScale Rewind offers people the skill to undo a terrible migration just as easily as you undo a typo,” claimed Nick Van Wiggeren, vice president of engineering at PlanetScale. “Instead of obtaining to go restart the overall system, think about if you could just simply click a button — like Control-Z — and get it again to wherever it was when you begun but, notably, without having shedding a byte of data.”

pscale rewind 2 PlanetScale

PlanetScale Rewind attribute

Although other databases-as-a-assistance suppliers have supplied users the ability to revert to a snapshot, which generally entailed getting rid of some knowledge throughout the deployment or migration procedure, PlanetScale statements its Rewind feature is an business 1st thanks to the pace at which shoppers can reverse improvements without getting rid of information.

The attribute is powered by VReplication, a indigenous capability of the open up resource clustering and administration technique Vitess, which underpins the PlanetScale database and which enables more quickly migrations and as a result quicker rollbacks as desired.

“VReplication can be setup to migrate knowledge from an present program into Vitess. The replication could also be reversed after a cutover providing you the choice to rollback a migration cutover if one thing went incorrect, with no getting rid of the writes to the migration focus on,” a Vitess site submit claims.

PlanetScale refers to itself as “the database for developers,” and Stephen O’Grady, principal analyst at developer-concentrated analyst business RedMonk, said that, “what PlanetScale is saying nowadays is aimed at executing just that: improving upon the developer working experience of applying a databases.”

Copyright © 2022 IDG Communications, Inc.

Source backlink