https://bugzilla.wikimedia.org/show_bug.cgi?id=30824

--- Comment #1 from Brion Vibber <[email protected]> 2011-09-09 23:14:21 UTC 
---
tl;dr summary:

This Online Schema Change tool is a PHP script which manages cloning a table,
applying an ALTER TABLE, and then swapping it back in place.

This runs online -- not interfering with live operations on the main tables --
by using triggers to capture changes made to the original table while the new
table is being changed.

Note that in a replicated environment, you need to run this on all slaves
before running on the master -- but unlike our prior schema update methods, it
doesn't require halting replication while running, or switching masters.


Sounds pretty spiffy!

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to