units being added or changed. – Attempt to cover every corner case the change introduces. The thumb rule is: if it can happen in production, it must be covered. • Integration tests should ensure that the vstream copy two tables table from two shards filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "t2", Filter: "select id, val from t2", },{ Match: "t1", Filter: "select * from t1", vstream copy from all tables in all keyspaces filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "/.*/", }}, } vgtid := &binlogdatapb.VGtid{ ShardGtids: []*binlogdatapb.ShardGtid{{

being added or changed. 35 – Attempt to cover every corner case the change introduces. The thumb rule is: if it can happen in production, it must be covered. • Integration tests should ensure that the different vindex than the source keyspace. • Materialized Views: You can specify a materialization rule that creates a view of the source table into a target keyspace. This materialization can use a different each table, you can specify a select statement that represents both the transformation rule and the filtering rule. The select expressions specify the transformation, and the where clause specifies the

units being added or changed. – Attempt to cover every corner case the change introduces. The thumb rule is: if it can happen in production, it must be covered. • Integration tests should ensure that the vstream copy two tables table from two shards filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "t2", Filter: "select id, val from t2", },{ Match: "t1", Filter: "select * from t1", vstream copy from all tables in all keyspaces filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "/.*/", }}, } vgtid := &binlogdatapb.VGtid{ ShardGtids: []*binlogdatapb.ShardGtid{{

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 527 Rule of Thumb . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . units being added or changed. – Attempt to cover every corner case the change introduces. The thumb rule is: if it can happen in production, it must be covered. • Integration tests should ensure that the like so: select ..., convert(column_name using utf8mb4) as column_name , ... • In VReplication’s rule, add one or more convert_charset entries. Each entry is of the form: convert_charset:{key:"

0 码力 | 534 页 | 3.32 MB | 1 年前

3

units being added or changed. – Attempt to cover every corner case the change introduces. The thumb rule is: if it can happen in production, it must be covered. • Integration tests should ensure that the vstream copy two tables table from two shards filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "t2", Filter: "select id, val from t2", },{ Match: "t1", Filter: "select * from t1", copy from all tables in all keyspaces 60 filter := &binlogdatapb.Filter{ Rules: []*binlogdatapb.Rule{{ Match: "/.*/", }}, } vgtid := &binlogdatapb.VGtid{ ShardGtids: []*binlogdatapb.ShardGtid{{

(zone1-commerce -0-replica -0.vttablet), vttablet: rpc error: code = FailedPrecondition desc = disallowed due to rule: enforce blacklisted tables (CallerID: userData1) The replica and rdonly cutovers are freely reversible different vindex than the source keyspace. • Materialized Views: You can specify a materialization rule that creates a view of the source table into a target keyspace. This materialization can use a different each table, you can specify a select statement that represents both the transformation rule and the filtering rule. The select expressions specify the transformation, and the where clause specifies the

different vindex than the source keyspace. • Materialized Views: You can specify a materialization rule that creates a view of the source table into a target keyspace. This materialization can use a different each table, you can specify a select statement that represents both the transformation rule and the filtering rule. The select expressions specify the transformation, and the where clause specifies the is finished, it can continuously replicate the data from the source to destination. • The copying rule can be expressed as a select statement. The statement should be simple enough that the materialized

different vindex than the source keyspace. • Materialized Views: You can specify a materialization rule that creates a view of the source table into a target keyspace. This materialization can use a different each table, you can specify a select statement that represents both the transformation rule and the filtering rule. The select expressions specify the transformation, and the where clause specifies the is finished, it can continuously replicate the data from the source to destination. • The copying rule can be expressed as a select statement. The statement should be simple enough that the materialized