Londiste 3 Cascaded Replication case

最新推荐文章于 2024-06-20 19:12:07 发布
最新推荐文章于 2024-06-20 19:12:07 发布
阅读量181 收藏
点赞数
文章标签： 数据库 python
原文链接：https://yq.aliyun.com/articles/14685
版权
londiste利用PostgreSQL的cascaded queue实现了cascaded replication, cascaded queue的术语如下 : 
set::
  Group of nodes that distribute a single queue.  In addition to
  copying events around, they also keep same batch boundaries
  and tick_ids.

node::
  A database that participates in cascaded copy of a queue.

provider::
  Node that provides queue data to another.

subscriber::
  Node that receives queue data from another.


cascaded queue中, 一个集群里面的所有节点共享queue的信息, 包括事件, batchs, tick_ids都相同. 因此可以改变provider, 所以后面测试的root节点以及branch节点的角色转换才能实现.
cascaded queue集群中包含以下角色, 有一些角色会在merge replication和split replication中讲解. 
root::
  Place where queue data is generated.

branch::
  * Carries full contents of the queue.
  * (Londiste) May subscribe to all/some/none of the tables.
  * (Londiste) Can be provider for initial copy only if subscribes to table

leaf::
  Data-only node.  Events are replayed, but no queue, thus cannot be provider to other nodes.
  Nodes where sets from partitions are merged together are also tagged 'leaf', because
  in per-partition set it cannot be provider to other nodes.

merge-leaf::
  [Does not exist as separate type, detected as 'leaf' that has 'combined_queue' set.]
  Exists in per-partition set.
  - Does not have it's own queue.
  - (Londiste) Initial COPY is done with --skip-truncate,
  - Event data is sent to combined queue.
  - tick_id for each batch is sent to combined queue.

  - Queue reader from partition to combined-failover must lag behind
    combined queue coming from combined-root
  
combined-root::
  [Does not exist as separate type, detected as 'root' that has 'leaf's with 'combined_queue' set.]
  - Master for combined queue.  Received data from several per-partition queues.
  - Also is merge-leaf in every per-partition queue.
  - Queue is filled directly from partition queues.

combined-failover::
  [Does not exist as separate type, detected as 'branch' that has 'leaf's with 'combined_queue' set.]
  - participates in combined-set, receives events.
  - also is queue-only node in every part-set.
  - but no processing is done, just tracking

-- 接下来使用5个节点测试一下londiste3的级联复制.
-- 测试环境 
skytools3.0.3
root:   172.16.3.33:1919:digoal  PostgreSQL 9.2beta1
branch: 172.16.3.39:1921:digoal  PostgreSQL 9.1.3
branch: 172.16.3.40:1921:digoal  PostgreSQL 9.1.3
branch: 172.16.3.150:1919:digoal PostgreSQL 9.1.3
branch: 172.16.3.176:1921:digoal PostgreSQL 9.1.3



一、在所有节点上安装skytools3.0.3.
-- 参考《londist3 install》
http://blog.163.com/digoal@126/blog/static/163877040201242945632912/


二、选择一个节点运行worker进程, 当然也可以各自运行在各自的节点上. 本例选择172.16.3.33作为运行worker进程的服务器.

三、在所有节点上创建用于复制的超级用户londiste(也可以叫别的名字),并且所有节点都允许172.16.3.33通过londiste访问所有库.可能需要配置防火墙,pg_hba.conf等.


postgres@db5-> psql
postgres=# create role londiste superuser nocreatedb nocreaterole noinherit login encrypted password 'londiste';
CREATE ROLE

-- 在所有节点创建测试用户和测试库
postgres@db5-> psql
postgres=# create role digoal nosuperuser nocreatedb nocreaterole noinherit login encrypted password 'digoal';
CREATE ROLE
postgres=# create database digoal encoding 'UTF8' template template0 owner digoal;
CREATE DATABASE
postgres=# \c digoal digoal
You are now connected to database "digoal" as user "digoal".
digoal=> create schema digoal authorization digoal;
CREATE SCHEMA

-- 在所有节点创建测试表
create table user_info
(userid int,
engname text,
cnname text,
occupation text,
birthday date,
signname text,
email text,
qq numeric,
crt_time timestamp without time zone,
mod_time timestamp without time zone
);

create table user_session
(userid int,
logintime timestamp(0) without time zone,
login_count bigint default 0,
logouttime timestamp(0) without time zone,
online_interval interval default interval '0'
);

create table user_login_rec
(
id serial8 primary key,
userid int,
login_time timestamp without time zone,
ip inet
);

create table user_logout_rec
(
id serial8 primary key,
userid int,
logout_time timestamp without time zone,
ip inet
);

-- 在172.16.3.33上面初始化数据,作为root节点.
insert into user_info (userid,engname,cnname,occupation,birthday,signname,email,qq,crt_time,mod_time)
select generate_series(1,200000),
'digoal.zhou',
'德哥',
'DBA',
'1970-01-01'
,E'公益是一辈子的事, I\'m Digoal.Zhou, Just do it!',
'digoal@126.com',
276732431,
clock_timestamp(),
NULL;

insert into user_session (userid) select generate_series(1,200000);

-- 在所有节点添加这两个表的主键
set work_mem='2048MB';
set maintenance_work_mem='2048MB';
alter table user_info add constraint pk_user_info primary key (userid);
alter table user_session add constraint pk_user_session primary key (userid);

-- 在所有节点创建业务函数
-- 模拟用户登录的函数
create or replace function f_user_login 
(i_userid int,
OUT o_userid int,
OUT o_engname text,
OUT o_cnname text,
OUT o_occupation text,
OUT o_birthday date,
OUT o_signname text,
OUT o_email text,
OUT o_qq numeric
)
as $BODY$
declare
begin
select userid,engname,cnname,occupation,birthday,signname,email,qq
into o_userid,o_engname,o_cnname,o_occupation,o_birthday,o_signname,o_email,o_qq
from user_info where userid=i_userid;
insert into user_login_rec (userid,login_time,ip) values (i_userid,now(),inet_client_addr());
update user_session set logintime=now(),login_count=login_count+1 where userid=i_userid;
return;
end;
$BODY$
language plpgsql;
-- 模拟用户退出的函数
create or replace function f_user_logout
(i_userid int,
OUT o_result int
)
as $BODY$
declare
begin
insert into user_logout_rec (userid,logout_time,ip) values (i_userid,now(),inet_client_addr());
update user_session set logouttime=now(),online_interval=online_interval+(now()-logintime) where userid=i_userid;
o_result := 0;
return;
exception 
when others then
o_result := 1;
return;
end;
$BODY$
language plpgsql;



四、级联复制测试
-- 在运行worker进程的服务器上(本例选择的是172.16.3.33)创建配置文件目录, 日志目录, pid文件目录等 
mkdir -p /home/pg92/skylondist/log
mkdir -p /home/pg92/skylondist/pid
mkdir -p /home/pg92/skylondist/etc

-- 创建pgqd配置文件, database_list表示这个QUEUE要级联的涉及的库, 本例全部用的是digoal, 所以不需要配置其他的, 如果后续增加了其他库名加入到级联, 则需要添加到database_list中,逗号隔开.
 
vi /home/pg92/skylondist/etc/pgqd.ini
[pgqd]
base_connstr = host=172.16.3.33 port=1919 user=londiste password=londiste
initial_database = template1
database_list = digoal
logfile = /home/pg92/skylondist/log/pgqd.log
pidfile = /home/pg92/skylondist/pid/pgqd.pid


