PlanetScale introduces Rewind feature to ‘undo’ bad schema migrations

PlanetScale is introducing a Rewind element to its serverless MySQL databases-as-a-company, making it possible for buyers to ‘revert changes’ up to 30 minutes following a schema migration deployment request is produced.

PlanetScale needs to support databases directors or devops experts to simply ‘undo’ lousy schema migrations before, without having the discomfort of manually rolling back and resulting in downtime or data decline problems for the company.

“PlanetScale Rewind offers consumers the potential to undo a bad migration just as very easily as you undo a typo,” said Nick Van Wiggeren, vice president of engineering at PlanetScale. “Instead of getting to go restart the whole approach, consider if you could just simply click a button — like Handle-Z — and get it back again to the place it was when you begun but, notably, without having dropping a byte of data.”

PlanetScale

Whilst other databases-as-a-assistance vendors have specified end users the capability to revert to a snapshot, which typically entailed shedding some information for the duration of the deployment or migration procedure, PlanetScale claims its Rewind characteristic is an field to start with owing to the pace at which shoppers can reverse modifications without losing data.

The element is driven by VReplication, a native functionality of the open resource clustering and management process Vitess, which underpins the PlanetScale database and which enables faster migrations and thus more quickly rollbacks as needed.

“VReplication can be set up to migrate facts from an current procedure into Vitess. The replication could also be reversed after a cutover supplying you the alternative to rollback a migration cutover if anything went incorrect, without the need of shedding the writes to the migration target,” a Vitess web site article claims.

PlanetScale refers to itself as “the databases for builders,” and Stephen O’Grady, principal analyst at developer-targeted analyst firm RedMonk, stated that, “what PlanetScale is asserting today is aimed at undertaking just that: improving the developer knowledge of applying a databases.”