Massive Schema Changes in Facebook Jesse Salomon, Junyi Lu - PowerPoint PPT Presentation

Automatic OSC User Interface AOSC Server ~/mysql-schemas $ ... ~ $ aosc allow xdb.food apple ... ~/mysql-schemas $ git diff CREATE TABLE `apple` ( ~ $ aosc cancel xdb.food apple `id` int(11) AUTO_INCREMENT, ... `name` varchar(32), `quantity` int(11), ~ $ aosc hold xdb.food apple + `color` enum('red','green'), ... PRIMARY KEY (`id`) ) ENGINE=RocksDB ~ $ aosc continue xdb.food apple ...

Automatic OSC Global Coordination AOSC Server Finished Pending Current

Automatic OSC Alter-Level Coordination Pending Current Finished

Automatic OSC Alter-Level Coordination Pending Current Finished

Automatic OSC Alter-Level Coordination Pending Current Finished

Automatic OSC Alter-Level Coordination Pending Current Finished

Automatic OSC Alter-Level Coordination Pending Current Finished

Automatic OSC Alter-Level Coordination: Pending Pending

Automatic OSC Alter-Level Coordination: Pending Pending ~/mysql-schemas $ git diff db2 > SHOW CREATE TABLE `apple`; db3 > SHOW CREATE TABLE `apple`; db1 > SHOW CREATE TABLE `apple`; CREATE TABLE `apple` ( CREATE TABLE `apple` ( CREATE TABLE `apple` ( CREATE TABLE `apple` ( `id` int(11) AUTO_INCREMENT, `id` int(11) AUTO_INCREMENT, `id` int(11) AUTO_INCREMENT, `id` int(11) AUTO_INCREMENT, `name` varchar(32), `name` varchar(32), `name` varchar(32), `name` varchar(32), `quantity` int(11), `quantity` int(11), `quantity` int(11), `quantity` int(11), + `color` enum('red','green'), PRIMARY KEY (`id`) `color` enum('red','green'), `color` enum('red','green'), PRIMARY KEY (`id`) ) ENGINE=RocksDB PRIMARY KEY (`id`) PRIMARY KEY (`id`) ) ENGINE=RocksDB ) ENGINE=RocksDB ) ENGINE=RocksDB

Automatic OSC Alter-Level Coordination: Pending Pending

Automatic OSC Alter-Level Coordination: Current Current

Automatic OSC Alter-Level Coordination: Finished Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Pending Current Finished

Automatic OSC Alter-Level Coordination: Finished Finished

Automatic OSC Alter-Level Coordination: Current Current

Automatic OSC Alter-Level Coordination: Finished Finished

Host-Level Coordination

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination M R R R R

Automatic OSC Host-Level Coordination M R R R R R R R

Automatic OSC Host-Level Coordination M M R R R R R R R

Automatic OSC Host-Level Coordination M M R R R R R R R

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current

Automatic OSC Host-Level Coordination Current