postgresql repl Slony-I
postgresql repl Slony-I
数据库人生
专注于数据库
PostgreSQL;Oracle 11G OCA、OCP;OceanBase V2 OBCA、OBCP
展开
-
Slony-I 之三 1 master 节点 + 1目标节点 , 再添加1个目标节点
os: centos 7.4.1708db: postgresql 11.8Slony-I: 2.2.8192.168.56.111 n1192.168.56.112 n2192.168.56.113 n3这3个节点都需要安装 postgresql 11 及 Slony-I<<Slony-I 之二 master 节点 + 1目标节点>>上篇 blog 实现了1对1的功能,本次追加一个n3节点,实现 1对2。版本# cat /etc/centos-rele原创 2020-06-12 15:08:13 · 393 阅读 · 0 评论 -
Slony-I 之二 1 master 节点 + 1目标节点
os: centos 7.4.1708db: postgresql 11.8Slony-I: 2.2.8192.168.56.111 n1192.168.56.112 n2192.168.56.113 n3这3个节点都需要安装 postgresql 11 及 Slony-I本次实现同步 n1 节点某个表数据到 n2、n3 节点。版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core) # # # yum原创 2020-06-12 11:21:15 · 374 阅读 · 2 评论 -
Slony-I 之一 setup
os: centos 7.4.1708db: postgresql 11.8Slony-I: 2.2.8Slony-I is a “master to multiple slaves” replication system for PostgreSQL supporting cascading (e.g. - a node can feed another node which feeds another node…) and failover.个人猜测 Slony-I 是 postgresql s原创 2020-06-10 17:24:41 · 279 阅读 · 0 评论