Revert a migration without losing data

Unhealthy migrations occur every single day and knowledge loss will be devastating. PlanetScale’s new Rewind characteristic provides you the facility to revert modifications after a schema migration with no downtime and 0 knowledge loss.

What’s Rewind?

Have you ever ever made a schema change, like altering a column’s knowledge kind or dropping a desk, that broke your manufacturing utility inflicting unplanned downtime, and even worse, a full-scale outage? And as soon as it was reside, you instantly wished you might return in time, with out shedding any knowledge that was added through the damaged interval?

Your want has come true. PlanetScale’s new Rewind characteristic lets you revert a migration with zero knowledge loss.

Rewind allows one thing by no means attainable earlier than: The power to revert your database’s schema modifications in lower than a minute with the press of a button with no downtime or knowledge loss. Beforehand, for those who dropped the mistaken index, operating a brand new migration may take you a number of hours to repair. Even worse, for those who dropped the mistaken column or desk and needed to restore from a backup, it could take days or perhaps weeks to roll out. And what occurs to your knowledge and your utility whereas it’s being mounted? With Rewind, you don’t want to fret about downtime or knowledge loss.

Rewind opens the door to a brand new stage of velocity and energy to your engineering crew. Together with current PlanetScale options similar to Branching and Deploy Requests, you can also make modifications (and repair modifications) in your database sooner and safer than earlier than. It not solely saves you time, but it surely makes schema modifications much less scary as a result of you may deal with your database such as you deal with your code. Until you constructed customized in-house tooling to your database, these workflows haven’t been attainable earlier than.

We’re freely giving limited-edition, retro Rewind t-shirts to the primary 100 people who efficiently revert a schema change or share a couple of time that Rewind would have helped you.

All you need to do is:

  • Deploy a schema change
  • Revert it in seconds
  • Take a screenshot/video
  • Share on Twitter and tag @planetscaledata


  • Share on Twitter a couple of time that Rewind would have helped you revert a schema change in manufacturing and tag @planetscaledata

This giveaway is US solely whereas provides final. Void the place prohibited; one per family.


How does it work?


After you might have accomplished a deploy request, it is possible for you to to revert to a clear state of the database earlier than the schema modifications. This contains any knowledge that will have been eliminated within the deploy request. Any database enrolled within the restricted beta will see a “Revert modifications” button accessible on the related deploy request web page for half-hour after the modifications have been deployed. As soon as the “Revert modifications” button is chosen, it’s deployed instantly.

For instance, for those who take away a column and its related knowledge in a deploy request then revert with Rewind, your column and its related knowledge will seem once more in seconds.

Rewind is feasible due to VReplication in Vitess, the database clustering and administration system that powers PlanetScale databases alongside MySQL. Vitess’ VReplication additionally powers options like Database Imports. VReplication makes use of a lossless sync within the background between legitimate states of the database. It copies knowledge from the supply to the vacation spot desk in a constant trend. VReplication’s implementation is exclusive as a result of it permits us to go right down to the MySQL transaction stage, guaranteeing no knowledge is misplaced and that your database schema returns to its earlier state earlier than the schema change. All in simply seconds.

For a extra in-depth take a look at how Rewind works, check out the Behind the scenes: how we built Rewind blog post.


Need to see it in motion?


Join the restricted beta to check it out your self! Sign up or log into PlanetScale and choose into the restricted beta in your database’s Settings tab. Within the Beta options part, choose “Enroll this database within the Rewind restricted beta.” When you create a database department with modifications to your schema, deploy the deploy request, after which Rewind!

For extra info, try our Deploy requests – Revert a schema change documentation.

We are able to’t wait to listen to what you concentrate on Rewind!


Restricted version, Rewind t-shirt giveaway


We’re freely giving limited-edition, retro Rewind t-shirts to the primary 100 people who efficiently revert a schema change or share a couple of time that Rewind would have helped you.

Leave a Reply

Your email address will not be published.