pg原生和mysql中间件分布式之间路由操作对比

mysql -h 192.168.8.1 -P 15260 -u dbmgr -p -D testdb 
create table testdb.akentab02 
( a int, b int, c char(20),primary key (a,b),unique key u_1(a,c) );

mysql -h 192.168.8.2 -P 4005 -u dbmgr -D -d testdb
drop table testdb.akentab02;

mysql -h 192.168.8.1 -P 15260 -u dbmgr -p -D testdb
MySQL [testdb]> show tables;   --路由查看表已不存在
Empty set (0.03 sec)
MySQL [testdb]> create table testdb.akentab02 ( a int, b int, c char(20),primary key (a,b),unique key u_1(a,c) );
ERROR 687 (HY000): Proxy ERROR:Table already exists  --重建同名表失败，路由信息依旧存在
MySQL [testdb]> select * from akentab02;  --但该表无法访问、无法drop
ERROR 1051 (42S02): Unknown table 'testdb.akentab'
MySQL [testdb]> drop table akentab02;
ERROR 1051 (42S02): Unknown table 'testdb.akentab'
MySQL [testdb]>

mysql -h 192.168.8.2 -P 4005 -u dbmgr -D -d testdb -A -c
create table testdb.akentab ( a int, b int, c char(20),primary key (a,b),unique key u_1(a,c) );

mysql -h 192.168.8.1 -P 15260 -u dbmgr -p -D testdb -A -c    
MySQL [testdb]> show tables;
+------------------+
| Tables_in_testdb |
+------------------+
| akentab          |
+------------------+
1 row in set (0.02 sec)
MySQL [testdb]> select * from testdb.akentab01;   ---无法读取到表的路由信息
ERROR 660 (HY000): Proxy ERROR:Table:'testdb.akentab01' does not exist
MySQL [testdb]>

[tbase@ ~]$ psql -h 192.168.8.1 -p 11345 akendb
psql (10.6, server 10.0 TBase V2)
Type "help" for help.
akendb=# create table aken01(id serial,name text);
CREATE TABLE
akendb=#

[tbase@ ~]$ psql -h 192.168.8.2 -p 11002 -U tbase -d akendb
psql (PostgreSQL 10.0 TBase V2)
Type "help" for help.
akendb=# \dt
                  List of relations
 Schema |            Name             | Type  | Owner 
--------+-----------------------------+-------+-------
 public | aken01                      | table | tbase
 public | aken02                      | table | tbase
 public | aken03                      | table | tbase
 public | tab                         | table | tbase
 public | tbase_subscription          | table | tbase
 public | tbase_subscription_parallel | table | tbase
(6 rows)
akendb=# drop table aken01;
ERROR:  cannot execute DROP TABLE in a read-only transaction
akendb=# 
akendb=# create table aken04(id serial,name text);
ERROR:  cannot execute CREATE TABLE in a read-only transaction
akendb=#