-- 创建级联中包含的节点的配置文件,节点1
 
vi /home/pg92/skylondist/etc/digoal_33.ini
[londiste3]
job_name = digoal_33
db = host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste
queue_name = replika
logfile = /home/pg92/skylondist/log/%(job_name)s.log
pidfile = /home/pg92/skylondist/pid/%(job_name)s.pid
pgq_autocommit = 1
pgq_lazy_fetch = 0
parallel_copies = 16

vi /home/pg92/skylondist/etc/digoal_39.ini
[londiste3]
job_name = digoal_39
db = host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste
queue_name = replika
logfile = /home/pg92/skylondist/log/%(job_name)s.log
pidfile = /home/pg92/skylondist/pid/%(job_name)s.pid
pgq_autocommit = 1
pgq_lazy_fetch = 0
parallel_copies = 16

vi /home/pg92/skylondist/etc/digoal_40.ini
[londiste3]
job_name = digoal_40
db = host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste
queue_name = replika
logfile = /home/pg92/skylondist/log/%(job_name)s.log
pidfile = /home/pg92/skylondist/pid/%(job_name)s.pid
pgq_autocommit = 1
pgq_lazy_fetch = 0
parallel_copies = 16

vi /home/pg92/skylondist/etc/digoal_150.ini
[londiste3]
job_name = digoal_150
db = host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste
queue_name = replika
logfile = /home/pg92/skylondist/log/%(job_name)s.log
pidfile = /home/pg92/skylondist/pid/%(job_name)s.pid
pgq_autocommit = 1
pgq_lazy_fetch = 0
parallel_copies = 16

vi /home/pg92/skylondist/etc/digoal_176.ini
[londiste3]
job_name = digoal_176
db = host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste
queue_name = replika
logfile = /home/pg92/skylondist/log/%(job_name)s.log
pidfile = /home/pg92/skylondist/pid/%(job_name)s.pid
pgq_autocommit = 1
pgq_lazy_fetch = 0
parallel_copies = 16



-- 在172.16.3.33上使用以上配置文件执行londiste3加载londiste3以及初始化节点 
londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini create-root digoal_33 "host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
londiste3 -v /home/pg92/skylondist/etc/digoal_39.ini create-branch digoal_39 "host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
londiste3 -v /home/pg92/skylondist/etc/digoal_40.ini create-branch digoal_40 "host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
londiste3 -v /home/pg92/skylondist/etc/digoal_150.ini create-branch digoal_150 "host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
londiste3 -v /home/pg92/skylondist/etc/digoal_176.ini create-branch digoal_176 "host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"


