postgresql high availability

Use pgpool to achieve high availability of PostgreSQL Pgpool-ii is used to achieve high availability of PG. Based on the stream replication method, two nodes are automatically switched: 1. Single pgpool A. Environment: Pgpool: 192.168.238.129Data1: 192.168.238.130Data2: 192.

release statement-based Middleware Synchronous Yes Yes Yes Slony Bsd Stable Master-slave Asynchronous No No No Bucardo Bsd Stable Master-master, Master-slave Asynchronous No No No Londiste Bsd Stable Master-slave Asynchronous No No No Mammoth Bsd Stalled Master-slave Asynchronous No

| Access Privileges-----------+----------+----------+-------------+-------------+-----------------------Postgres | Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 |TDB01 | Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 |Template0 | Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 | =c/postgres +| | | | | Postgres=ctc/postgrestemplate1 | Postgres | UTF8 | en_US. UTF-8 | en_US. UTF-8 | =c/postgres +| | | | | Postgres=ctc/postgres(4 rows)postgres=# \c TDB01Connected to Database "TDB01" as User "Postgres

. Write the following key scripts for operation:notify_master/etc/keepalived/scripts/to_master.shnotify_backup/etc/keepalived/scripts/to_backup.shBecause the keepalived is called according to the state when the state is converted:When the master state is entered, the Notify_master is called and the corresponding action is taken in the to_master.shNotify_backup is called when the backup status is entered and the appropriate action is taken in to_backup.shCall Notify_backup when the keepalived pro

| 10.10.10.104 | 5432 | 2 | 0.500000 | primary (2 rows) Can find standby has been upgraded to the main, the original host status became 3. The meaning of the status corresponds to: Status is represented by the number [0-3].0-The state is only used for initialization, and the PCP never displays it.1-The node has been started and is not connected.2-The node is started and the connection is buffered.3-the node is closed.Repair and re-joinThe original host after repair, re-provide serv

balance between. More discussion of system performance and architecture is also being carried out around consistency and availability.2) engineering practices for OpenStack, Swift and CapIn contrast to cap theory, OpenStack's distributed object storage System, swift, satisfies availability and partition tolerance, without guaranteeing consistency (optional), but achieving eventual consistency. Swift if the

Since SQLServer2005, Microsoft has provided a variety of high availability technologies to reduce downtime and increase protection for business data. With the continuous release of SQLServer2008, SQLServer2008R2, and SQLServer2012, SQLServer has multiple high availability technologies that meet different scenarios. Bef

Since SQL Server 2005, Microsoft has provided a variety of high-availability technologies to reduce downtime and increase protection of business data, and as SQL Server 2008,sql Server 2008 R2,SQL Server 2012 continues to publish, SQL There are many high-availability technologies in the server that meet different scena

Why to use MySQL high availability cluster In the actual production environment, when the normal MySQL master-slave replication and read/write separation can not meet the actual requirements, it is necessary to consider the MySQL high-availability cluster, for security reasons, when the data access is too larg

There are many types of high-availability clusters in linux, such as common heartbeat, corosync, rhcs, and keepalived. The emergence of these cluster software provides high-availability assurance for our business production environment, this article will briefly introduce how to use heartbeat v2 to build a simple http

There are many types of Linux high-availability clusters, such as common heartbeat,corosync,rhcs,keepalived, which provide a high-availability guarantee for our business production environment. This article will briefly introduce the V2 version of heartbeat to handle a simple HTTP