Jan 2nd no 33 Harry $99 Jan 1st no id name balance timestamp change 11 Tom $20 Jan 1st insert 22 Dick $0 Jan 1st insert 22 Dick $200 Jan 2nd update 33 Harry $99 Jan 1st insert time key 2nd Jan: Jan 1st no 22 Dick $200 Jan 2nd no 33 Harry $99 Jan 3rd yes id name balance timestamp change 11 Tom $20 Jan 1st insert 22 Dick $0 Jan 1st insert 22 Dick $200 Jan 2nd update 33 Harry $99 Jan 1st 1st insert 33 Harry $99 Jan 3rd delete time key time key 2nd Jan: update Dick >> $200 plain replica soft delete id name balance 11 Tom $20 22 Dick $200 33 Harry $99 id name balance 11 Tom $20

subsets of data for example Postgres Conference China 2016 中国用户大会 Bidirectional Replication (BDR) • 2nd Quadrant’s BDR Bidirectional Replication provides multi-master capability to PostgreSQL. Ability to

setUsername("root"); dataSource1.setPassword(""); dataSourceMap.put("ds_1", dataSource1); // Configure the 2nd data source HikariDataSource dataSource2 = new HikariDataSource(); dataSource2.setDriverClassName("com shardingsphere.datasource.ds1.username=root spring.shardingsphere.datasource.ds1.password= # Configure the 2nd data source spring.shardingsphere.datasource.ds2.type=com.zaxxer.hikari.HikariDataSource spring.shardingsphere data source spring.shardingsphere.datasource.ds1.jndi-name=java:comp/env/jdbc/ds1 # Configure the 2nd data source spring.shardingsphere.datasource.ds2.jndi-name=java:comp/env/jdbc/ds2 Rules Rules are

feature names. Removed any and all remarks about Classic not having a (full) Service Manager. Removed 2nd paragraph of “Default disk locations” section. Removed notes stating that Classic/Win connections will

setUsername("root"); dataSource1.setPassword(""); dataSourceMap.put("ds_1", dataSource1); // Configure the 2nd data source HikariDataSource dataSource2 = new HikariDataSource(); dataSource2.setDriverClassName("com shardingsphere.datasource.ds1.username=root spring.shardingsphere.datasource.ds1.password= # Configure the 2nd data source spring.shardingsphere.datasource.ds2.type=com.zaxxer.hikari.HikariDataSource spring.shardingsphere data source spring.shardingsphere.datasource.ds1.jndi-name=java:comp/env/jdbc/ds1 # Configure the 2nd data source spring.shardingsphere.datasource.ds2.jndi-name=java:comp/env/jdbc/ds2 Rules Rules are

numeric (0..12) %D Day of the month with English suffix (0th, 1st, 2nd, 3rd, …) %D Day of the month with English suffix (0th, 1st, 2nd, 3rd, …) %d Day of the month, numeric (00..31) %d Day of the

starting anew. To avoid a cascading failure scenario, a migration is only auto-retried once. If a 2nd tablet failure takes place, it’s up to the user to retry the failed migration. 50 Cross tablet VReplication then the 2nd is a noop, and considered as implicitly successful. Likewise, two DROP TABLE DDLs for same statement will each ensure the table does not exist. If the 1st is successful, then the 2nd has nothing for a period of time, and makes it possible to reinstate the table, populated with all data, via a 2nd revert. • The revert for a DROP relies on the fact that Online DDL DROP TABLE does not, in fact, drop

then the 2nd is a noop, and considered as implicitly successful. Likewise, two DROP TABLE DDLs for same statement will each ensure the table does not exist. If the 1st is successful, then the 2nd has nothing for a period of time, and makes it possible to reinstate the table, populated with all data, via a 2nd revert. • The revert for a DROP relies on the fact that Online DDL DROP TABLE does not, in fact, drop

then the 2nd is a noop, and considered as implicitly successful. Likewise, two DROP TABLE DDLs for same statement will each ensure the table does not exist. If the 1st is successful, then the 2nd has nothing for a period of time, and makes it possible to reinstate the table, populated with all data, via a 2nd revert. • The revert for a DROP relies on the fact that Online DDL DROP TABLE does not, in fact, drop

setUsername("root"); dataSource1.setPassword(""); dataSourceMap.put("ds_1", dataSource1); // Configure the 2nd data source HikariDataSource dataSource2 = new HikariDataSource(); dataSource2.setDriverClassName("com