-- 详细的初始化日志 

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini create-root digoal_33 "host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
2012-06-05 09:10:36,740 7240 DEBUG Connect 'new_node' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:10:36,745 7240 INFO plpgsql is installed
2012-06-05 09:10:36,746 7240 INFO Installing pgq
2012-06-05 09:10:36,746 7240 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq.sql
2012-06-05 09:10:37,050 7240 INFO pgq.get_batch_cursor is installed
2012-06-05 09:10:37,050 7240 INFO Installing pgq_ext
2012-06-05 09:10:37,050 7240 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_ext.sql
2012-06-05 09:10:37,208 7240 INFO Installing pgq_node
2012-06-05 09:10:37,208 7240 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_node.sql
2012-06-05 09:10:37,443 7240 INFO Installing londiste
2012-06-05 09:10:37,443 7240 INFO   Reading from /opt/python2.7.3/share/skytools3/londiste.sql
2012-06-05 09:10:37,680 7240 INFO londiste.global_add_table is installed
2012-06-05 09:10:37,681 7240 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:10:37,683 7240 INFO Initializing node
2012-06-05 09:10:37,683 7240 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_33', 'host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:10:37,684 7240 INFO Location registered
2012-06-05 09:10:37,685 7240 DEBUG exec_cmd: select * from pgq_node.create_node('replika', 'root', 'digoal_33', 'digoal_33', null, null, null)
2012-06-05 09:10:37,872 7240 INFO Node "digoal_33" initialized for queue "replika" with type "root"
2012-06-05 09:10:37,872 7240 INFO Done

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_39.ini create-branch digoal_39 "host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
2012-06-05 09:18:50,148 7309 DEBUG Connect 'new_node' to 'host=172.16.3.39 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:18:50,157 7309 INFO plpgsql is installed
2012-06-05 09:18:50,158 7309 INFO pgq is installed
2012-06-05 09:18:50,159 7309 INFO pgq.get_batch_cursor is installed
2012-06-05 09:18:50,160 7309 INFO pgq_ext is installed
2012-06-05 09:18:50,160 7309 INFO pgq_node is installed
2012-06-05 09:18:50,160 7309 INFO londiste is installed
2012-06-05 09:18:50,161 7309 INFO londiste.global_add_table is installed
2012-06-05 09:18:50,162 7309 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:18:50,166 7309 INFO Initializing node
2012-06-05 09:18:50,166 7309 DEBUG Connect 'root_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:18:50,169 7309 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:18:50,176 7309 DEBUG db='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste' -- type='root' provider='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste'
2012-06-05 09:18:50,176 7309 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:18:50,178 7309 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:18:50,179 7309 DEBUG Connect 'provider_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:18:50,181 7309 DEBUG exec_query: select node_type, node_name from pgq_node.get_node_info('replika')
2012-06-05 09:18:50,188 7309 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:18:50,191 7309 INFO Location registered
2012-06-05 09:18:50,191 7309 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:18:50,194 7309 INFO Location registered
2012-06-05 09:18:50,194 7309 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_39', 'digoal_39', null)
2012-06-05 09:18:50,198 7309 INFO Subscriber registered: digoal_39
2012-06-05 09:18:50,198 7309 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:18:50,200 7309 INFO Location registered
2012-06-05 09:18:50,200 7309 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_33', 'host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:18:50,201 7309 INFO Location registered
2012-06-05 09:18:50,202 7309 DEBUG exec_cmd: select * from pgq_node.create_node('replika', 'branch', 'digoal_39', 'digoal_39', 'digoal_33', '1', null)
2012-06-05 09:18:50,261 7309 INFO Node "digoal_39" initialized for queue "replika" with type "branch"
2012-06-05 09:18:50,263 7309 INFO Done

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_40.ini create-branch digoal_40 "host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
2012-06-05 09:19:00,842 7314 DEBUG Connect 'new_node' to 'host=172.16.3.40 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:00,852 7314 INFO plpgsql is installed
2012-06-05 09:19:00,853 7314 INFO Installing pgq
2012-06-05 09:19:00,853 7314 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq.sql
2012-06-05 09:19:00,971 7314 INFO pgq.get_batch_cursor is installed
2012-06-05 09:19:00,972 7314 INFO Installing pgq_ext
2012-06-05 09:19:00,972 7314 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_ext.sql
2012-06-05 09:19:01,023 7314 INFO Installing pgq_node
2012-06-05 09:19:01,023 7314 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_node.sql
2012-06-05 09:19:01,121 7314 INFO Installing londiste
2012-06-05 09:19:01,122 7314 INFO   Reading from /opt/python2.7.3/share/skytools3/londiste.sql
2012-06-05 09:19:01,211 7314 INFO londiste.global_add_table is installed
2012-06-05 09:19:01,212 7314 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:01,216 7314 INFO Initializing node
2012-06-05 09:19:01,216 7314 DEBUG Connect 'root_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:01,220 7314 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:01,227 7314 DEBUG db='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste' -- type='root' provider='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste'
2012-06-05 09:19:01,227 7314 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:01,229 7314 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:19:01,229 7314 DEBUG Connect 'provider_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:01,232 7314 DEBUG exec_query: select node_type, node_name from pgq_node.get_node_info('replika')
2012-06-05 09:19:01,239 7314 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:01,242 7314 INFO Location registered
2012-06-05 09:19:01,242 7314 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:01,244 7314 INFO Location registered
2012-06-05 09:19:01,244 7314 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_40', 'digoal_40', null)
2012-06-05 09:19:01,248 7314 INFO Subscriber registered: digoal_40
2012-06-05 09:19:01,248 7314 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:01,250 7314 INFO Location registered
2012-06-05 09:19:01,250 7314 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_33', 'host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:01,251 7314 INFO Location registered
2012-06-05 09:19:01,251 7314 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:01,252 7314 INFO Location registered
2012-06-05 09:19:01,252 7314 DEBUG exec_cmd: select * from pgq_node.create_node('replika', 'branch', 'digoal_40', 'digoal_40', 'digoal_33', '1', null)
2012-06-05 09:19:01,298 7314 INFO Node "digoal_40" initialized for queue "replika" with type "branch"
2012-06-05 09:19:01,300 7314 INFO Done

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_150.ini create-branch digoal_150 "host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
2012-06-05 09:19:07,065 7317 DEBUG Connect 'new_node' to 'host=172.16.3.150 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:07,073 7317 INFO plpgsql is installed
2012-06-05 09:19:07,073 7317 INFO Installing pgq
2012-06-05 09:19:07,074 7317 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq.sql
2012-06-05 09:19:07,223 7317 INFO pgq.get_batch_cursor is installed
2012-06-05 09:19:07,223 7317 INFO Installing pgq_ext
2012-06-05 09:19:07,223 7317 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_ext.sql
2012-06-05 09:19:07,270 7317 INFO Installing pgq_node
2012-06-05 09:19:07,271 7317 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_node.sql
2012-06-05 09:19:07,325 7317 INFO Installing londiste
2012-06-05 09:19:07,325 7317 INFO   Reading from /opt/python2.7.3/share/skytools3/londiste.sql
2012-06-05 09:19:07,408 7317 INFO londiste.global_add_table is installed
2012-06-05 09:19:07,409 7317 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:07,413 7317 INFO Initializing node
2012-06-05 09:19:07,413 7317 DEBUG Connect 'root_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:07,416 7317 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:07,423 7317 DEBUG db='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste' -- type='root' provider='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste'
2012-06-05 09:19:07,423 7317 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:07,425 7317 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:19:07,425 7317 DEBUG Connect 'provider_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:07,429 7317 DEBUG exec_query: select node_type, node_name from pgq_node.get_node_info('replika')
2012-06-05 09:19:07,436 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_150', 'host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:07,438 7317 INFO Location registered
2012-06-05 09:19:07,439 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_150', 'host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:07,441 7317 INFO Location registered
2012-06-05 09:19:07,441 7317 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_150', 'digoal_150', null)
2012-06-05 09:19:07,445 7317 INFO Subscriber registered: digoal_150
2012-06-05 09:19:07,445 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_150', 'host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:07,447 7317 INFO Location registered
2012-06-05 09:19:07,447 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_33', 'host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:07,448 7317 INFO Location registered
2012-06-05 09:19:07,449 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:07,449 7317 INFO Location registered
2012-06-05 09:19:07,450 7317 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:07,450 7317 INFO Location registered
2012-06-05 09:19:07,451 7317 DEBUG exec_cmd: select * from pgq_node.create_node('replika', 'branch', 'digoal_150', 'digoal_150', 'digoal_33', '1', null)
2012-06-05 09:19:07,490 7317 INFO Node "digoal_150" initialized for queue "replika" with type "branch"
2012-06-05 09:19:07,492 7317 INFO Done

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_176.ini create-branch digoal_176 "host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste" --provider="host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste"
2012-06-05 09:19:14,456 7321 DEBUG Connect 'new_node' to 'host=172.16.3.176 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:14,464 7321 INFO plpgsql is installed
2012-06-05 09:19:14,465 7321 INFO Installing pgq
2012-06-05 09:19:14,465 7321 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq.sql
2012-06-05 09:19:14,922 7321 INFO pgq.get_batch_cursor is installed
2012-06-05 09:19:14,923 7321 INFO Installing pgq_ext
2012-06-05 09:19:14,923 7321 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_ext.sql
2012-06-05 09:19:15,159 7321 INFO Installing pgq_node
2012-06-05 09:19:15,160 7321 INFO   Reading from /opt/python2.7.3/share/skytools3/pgq_node.sql
2012-06-05 09:19:15,422 7321 INFO Installing londiste
2012-06-05 09:19:15,422 7321 INFO   Reading from /opt/python2.7.3/share/skytools3/londiste.sql
2012-06-05 09:19:15,724 7321 INFO londiste.global_add_table is installed
2012-06-05 09:19:15,725 7321 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:15,728 7321 INFO Initializing node
2012-06-05 09:19:15,729 7321 DEBUG Connect 'root_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:15,731 7321 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:15,739 7321 DEBUG db='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste' -- type='root' provider='host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste'
2012-06-05 09:19:15,739 7321 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:19:15,740 7321 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:19:15,741 7321 DEBUG Connect 'provider_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:19:15,744 7321 DEBUG exec_query: select node_type, node_name from pgq_node.get_node_info('replika')
2012-06-05 09:19:15,751 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_176', 'host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:15,754 7321 INFO Location registered
2012-06-05 09:19:15,754 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_176', 'host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:15,756 7321 INFO Location registered
2012-06-05 09:19:15,756 7321 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_176', 'digoal_176', null)
2012-06-05 09:19:15,760 7321 INFO Subscriber registered: digoal_176
2012-06-05 09:19:15,760 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_176', 'host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:19:15,761 7321 INFO Location registered
2012-06-05 09:19:15,762 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_33', 'host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:15,762 7321 INFO Location registered
2012-06-05 09:19:15,763 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_150', 'host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:15,763 7321 INFO Location registered
2012-06-05 09:19:15,764 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_39', 'host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:15,764 7321 INFO Location registered
2012-06-05 09:19:15,765 7321 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', 'False')
2012-06-05 09:19:15,765 7321 INFO Location registered
2012-06-05 09:19:15,765 7321 DEBUG exec_cmd: select * from pgq_node.create_node('replika', 'branch', 'digoal_176', 'digoal_176', 'digoal_33', '1', null)
2012-06-05 09:19:16,041 7321 INFO Node "digoal_176" initialized for queue "replika" with type "branch"
2012-06-05 09:19:16,043 7321 INFO Done



-- 启动pgqd进程 
pg92@db-172-16-3-33-> pgqd -d /home/pg92/skylondist/etc/pgqd.ini
2012-06-05 09:20:57.298 7346 LOG Starting pgqd 3.0.3



