PlanetScale introduces Rewind characteristic to ‘undo’ dangerous schema migrations

PlanetScale is including a Rewind characteristic to its serverless MySQL database-as-a-service, permitting customers to ‘revert modifications’ as much as half-hour after a schema migration deployment request is made.

PlanetScale desires to assist database directors or devops professionals to simply ‘undo’ dangerous schema migrations earlier, with out the ache of manually rolling again and inflicting downtime or knowledge loss points for the enterprise.

“PlanetScale Rewind offers customers the power to undo a foul migration simply as simply as you undo a typo,” mentioned Nick Van Wiggeren, vice chairman of engineering at PlanetScale. “As an alternative of getting to go restart your entire course of, think about for those who may simply click on a button — like Management-Z — and get it again to the place it was whenever you began however, notably, with out dropping a byte of information.”

PlanetScale

Whereas different database-as-a-service suppliers have given customers the power to revert to a snapshot, which usually entailed dropping some knowledge through the deployment or migration course of, PlanetScale claims its Rewind characteristic is an trade first because of the pace at which clients can reverse modifications with out dropping knowledge.

The characteristic is powered by VReplication, a local functionality of the open supply clustering and administration system Vitess, which underpins the PlanetScale database and which allows quicker migrations and due to this fact faster rollbacks as wanted.

“VReplication may be setup emigrate knowledge from an present system into Vitess. The replication may be reversed after a cutover supplying you with the choice to rollback a migration cutover if one thing went unsuitable, with out dropping the writes to the migration goal,” a Vitess weblog publish claims.

PlanetScale refers to itself as “the database for builders,” and Stephen O’Grady, principal analyst at developer-focused analyst agency RedMonk, mentioned that, “what PlanetScale is saying in the present day is geared toward doing simply that: enhancing the developer expertise of utilizing a database.”