dddd

表 0

a（分区键）

b

send authresult

zookeeper

connreuse

分身表 0

a

c

分身表 1

DB1： table1、table2DBA：tableA

parser layer

cluster tablet

slave

pk

column1

columnX

columnX + 1

1

2

....

max = 100

101

dml

get conn

client connected

R/Wsplit

mysql

object pool

query read

master

authority layer

bussiness

存量数据(row copy) insert ignore .... (select ....) 【min ， max】增量数据(binlog apply) insert - replace update - update where delete - delete where

insert on duplicate key update where（iondup）

parserroutergetconn

backup

replication

osc

db

config

query result read

auth read

log statistics

dump binlog

Cluster

lb

narutoB

TCP connect

分身表1 （a=1， b=1， c=2）

auth send

worker-2

failover

read handshake

mysql protocol

send handshake

merger

worker-n

worker-1

server connected

DB1： table2DBA：tableA_1

conn pool

DB1： table1DBA：tableA_0

query send

authresult read

row copy && binlog apply 串行，binlog优先级高

narutoA

表 1

router layer

no free conn

insert new && affect 0

row copy first

binlog apply first

存量数据

delete

deleted && affect 0

affect 0 && deleted

update

affect 0 && insert new

insert

impossible

增量数据

inserted

replaced

updated

deleted

multi tenant

metrics

mq

proxy

main(watcher)

naruto

query result send