-- 查看当前的TOP和membership 
pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini status
2012-06-05 09:21:44,988 7363 DEBUG Connect 'db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:44,991 7363 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:21:44,999 7363 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:21:45,000 7363 DEBUG Connect 'look_db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:45,014 7363 DEBUG Connect 'look_db' to 'host=172.16.3.150 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:45,038 7363 DEBUG Connect 'look_db' to 'host=172.16.3.39 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:45,058 7363 DEBUG Connect 'look_db' to 'host=172.16.3.40 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:45,077 7363 DEBUG Connect 'look_db' to 'host=172.16.3.176 port=1921 user=londiste dbname=digoal  [...]'
Queue: replika   Local node: digoal_33

digoal_33 (root)
  |                           Tables: 0/0/0
  |                           Lag: 22s, Tick: 5, NOT UPTODATE
  +--digoal_150 (branch)
  |                           Tables: 0/0/0
  |                           Lag: 11m7s, Tick: 1, NOT UPTODATE
  +--digoal_176 (branch)
  |                           Tables: 0/0/0
  |                           Lag: 11m7s, Tick: 1, NOT UPTODATE
  +--digoal_39 (branch)
  |                           Tables: 0/0/0
  |                           Lag: 11m7s, Tick: 1, NOT UPTODATE
  +--digoal_40 (branch)
                              Tables: 0/0/0
                              Lag: 11m7s, Tick: 1, NOT UPTODATE

pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini members
2012-06-05 09:21:51,517 7366 DEBUG Connect 'db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:21:51,520 7366 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:21:51,528 7366 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:21:51,528 7366 DEBUG display_table: select node_name, dead, node_location from pgq_node.get_queue_locations('replika') order by 1
Member info on digoal_33@replika:
node_name        dead             node_location
---------------  ---------------  -------------------------------------------------------------------------
digoal_150       False            host=172.16.3.150 port=1919 user=londiste dbname=digoal password=londiste
digoal_176       False            host=172.16.3.176 port=1921 user=londiste dbname=digoal password=londiste
digoal_33        False            host=172.16.3.33 port=1919 user=londiste dbname=digoal password=londiste
digoal_39        False            host=172.16.3.39 port=1921 user=londiste dbname=digoal password=londiste
digoal_40        False            host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste



-- 启动worker进程 
londiste3 -d /home/pg92/skylondist/etc/digoal_33.ini worker
londiste3 -d /home/pg92/skylondist/etc/digoal_39.ini worker
londiste3 -d /home/pg92/skylondist/etc/digoal_40.ini worker
londiste3 -d /home/pg92/skylondist/etc/digoal_150.ini worker
londiste3 -d /home/pg92/skylondist/etc/digoal_176.ini worker


-- 查看进程
 
pg92@db-172-16-3-33-> ps -ewf|grep python
pg92      7385     1  0 09:23 ?        00:00:00 /opt/python2.7.3/bin/python /opt/skytools3.0.3/bin/londiste3 -d /home/pg92/skylondist/etc/digoal_33.ini worker
pg92      7389     1  0 09:23 ?        00:00:00 /opt/python2.7.3/bin/python /opt/skytools3.0.3/bin/londiste3 -d /home/pg92/skylondist/etc/digoal_39.ini worker
pg92      7392     1  0 09:23 ?        00:00:00 /opt/python2.7.3/bin/python /opt/skytools3.0.3/bin/londiste3 -d /home/pg92/skylondist/etc/digoal_40.ini worker
pg92      7395     1  0 09:23 ?        00:00:00 /opt/python2.7.3/bin/python /opt/skytools3.0.3/bin/londiste3 -d /home/pg92/skylondist/etc/digoal_150.ini worker
pg92      7398     1  0 09:23 ?        00:00:00 /opt/python2.7.3/bin/python /opt/skytools3.0.3/bin/londiste3 -d /home/pg92/skylondist/etc/digoal_176.ini worker


-- 使用root的配置文件, 查看未加入复制的表
 
pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini missing
2012-06-05 09:25:25,876 7431 DEBUG Connect 'db' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:25:25,880 7431 DEBUG display_table: select * from londiste.local_show_missing('replika')
Missing objects on node
obj_kind         obj_name
---------------  -----------------------------
S                digoal.user_login_rec_id_seq
S                digoal.user_logout_rec_id_seq
r                digoal.user_info
r                digoal.user_login_rec
r                digoal.user_logout_rec
r                digoal.user_session


-- 在root节点上注册要复制的表和序列
 
londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini add-table digoal.user_info digoal.user_login_rec digoal.user_logout_rec digoal.user_session

londiste3 -v /home/pg92/skylondist/etc/digoal_33.ini add-seq digoal.user_login_rec_id_seq digoal.user_logout_rec_id_seq


-- 在branch节点上添加要复制的表, 由于在branch节点上, 这些表和序列都已经提前创建好了, 所以这里直接添加就行了.
 
londiste3 -v /home/pg92/skylondist/etc/digoal_39.ini add-table digoal.user_info digoal.user_login_rec digoal.user_logout_rec digoal.user_session
londiste3 -v /home/pg92/skylondist/etc/digoal_39.ini add-seq digoal.user_login_rec_id_seq digoal.user_logout_rec_id_seq

londiste3 -v /home/pg92/skylondist/etc/digoal_40.ini add-table digoal.user_info digoal.user_login_rec digoal.user_logout_rec digoal.user_session
londiste3 -v /home/pg92/skylondist/etc/digoal_40.ini add-seq digoal.user_login_rec_id_seq digoal.user_logout_rec_id_seq

londiste3 -v /home/pg92/skylondist/etc/digoal_150.ini add-table digoal.user_info digoal.user_login_rec digoal.user_logout_rec digoal.user_session
londiste3 -v /home/pg92/skylondist/etc/digoal_150.ini add-seq digoal.user_login_rec_id_seq digoal.user_logout_rec_id_seq

londiste3 -v /home/pg92/skylondist/etc/digoal_176.ini add-table digoal.user_info digoal.user_login_rec digoal.user_logout_rec digoal.user_session
londiste3 -v /home/pg92/skylondist/etc/digoal_176.ini add-seq digoal.user_login_rec_id_seq digoal.user_logout_rec_id_seq


五、数据比较
 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_39.ini compare
