|
|
|
Wednesday, 29 June 2011 11:53 |
|
How To Set Up A Postgresql 9.0 Hot Standby Streaming Replication Server With Repmgr On OpenSUSE 11.4
This is a tutorial how to set up a postgresql replicated hot standby
server with streaming replication, and we also set up the repmgr to
monitor and manage the replication cluster. Unlike most tutorials that
copy the database file from master to slave (or standby) in the middle
of running pg_start_backup() and pg_end_backup(), repmgr is used to
simplify the whole procedure. (But I still think that procedure helps
you a lot to understand how postgresql warm standby, pitr, and hot
standby replication work.) Read more: |
|
|
Sunday, 05 June 2011 11:10 |
|
How To Set Up MySQL Database Replication With SSL Encryption On Debian Squeeze
This tutorial describes how to set up database replication in MySQL
using an SSL connection for encryption (to make it impossible for
hackers to sniff out passwords and data transferred between the master
and slave). MySQL replication allows you to have an exact copy of a
database from a master server on another server (slave), and all updates
to the database on the master server are immediately replicated to the
database on the slave server so that both databases are in sync. This is
not a backup policy because an accidentally issued DELETE command will
also be carried out on the slave; but replication can help protect
against hardware failures though. Read more: |
|
Sunday, 29 August 2010 15:41 |
|
How To Set Up MySQL Database Replication With SSL Encryption On
Debian Lenny
This tutorial describes how to set up database replication in MySQL
using an SSL connection for encryption (to make it impossible for
hackers to sniff out passwords and data transferred between the master
and slave). MySQL replication allows you to have an exact copy of a
database from a master server on another server (slave), and all updates
to the database on the master server are immediately replicated to the
database on the slave server so that both databases are in sync. This is
not a backup policy because an accidentally issued DELETE command will
also be carried out on the slave; but replication can help protect
against hardware failures though. Read more: |
|
|
Tuesday, 16 February 2010 14:13 |
|
How To Set Up MySQL Database Replication With SSL Encryption On CentOS 5.4
This tutorial describes how to set up database replication in MySQL
using an SSL connection for encryption (to make it impossible for
hackers to sniff out passwords and data transferred between the master
and slave). MySQL replication allows you to have an exact copy of a
database from a master server on another server (slave), and all
updates to the database on the master server are immediately replicated
to the database on the slave server so that both databases are in sync.
This is not a backup policy because an accidentally issued DELETE
command will also be carried out on the slave; but replication can help
protect against hardware failures though. Read more: |
|
Sunday, 07 February 2010 15:04 |
|
How To Set Up MySQL Database Replication With SSL Encryption On Ubuntu 9.10
This tutorial describes how to set up database replication in MySQL
using an SSL connection for encryption (to make it impossible for
hackers to sniff out passwords and data transferred between the master
and slave). MySQL replication allows you to have an exact copy of a
database from a master server on another server (slave), and all
updates to the database on the master server are immediately replicated
to the database on the slave server so that both databases are in sync.
This is not a backup policy because an accidentally issued DELETE
command will also be carried out on the slave; but replication can help
protect against hardware failures though. Read more: |
|
|
|
|
|
|
|
