PostgreSQL High Availibility with Pacemaker
[serialposts] Setting up PostgreSQL synchronous or asynchronous replication cluster with Pacemaker is described in couple of resources like the official Pacemaker site PgSQL Replicated Cluster and the GitHub wiki of the OCF agent creator Resource Agent for PostgreSQL 9.1 streaming…
PostgreSQL Confluence DB replication with Bucardo
In cases where we can’t use the built-in PostgreSQL replication facility, like for example Confluence DB which has replication protection, Bucardo is very efficient option. It is an asynchronous PostgreSQL replication system, allowing for both multi-master and multi-slave operations. Bucardo…
PostgreSQL Archiving Replication
In this mode PostgreSQL replicates the WAL archive logs. Configuring the master server First, create a new user in PostgreSQL, for replication purposes. We’ll use it to connect to the master instance from the slave and replicate data. To create…
PostgreSQL Streaming Replication
Streaming replication means the changes are synchronously applied from the master to the slave(s). First, create the replication user on the master: $ sudo -u postgres psql -c “CREATE USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD ”;” The user created is…
MySQL SSL and client certificates authentication
First lets create a small Camel database with couple of tables on our server.mydomain.com host using the following script: create database camel; grant usage on camel.* to ‘camel’@’%’ identified by ‘[camel-password]’; grant all privileges on camel.* to ‘camel’@’%’ identified by…
MySQL High Availability and Load Balancing with Keepalived
What we want to achieve here is have a MySQL HA two nodes cluster in Master-Master mode and load balance the instances using as less hardware as possible. The role of the LB will be given to Keepalived that will…