2012-06-05 09:43:17,395 7916 INFO Locking digoal.user_info
2012-06-05 09:43:17,396 7916 INFO Syncing digoal.user_info
2012-06-05 09:43:20,404 7916 INFO Counting digoal.user_info
2012-06-05 09:43:21,176 7916 INFO srcdb: 200000 rows, checksum=-154935147736
2012-06-05 09:43:22,267 7916 INFO dstdb: 200000 rows, checksum=-154935147736
2012-06-05 09:43:22,268 7916 INFO Locking digoal.user_login_rec
2012-06-05 09:43:22,269 7916 INFO Syncing digoal.user_login_rec
2012-06-05 09:43:25,275 7916 INFO Counting digoal.user_login_rec
2012-06-05 09:43:25,275 7916 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:43:25,276 7916 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:43:25,278 7916 INFO Locking digoal.user_logout_rec
2012-06-05 09:43:25,278 7916 INFO Syncing digoal.user_logout_rec
2012-06-05 09:43:28,283 7916 INFO Counting digoal.user_logout_rec
2012-06-05 09:43:28,283 7916 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:43:28,284 7916 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:43:28,285 7916 INFO Locking digoal.user_session
2012-06-05 09:43:28,286 7916 INFO Syncing digoal.user_session
2012-06-05 09:43:31,290 7916 INFO Counting digoal.user_session
2012-06-05 09:43:31,573 7916 INFO srcdb: 200000 rows, checksum=318647160593
2012-06-05 09:43:32,001 7916 INFO dstdb: 200000 rows, checksum=318647160593
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_40.ini compare
2012-06-05 09:43:51,611 7931 INFO Locking digoal.user_info
2012-06-05 09:43:51,612 7931 INFO Syncing digoal.user_info
2012-06-05 09:43:54,620 7931 INFO Counting digoal.user_info
2012-06-05 09:43:55,392 7931 INFO srcdb: 200000 rows, checksum=-154935147736
2012-06-05 09:43:56,422 7931 INFO dstdb: 200000 rows, checksum=-154935147736
2012-06-05 09:43:56,424 7931 INFO Locking digoal.user_login_rec
2012-06-05 09:43:56,424 7931 INFO Syncing digoal.user_login_rec
2012-06-05 09:43:59,933 7931 INFO Counting digoal.user_login_rec
2012-06-05 09:43:59,934 7931 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:43:59,934 7931 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:43:59,936 7931 INFO Locking digoal.user_logout_rec
2012-06-05 09:43:59,937 7931 INFO Syncing digoal.user_logout_rec
2012-06-05 09:44:03,943 7931 INFO Counting digoal.user_logout_rec
2012-06-05 09:44:03,944 7931 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:44:03,945 7931 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:44:03,946 7931 INFO Locking digoal.user_session
2012-06-05 09:44:03,947 7931 INFO Syncing digoal.user_session
2012-06-05 09:44:07,954 7931 INFO Counting digoal.user_session
2012-06-05 09:44:08,238 7931 INFO srcdb: 200000 rows, checksum=318647160593
2012-06-05 09:44:08,649 7931 INFO dstdb: 200000 rows, checksum=318647160593
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_150.ini compare
2012-06-05 09:44:29,421 7942 INFO Locking digoal.user_info
2012-06-05 09:44:29,422 7942 INFO Syncing digoal.user_info
2012-06-05 09:44:32,430 7942 INFO Counting digoal.user_info
2012-06-05 09:44:33,206 7942 INFO srcdb: 200000 rows, checksum=-154935147736
2012-06-05 09:44:34,310 7942 INFO dstdb: 200000 rows, checksum=-154935147736
2012-06-05 09:44:34,312 7942 INFO Locking digoal.user_login_rec
2012-06-05 09:44:34,313 7942 INFO Syncing digoal.user_login_rec
2012-06-05 09:44:37,819 7942 INFO Counting digoal.user_login_rec
2012-06-05 09:44:37,820 7942 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:44:37,821 7942 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:44:37,822 7942 INFO Locking digoal.user_logout_rec
2012-06-05 09:44:37,823 7942 INFO Syncing digoal.user_logout_rec
2012-06-05 09:44:40,828 7942 INFO Counting digoal.user_logout_rec
2012-06-05 09:44:40,828 7942 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:44:40,829 7942 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:44:40,831 7942 INFO Locking digoal.user_session
2012-06-05 09:44:40,831 7942 INFO Syncing digoal.user_session
2012-06-05 09:44:43,836 7942 INFO Counting digoal.user_session
2012-06-05 09:44:44,121 7942 INFO srcdb: 200000 rows, checksum=318647160593
2012-06-05 09:44:44,549 7942 INFO dstdb: 200000 rows, checksum=318647160593
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_176.ini compare
2012-06-05 09:44:50,190 7949 INFO Locking digoal.user_info
2012-06-05 09:44:50,191 7949 INFO Syncing digoal.user_info
2012-06-05 09:44:54,200 7949 INFO Counting digoal.user_info
2012-06-05 09:44:54,973 7949 INFO srcdb: 200000 rows, checksum=-154935147736
2012-06-05 09:44:56,100 7949 INFO dstdb: 200000 rows, checksum=-154935147736
2012-06-05 09:44:56,101 7949 INFO Locking digoal.user_login_rec
2012-06-05 09:44:56,102 7949 INFO Syncing digoal.user_login_rec
2012-06-05 09:45:00,107 7949 INFO Counting digoal.user_login_rec
2012-06-05 09:45:00,107 7949 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:45:00,108 7949 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:45:00,109 7949 INFO Locking digoal.user_logout_rec
2012-06-05 09:45:00,110 7949 INFO Syncing digoal.user_logout_rec
2012-06-05 09:45:04,116 7949 INFO Counting digoal.user_logout_rec
2012-06-05 09:45:04,117 7949 INFO srcdb: 0 rows, checksum=None
2012-06-05 09:45:04,117 7949 INFO dstdb: 0 rows, checksum=None
2012-06-05 09:45:04,118 7949 INFO Locking digoal.user_session
2012-06-05 09:45:04,119 7949 INFO Syncing digoal.user_session
2012-06-05 09:45:08,125 7949 INFO Counting digoal.user_session
2012-06-05 09:45:08,408 7949 INFO srcdb: 200000 rows, checksum=318647160593
2012-06-05 09:45:08,867 7949 INFO dstdb: 200000 rows, checksum=318647160593


六、角色切换(branch和branch, branch和root的互相切换)
 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_33.ini status
Queue: replika   Local node: digoal_33

digoal_33 (root)
  |                           Tables: 4/0/0
  |                           Lag: 10s, Tick: 152
  +--digoal_150 (branch)
  |                           Tables: 4/0/0
  |                           Lag: 10s, Tick: 152
  +--digoal_176 (branch)
  |                           Tables: 4/0/0
  |                           Lag: 10s, Tick: 152
  +--digoal_39 (branch)
  |                           Tables: 4/0/0
  |                           Lag: 10s, Tick: 152
  +--digoal_40 (branch)
                              Tables: 4/0/0
                              Lag: 10s, Tick: 152


-- 把digoal_40的provider从digoal_33改成digoal_150
 
pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_40.ini change-provider --provider=digoal_150
2012-06-05 09:48:05,457 7990 DEBUG Connect 'db' to 'host=172.16.3.40 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:48:05,462 7990 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:48:05,472 7990 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:48:05,474 7990 DEBUG exec_query: select consumer_name, provider_node, last_tick_id from pgq_node.get_consumer_info('replika')
2012-06-05 09:48:05,475 7990 DEBUG exec_query: select consumer_name, provider_node, last_tick_id from pgq_node.get_consumer_info('replika')
2012-06-05 09:48:05,476 7990 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_40', 'True')
2012-06-05 09:48:05,478 7990 INFO [digoal_40] Consumer digoal_40 tagged as paused
2012-06-05 09:48:05,478 7990 INFO Waiting for worker to accept
2012-06-05 09:48:05,478 7990 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_40')
2012-06-05 09:48:05,480 7990 DEBUG [digoal_40] 100 Ok
2012-06-05 09:48:06,480 7990 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_40')
2012-06-05 09:48:06,481 7990 DEBUG [digoal_40] 100 Ok
2012-06-05 09:48:06,481 7990 INFO Consumer 'digoal_40' on node 'digoal_40' paused
2012-06-05 09:48:06,482 7990 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:48:06,483 7990 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:48:06,485 7990 DEBUG exec_query: select consumer_name, provider_node, last_tick_id from pgq_node.get_consumer_info('replika')
2012-06-05 09:48:06,486 7990 DEBUG Connect 'node.digoal_150' to 'host=172.16.3.150 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:48:06,490 7990 DEBUG exec_cmd: select * from pgq_node.register_location('replika', 'digoal_40', 'host=172.16.3.40 port=1921 user=londiste dbname=digoal password=londiste', false)
2012-06-05 09:48:06,495 7990 INFO [digoal_150] Location registered
2012-06-05 09:48:06,495 7990 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_40', 'digoal_40', '153')
2012-06-05 09:48:06,504 7990 INFO [digoal_150] Subscriber registered: digoal_40
2012-06-05 09:48:06,505 7990 DEBUG exec_cmd: select * from pgq_node.change_consumer_provider('replika', 'digoal_40', 'digoal_150')
2012-06-05 09:48:06,507 7990 INFO [digoal_40] Consumer provider node set to : digoal_150
2012-06-05 09:48:06,507 7990 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_40', 'False')
2012-06-05 09:48:06,508 7990 INFO [digoal_40] Consumer digoal_40 tagged as resumed
2012-06-05 09:48:06,508 7990 INFO Waiting for worker to accept
2012-06-05 09:48:06,509 7990 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_40')
2012-06-05 09:48:06,509 7990 DEBUG [digoal_40] 100 Ok
2012-06-05 09:48:07,510 7990 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_40')
2012-06-05 09:48:07,511 7990 DEBUG [digoal_40] 100 Ok
2012-06-05 09:48:07,512 7990 INFO Consumer 'digoal_40' on node 'digoal_40' resumed
2012-06-05 09:48:07,512 7990 DEBUG Connect 'node.digoal_33' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:48:07,515 7990 DEBUG exec_cmd: select * from pgq_node.unregister_subscriber('replika', 'digoal_40')
2012-06-05 09:48:07,520 7990 INFO [digoal_33] Subscriber unregistered: digoal_40


