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…
SRIOV Enhanced Networking in AWS EC2 on Ubuntu-14.04 HVM
The latest EC2 generation of HVM instances makes use of the Enhanced Networking, utilizing the ixgbevf e1000 Gigabit Virtual Function Network Driver which provides significantly faster network layer processing. We can see it is already in use on Ubuntu-14.04 with…
Server side PHP caching in Joomla! with Repcached
Caching provides significant performance speed up since reading data from the memory is much faster then reading it from the database or disk, especially if it resides on a different server. In our case they are on the same one…