两个 account 的发布与订阅

在测试集群的 sys account 中创建租户、源库和发布:

CREATE ACCOUNT cookbook_reader ADMIN_NAME 'admin' IDENTIFIED BY '111';
CREATE DATABASE cookbook_pub;
CREATE TABLE cookbook_pub.orders(id INT PRIMARY KEY, amount INT);
INSERT INTO cookbook_pub.orders VALUES(1,10),(2,20);
CREATE PUBLICATION cookbook_orders DATABASE cookbook_pub ACCOUNT cookbook_reader;

用 cookbook_reader:admin 连接同一实例,在订阅方运行:

CREATE DATABASE cookbook_sub FROM sys PUBLICATION cookbook_orders;
SELECT COUNT(*) AS subscribed_rows, SUM(amount) AS amount_sum
FROM cookbook_sub.orders;

应得到 2 和 30。发布方再插入 (3,30),订阅方再次查询应为 3 和 60;订阅表只读。先在订阅方 DROP DATABASE cookbook_sub,再在 sys 中 DROP PUBLICATION cookbook_orders; DROP DATABASE cookbook_pub; DROP ACCOUNT cookbook_reader;。参见源码 发布订阅测试。