-- 查看角色切换后的状态
 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_33.ini status
Queue: replika   Local node: digoal_33

digoal_33 (root)
  |                           Tables: 4/0/0
  |                           Lag: 11s, Tick: 153
  +--digoal_176 (branch)
  |                           Tables: 4/0/0
  |                           Lag: 11s, Tick: 153
  +--digoal_39 (branch)
  |                           Tables: 4/0/0
  |                           Lag: 11s, Tick: 153
  +--digoal_150 (branch)
     |                        Tables: 4/0/0
     |                        Lag: 11s, Tick: 153
     +--digoal_40 (branch)
                              Tables: 4/0/0
                              Lag: 11s, Tick: 153


-- 使用takeover切换root节点, 把digoal_39切换成root节点, 在切换前, 在digoal_39上执行一条更新user_info操作的SQL, 看看能不能成功.
 
digoal=> update user_info set engname='test' where userid=1;
ERROR:  Insert into queue disallowed
CONTEXT:  PL/pgSQL function "insert_event" line 24 at RETURN
SQL statement "select pgq.insert_event($1, $2, $3, $4, $5, $6, $7)"

-- 触发器制止了执行
 
Triggers:
    _londiste_replika AFTER INSERT OR DELETE OR UPDATE ON user_info FOR EACH ROW EXECUTE PROCEDURE pgq.logutriga('replika')
    _londiste_replika_truncate AFTER TRUNCATE ON user_info FOR EACH STATEMENT EXECUTE PROCEDURE pgq.sqltriga('replika')
-- 所以数据未被修改
digoal=> select engname from user_info where userid =1;
   engname   
-------------
 digoal.zhou
(1 row)

-- 接下来把digoal_39切换成root, digoal_33切换成branch.
 
pg92@db-172-16-3-33-> londiste3 -v /home/pg92/skylondist/etc/digoal_39.ini takeover digoal_33
2012-06-05 09:56:36,656 8096 INFO old: digoal_33
2012-06-05 09:56:36,656 8096 DEBUG Connect 'db' to 'host=172.16.3.39 port=1921 user=londiste dbname=digoal  [...]'
2012-06-05 09:56:36,661 8096 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:56:36,671 8096 DEBUG exec_query: select * from pgq_node.get_queue_locations('replika')
2012-06-05 09:56:36,672 8096 DEBUG Connect 'node.digoal_33' to 'host=172.16.3.33 port=1919 user=londiste dbname=digoal  [...]'
2012-06-05 09:56:36,675 8096 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:56:36,682 8096 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:56:36,684 8096 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_33', 'True')
2012-06-05 09:56:36,685 8096 INFO [digoal_33] Consumer digoal_33 tagged as paused
2012-06-05 09:56:36,685 8096 INFO Waiting for worker to accept
2012-06-05 09:56:36,686 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:36,687 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:37,687 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:37,688 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:38,688 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:38,688 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:39,688 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:39,689 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:39,689 8096 INFO Consumer 'digoal_33' on node 'digoal_33' paused
2012-06-05 09:56:39,689 8096 DEBUG exec_cmd: select * from pgq_node.demote_root('replika', '1', 'digoal_39')
2012-06-05 09:56:39,690 8096 INFO [digoal_33] Step 1: Writing disabled for: replika
2012-06-05 09:56:39,690 8096 DEBUG exec_cmd: select * from pgq_node.demote_root('replika', '2', 'digoal_39')
2012-06-05 09:56:39,694 8096 INFO [digoal_33] Step 2: Inserted last tick: replika
2012-06-05 09:56:39,694 8096 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:56:39,696 8096 DEBUG waiting for catchup: need=164, cur=163
2012-06-05 09:56:40,696 8096 DEBUG exec_query: select * from pgq_node.get_node_info('replika')
2012-06-05 09:56:40,698 8096 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_39', 'True')
2012-06-05 09:56:40,701 8096 INFO [digoal_39] Consumer digoal_39 tagged as paused
2012-06-05 09:56:40,701 8096 INFO Waiting for worker to accept
2012-06-05 09:56:40,702 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_39')
2012-06-05 09:56:40,703 8096 DEBUG [digoal_39] 100 Ok
2012-06-05 09:56:41,705 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_39')
2012-06-05 09:56:41,706 8096 DEBUG [digoal_39] 100 Ok
2012-06-05 09:56:41,706 8096 INFO Consumer 'digoal_39' on node 'digoal_39' paused
2012-06-05 09:56:41,706 8096 DEBUG exec_cmd: select * from pgq_node.promote_branch('replika')
2012-06-05 09:56:41,711 8096 INFO [digoal_39] Branch node promoted to root
2012-06-05 09:56:41,711 8096 DEBUG exec_cmd: select * from pgq_node.register_subscriber('replika', 'digoal_33', 'digoal_33', '164')
2012-06-05 09:56:41,717 8096 INFO [digoal_39] Subscriber registered: digoal_33
2012-06-05 09:56:41,717 8096 DEBUG exec_cmd: select * from pgq_node.unregister_subscriber('replika', 'digoal_39')
2012-06-05 09:56:41,720 8096 INFO [digoal_33] Subscriber unregistered: digoal_39
2012-06-05 09:56:41,720 8096 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_39', 'False')
2012-06-05 09:56:41,721 8096 INFO [digoal_39] Consumer digoal_39 tagged as resumed
2012-06-05 09:56:41,721 8096 INFO Waiting for worker to accept
2012-06-05 09:56:41,721 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_39')
2012-06-05 09:56:41,722 8096 DEBUG [digoal_39] 100 Ok
2012-06-05 09:56:42,722 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_39')
2012-06-05 09:56:42,723 8096 DEBUG [digoal_39] 100 Ok
2012-06-05 09:56:42,723 8096 INFO Consumer 'digoal_39' on node 'digoal_39' resumed
2012-06-05 09:56:42,723 8096 DEBUG exec_cmd: select * from pgq_node.demote_root('replika', '3', 'digoal_39')
2012-06-05 09:56:42,725 8096 INFO [digoal_33] Step 3: Demoted root to branch: replika
2012-06-05 09:56:42,725 8096 DEBUG exec_cmd: select * from pgq_node.set_consumer_paused('replika', 'digoal_33', 'False')
2012-06-05 09:56:42,726 8096 INFO [digoal_33] Consumer digoal_33 tagged as resumed
2012-06-05 09:56:42,726 8096 INFO Waiting for worker to accept
2012-06-05 09:56:42,726 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:42,727 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:43,727 8096 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'digoal_33')
2012-06-05 09:56:43,728 8096 DEBUG [digoal_33] 100 Ok
2012-06-05 09:56:43,728 8096 INFO Consumer 'digoal_33' on node 'digoal_33' resumed

