Dear Slony Users
I have setup slony with one Master and two slaves .it is replicating . when the lot of data (update and inserts) comes from Master ,it takes more time update/insert into the slaves,the systems(slave) becomes very slow.Is there any way tune the Server or we need to use any configuration file to slony process. We replicating around 85 Tables in the replication cluster. Here with I am sending the cluster.sh configuration as below.. #!/bin/sh CLUSTER=test_clust DB1=edge DB2=tuvml DB3=tuvml H1=172.16.70.105 H2=172.16.70.59 H3=172.16.70.91 U1=test U2=test U3=test /usr/local/pgsql/bin/slonik <<_EOF_ cluster name = $CLUSTER; node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U1'; node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U2'; node 3 admin conninfo = 'dbname=$DB3 host=$H3 user=$U3'; init cluster (id = 1, comment = 'Node 1'); store node (id = 2, comment = 'Node 2'); store node (id = 3, comment = 'Node 3'); # between master store path (server = 1, client = 2, conninfo ='dbname=$DB1 host=$H1 user=$U1' ); store path (server = 2, client = 1, conninfo ='dbname=$DB2 host=$H2 user=$U2' ); # from master to replica store path (server = 1, client = 3, conninfo ='dbname=$DB1 host=$H1 user=$U1' ); store path (server = 2, client = 3, conninfo ='dbname=$DB2 host=$H2 user=$U2' ); # from replica to master store path (server = 3, client = 1, conninfo ='dbname=$DB3 host=$H3 user=$U3' ); store path (server = 3, client = 2, conninfo ='dbname=$DB3 host=$H3 user=$U3' ); # # between masters store listen (origin=1, receiver=2, provider=1); store listen (origin=2, receiver=1, provider=2); # from master to replica store listen (origin=1, receiver=3, provider=1); store listen (origin=2, receiver=3, provider=1); store listen (origin=1, receiver=3, provider=2); store listen (origin=2, receiver=3, provider=2); # from replica to masters store listen (origin=3, receiver=1, provider=3); store listen (origin=3, receiver=2, provider=1); store listen (origin=3, receiver=1, provider=2); store listen (origin=3, receiver=2, provider=3); create set (id = 1, origin = 1,comment = 'test tables'); set add table (set id=1, origin=1, id=1, fully qualified name = 'test.muni', comment='test table'); ................ ................ ................ set add table (set id=1, origin=1, id=85, fully qualified name = 'test.muni1', comment='test table'); subscribe set (id=1, provider=1, receiver=2, forward=yes); subscribe set (id=1, provider=1, receiver=3, forward=no); Please help me to improve the system performance. Best Regards G.Muniswamy | DBA-Delivery E-mail: [EMAIL PROTECTED] | Extn: 1618 Sobha Renaissance Information Technology (P) Ltd. An SEI-CMM, P-CMM & SSE-CMM Level 5 Company | BS ISO/IEC 27001:2005 & ISO 9001:2000 Certified A Top 50 Fast Growing Technology Company (Deloitte, 2006) | A Six Sigma Practice Company Phone: + 91 80 41951999 | Fax: + 91 80 41523300 URL: www.renaissance-it.com | Video Conference: + 91 80 41252222 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies from any computer. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
