Citus初步测试

服务器主机配置:
CPU:单核2GHz
RAM:2GB
DISK:30GB HDD

Citus部署配置:
Coordinator X 1 (192.168.7.129)
Worker X 2 (192.168.7.130,192.168.7.131)

基于上一篇文章安装部署完Citus后。用psql命令登陆Coordinator节点:

psql -h 192.168.7.129 -p 5432 -U postgres

执行下列SQL语句

--创建表
create table test_table(id int, name varchar(16));
--表分片
SELECT master_create_distributed_table('test_table', 'id', 'hash');
--设定分片个数(2)及每个分片副本数(2)
SELECT master_create_worker_shards('test_table', 2, 2);
INSERT INTO test_table VALUES(1,'a');
INSERT INTO test_table VALUES(2,'b');
INSERT INTO test_table VALUES(3,'c');
INSERT INTO test_table VALUES(4,'d');

--集群管理
--查看work节点
SELECT * from master_get_active_worker_nodes();
--元数据查看
SELECT * from master_get_table_metadata('test_table');
--分区查看
SELECT * from pg_dist_partition;
--分片查看
SELECT * from pg_dist_shard;
--分片分布查看
SELECT * from pg_dist_shard_placement;

select * from test_table;
 id | name
----+------
  1 | a
  3 | c
  4 | d
  2 | b
(4 行记录)

当停止一个worker_02(192.168.7.131)后,Coordinator仍然能够正常连接,数据也能正常取到,但是执行SQL查询时会出现警告,可以推断出其中的数据是从worker_01(192.168.7.131)上的副本中取得的。

select * from test_table;
WARNING:  connection error: 192.168.7.131:5432
描述:  could not connect to server: No route to host
        Is the server running on host "192.168.7.131" and accepting
        TCP/IP connections on port 5432?
 id | name
----+------
  1 | a
  3 | c
  4 | d
  2 | b
(4 行记录)

当把两个worker都停止后,Coordinator仍然能够正常连接,但是SQL查询已经取不到数据了。

select * from test_table;
WARNING:  connection error: 192.168.7.131:5432
描述:  could not connect to server: No route to host
        Is the server running on host "192.168.7.131" and accepting
        TCP/IP connections on port 5432?
WARNING:  could not establish asynchronous connection after 5000 ms
WARNING:  connection error: 192.168.7.131:5432
描述:  could not connect to server: No route to host
        Is the server running on host "192.168.7.131" and accepting
        TCP/IP connections on port 5432?
WARNING:  could not establish asynchronous connection after 5000 ms
WARNING:  connection error: 192.168.7.131:5432
描述:  could not connect to server: No route to host
        Is the server running on host "192.168.7.131" and accepting
        TCP/IP connections on port 5432?
ERROR:  failed to execute task 4
  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

皓月如我

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值