-- 查看状态
 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_39.ini status
Queue: replika   Local node: digoal_39

digoal_39 (root)
  |                           Tables: 4/0/0
  |                           Lag: -1d23h46m26s, Tick: 164
  +--digoal_33 (branch)
     |                        Tables: 4/0/0
     |                        Lag: (n/a), Tick: 164
     +--digoal_176 (branch)
     |                        Tables: 4/0/0
     |                        Lag: (n/a), Tick: 164
     +--digoal_150 (branch)
        |                     Tables: 4/0/0
        |                     Lag: (n/a), Tick: 164
        +--digoal_40 (branch)
                              Tables: 4/0/0
                              Lag: (n/a), Tick: 164

-- 在到digoal_39上执行update
 
digoal=> update user_info set engname='test' where userid=1;
UPDATE 1
digoal=> select engname from user_info where userid =1;
 engname 
---------
 test
(1 row)

-- 查看是否已经复制到其他节点
-- 结果当然是没有复制, 因为pgqd还连在老的root上. 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_33.ini compare
2012-06-05 10:00:37,847 8183 INFO Locking digoal.user_info
2012-06-05 10:00:37,848 8183 INFO Syncing digoal.user_info
2012-06-05 10:00:47,862 8183 ERROR Job digoal_33 crashed: Ticker seems dead
Traceback (most recent call last):
  File "/opt/python2.7.3/lib/python2.7/site-packages/skytools/scripting.py", line 597, in run_func_safely
    return func()
  File "/opt/python2.7.3/lib/python2.7/site-packages/londiste/syncer.py", line 140, in work
    self.check_table(t1.dest_table, t2.dest_table, lock_db, src_db, dst_db, setup_curs)
  File "/opt/python2.7.3/lib/python2.7/site-packages/londiste/syncer.py", line 194, in check_table
    tick_id = self.force_tick(setup_curs)
  File "/opt/python2.7.3/lib/python2.7/site-packages/londiste/syncer.py", line 166, in force_tick
    raise Exception("Ticker seems dead")
Exception: Ticker seems dead


-- 所以在更改root后一定要更改pgqd的连接
 
pg92@db-172-16-3-33-> vi pgqd.ini 
[pgqd]
base_connstr = host=172.16.3.39 port=1921 user=londiste password=londiste
initial_database = template1
database_list = digoal
logfile = /home/pg92/skylondist/log/pgqd.log
pidfile = /home/pg92/skylondist/pid/pgqd.pid


-- 重启pgqd
 
pg92@db-172-16-3-33-> pgqd -s /home/pg92/skylondist/etc/pgqd.ini 
SIGINT sent
pg92@db-172-16-3-33-> pgqd -d /home/pg92/skylondist/etc/pgqd.ini 
2012-06-05 10:02:04.714 8240 LOG Starting pgqd 3.0.3


-- 再次比较数据是否一致
 
pg92@db-172-16-3-33-> londiste3 /home/pg92/skylondist/etc/digoal_33.ini compare
2012-06-05 10:02:18,340 8248 INFO Locking digoal.user_info
2012-06-05 10:02:18,341 8248 INFO Syncing digoal.user_info
2012-06-05 10:02:21,350 8248 INFO Counting digoal.user_info
2012-06-05 10:02:22,441 8248 INFO srcdb: 200000 rows, checksum=-156218497941
2012-06-05 10:02:23,216 8248 INFO dstdb: 200000 rows, checksum=-156218497941
2012-06-05 10:02:23,218 8248 INFO Locking digoal.user_login_rec
2012-06-05 10:02:23,219 8248 INFO Syncing digoal.user_login_rec
2012-06-05 10:02:26,226 8248 INFO Counting digoal.user_login_rec
2012-06-05 10:02:26,227 8248 INFO srcdb: 0 rows, checksum=None
2012-06-05 10:02:26,228 8248 INFO dstdb: 0 rows, checksum=None
2012-06-05 10:02:26,229 8248 INFO Locking digoal.user_logout_rec
2012-06-05 10:02:26,230 8248 INFO Syncing digoal.user_logout_rec
2012-06-05 10:02:29,237 8248 INFO Counting digoal.user_logout_rec
2012-06-05 10:02:29,238 8248 INFO srcdb: 0 rows, checksum=None
2012-06-05 10:02:29,239 8248 INFO dstdb: 0 rows, checksum=None
2012-06-05 10:02:29,240 8248 INFO Locking digoal.user_session
2012-06-05 10:02:29,241 8248 INFO Syncing digoal.user_session
2012-06-05 10:02:32,748 8248 INFO Counting digoal.user_session
2012-06-05 10:02:33,171 8248 INFO srcdb: 200000 rows, checksum=318647160593
2012-06-05 10:02:33,461 8248 INFO dstdb: 200000 rows, checksum=318647160593


-- 查看172.16.3.33上的数据, 已经更新
 
pg92@db-172-16-3-33-> psql digoal digoal
psql (9.2beta1)
Type "help" for help.
digoal=> select engname from user_info where userid =1;
 engname 
---------
 test
(1 row)


-- 查看172.16.3.40, 150, 176上的数据, 已经更新
 
digoal=> select engname from user_info where userid=1;
 engname 
---------
 test
(1 row)


七、 压力测试
略, 请参考如下
《Londiste 3 replicate case - 1 上节》
《Londiste 3 replicate case - 1 下节》



【参考】

