[Pgpool-general] difference between master and primary node in streaming mode

[Lazaro Rubén García Martinez]

Streaming replication mode is a master-slave replication system, this method allows to have a copy of the database, in a different database server. The purpose of this, is continues with the database service with slaves, in case of failures in the master or primary server. Streaming replication can be combined with host standby, allowing read queries in the slave or standby servers, for balancing the load between the servers.

Regards.

-----Mensaje original-----
De: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-bounces at pgfoundry.org] En nombre de Jeff Frost
Enviado el: miércoles, 05 de octubre de 2011 02:39
Para: pgpool-general at pgfoundry.org
Asunto: [Pgpool-general] difference between master and primary node in streaming mode

What's the difference between the master and primary node in streaming
replication mode?

Occasionally, in my testing, I see this:

Oct  5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node_repeatedly:
waiting for finding a primary node
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: last message repeated 10 times
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node: 0 node is standby
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: last message repeated 10 times
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: find_primary_node: primary node
id is 1
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: failover: set new primary node: 1
Oct  5 11:36:08 31214-1-807393 pgpool[28871]: failover: set new master node: 0

Note that the primary and master are different.  I understand that the primary
node is considered whichever node is not in recovery mode, but what is the master?

-- 
Jeff Frost <jeff at pgexperts.com>
CTO, PostgreSQL Experts, Inc.
Phone: 1-888-PG-EXPRT x506
FAX: 415-762-5122
http://www.pgexperts.com/ 

_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general