J
James Palmer
Guest
I've updated my public email - sorry about that. Unfortunately I am not at liberty to share the script. I can share the basic steps though... - create a dummy db with a dummy structure and full df. - dump a delta df between the 2 databases - load the new schema into the primary database You can see it's quite simple. Obviously you'll want to build extra logic around that in case things fail, but it's the essence. Remember that if you use online schema change, that no other client can be connected to the database or you'll just eventually hit the lock wait timeout and nothing will happen.
Continue reading...
Continue reading...