Postgresql后备服务器部署实战
JackGo!
04-30 3523
数据库版本：postgresql 9.6.0 作者：JackGo 邮箱：jackgo73@outlook.com 日期：2017年4月9日 Postgresql后备服务器部署实战这篇文章介绍Postgresql后备服务器的配置使用方法。1 目录Postgresql后备服务器部署实战 目录 部署架构 主机配置 归档冷备服务器配置 1 制作基础备份主节点操作 2 配置归档恢复 流复制
Cascaded 3D Full-Body Pose Regression from Single Depth Image at 100 FPS
02-08
该研究论文的标题为“Cascaded 3D Full-Body Pose Regression from Single Depth Image at 100 FPS”，翻译成中文是“从单个深度图像中以100 FPS级的帧率级联3D全身姿态回归”。这个标题和描述表明了文章的核心研究...
Londiste3 Install
weixin_33915554的博客
03-30 201
Skytools是一个比较成熟的套件, 包含了pgq, Londiste, wal-manager三大组件. 其中pgq由providers,ticker,consumers组成, provider push events to queue, consumer read events from queue. ticker则负责把batch queue里面...
使用Londiste3 增量同步 线下PostgreSQL 到 阿里云RDS PG
weixin_34214500的博客
05-25 193
源端 CentOS 7 PostgreSQL 9.5.2 , listen port 1922 公网IP 101.xxx.xxx.171 skytools 3.2.6 目标端 RDS PG xxx.digoal.pg.rds.aliyuncs.com port=3433 user=digoal dbname=db1 password=digoal 源端 ...
PostgreSQL 集群复制方案之使用pgq和londiste工具包
weixin_30546933的博客
11-06 377
关于PostgreSQL集群复制方案 可以参考25 高可用性，负载均衡和复制这篇文章了解一些常规的复制方案。 关于pgq和londiste工具 来自于skype的工具包skytools，其中pgq是基于postgresql的通用队列实现。而londiste是基于pgq的复制工具。这 两个工具的组合类似于slony，但相比二者，前者更简单一些。我们可以简单地把这种复制理解成 produc...
Skytools安装配置管理
weixin_33967071的博客
02-20 401
2019独角兽企业重金招聘Python工程师标准>>> ...
yo24.rar_cascaded_project
07-15
在本项目"yo24.rar_cascaded_project"中，我们重点探讨了级联网络（Cascaded Network）的应用。级联网络是一种深度学习架构，它由多个子网络连续连接在一起，每个子网络负责处理输入数据的不同方面或不同层次的特征...
upload.rar_cascaded_modular cascaded
07-14
cascaded 5 MODULAR REDUNDANCY paper
Control_Cascaded_Multilevel_Inverter.rar_cascaded inverter_contr
07-14
"Control_Cascaded_Multilevel_Inverter.rar_cascaded inverter_contr" 这个标题暗示了我们关注的核心是控制策略在级联多电平逆变器（Cascaded Multilevel Inverter）中的应用。级联多电平逆变器是一种特殊的逆变器...
Cascaded 3-level Inverter:3-level Inverter with PWM triggering-matlab开发
05-30
3. **控制策略**： - **自然PWM**：简单易实现，但谐波含量较高。 - **空间矢量PWM（SVPWM）**：能有效减小谐波，提高输出质量，但计算复杂度增加。 4. **模型建立**： 使用MATLAB Simulink，搭建逆变器硬件模型...
pgologic：针对PostgreSQL 13、12、11、10、9.6、9.5、9.4（Postgres）的逻辑复制扩展，提供了比Slony，Bucardo或Londiste更快的复制，以及跨版本升级
02-05
pgologic：针对PostgreSQL 13、12、11、10、9.6、9.5、9.4（Postgres）的逻辑复制扩展，提供了比Slony，Bucardo或Londiste更快的复制，以及跨版本升级
sky_postgresql_cluster:PostgreSQL HA 通过三个主机，包括两个 postgresql（主和流复制备用）和一个投票主机
07-03
sky_postgresql_cluster sky_postgresql_cluster 是一个写在 shell 中的 PostgreSQL HA 模块，HA 通过三个主机，包括两个 postgresql （主要和流复制备用）和一票主机。 应用程序通过虚拟连接到 sky_postgresql_cluster IP地址。 要求 ： 三主机 两个postgresql 主机必须有fence 设备。 两台PostgreSQL主机，一台是master，一台是standby。 使用 PostgreSQL 的流复制构建备用构建。 sky_postgresql_cluster 的状态监视器使用 nagios。 添加一名作者 邮箱 : 博客： : 请使用另一个项目
PostgreSQL-Keepalived-HA:基于 Keepalived 和 PG 流复制实现高可用方案
05-17
Keepalived + PostgreSQL 流复制方式实现高可用 HA 一 项目简介 HA 是数据库领域一个永恒的议题，同时也是最复杂的方案之一，PostgreSQL 本身并不提供任何高可用方案， 本文通过 Keepalived + PostgreSQL 流复制方式实现高可用 HA，故障切换逻辑和部分脚本参考德哥 sky_postgresql_cluster () 的 HA 项目，本文仅分享一种 PostgreSQL高可用方案，脚本的切换逻辑可根据实际情况调整，如果您对此方案有更好的建议或补充，欢迎探讨。 Email: 二 需求 PostgreSQL 9.4 版本：其它版本脚本需做相应调整 硬件：2 台带远程管理卡的物理主机：在数据库发生切换时需要用到远程管理卡 两台物理主机安装 Keepalived 程序
PostgreSQL高可用性（HA）实现指南
最新发布
2401_85763639的博客
06-20 1553
Patroni是一个用Python编写的PostgreSQL高可用性模板，它支持多种分布式配置存储系统，如ZooKeeper、etcd和Consul等，并能与Kubernetes无缝集成。pgpool-II是一个位于PostgreSQL服务器和客户端之间的中间件，支持多主复制、负载均衡和故障恢复。
PostgreSQL Keepalived HA：打造高可用数据库集群
gitblog_00017的博客
04-21 349
PostgreSQL Keepalived HA：打造高可用数据库集群 去发现同类优质开源项目:https://gitcode.com/ 在现代企业应用中，数据的重要性不言而喻，因此确保数据库的稳定与高效运行至关重要。是一个开源项目，旨在为PostgreSQL数据库提供高可用性（HA）解决方案。本文将深入探讨其功能、工作原理及应用场景，以期吸引更多用户利用这一强大工具。 项目简介 PostgreS...
PostgreSQL的HA解决方案-项目概述
a7892088的博客
09-18 379
　　公司使用的数据库时postgresql，一直运行都很流畅，但是最近java新做的管理平台，由于登录用户较多，并发性比较大。另外新系统可能优化也存在问题，所以pg经常崩溃，所以我就开始研究如何事项pg的高性能，高可用的HA的数据库集群解决方案。主要思路是利用postgresql自带的流复制功能，来实现了双机热备，利用pgpool实现数据库的负载均衡、失败接管、在线回复、消除单点故障，从...
londiste3 copy table' snapshot & PostgreSQL logical replication's snapshot 不同之处
postgrechina的博客
10-14 645
PostgreSQL有物理复制，也有逻辑复制。 物理复制是持续的从XLOG读取block data在对应的物理文件实行recovery的过程。 建立物理备份的standby时，会强制开启一个检查点，然后拷贝数据文件，拷贝完后的数据库其实是不一致的，没有关系，只要从检查点开始的所有XLOG都在，就可以恢复。检查点我们可以通俗的认为是一个snapshot。 那么对于逻辑复制，snap
Londiste 3 replicate case - 1 上节
weixin_34212762的博客
03-30 159
前面讲解过Londiste3的安装, 有不了解的朋友可以参考如下BLOG: http://blog.163.com/digoal@126/blog/static/163877040201242945632912/ 今天将介绍一下使用londiste3, 从PostgreSQL 9.1.3 复制表以及序列到PostgreSQL 9.2beta1. (这种场...
Londiste 3 replicate case - 1 下节
weixin_33923148的博客
03-30 122
- 接下来测试一下复制是否正确, 在主节点上开启pgbench做数据更改的压力测试.postgres@db5-> cat login.sql \setrandom userid 1 200000 select userid,engname,cnname,occupation,birthday,signname,email,qq from user...
Cascaded Shadow Maps技术详解
3. **阴影贴图渲染**：对于每个cascade，分别渲染光源的视线，将场景中的几何体投射到对应的深度纹理上。 4. **阴影测试**：在渲染最终图像时，对每个像素进行阴影测试，比较当前像素在光源空间的位置与对应cascade...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值