mardi 3 février 2015

Recovery when failover


1/ Description:


I have 2 Centos machine: master, slave . Both of them are built on PostgreSQL 9.3 (image below) and configured failover event (failover PG 9.3 document).




  • Last WAL in master (pg_xlog): 0000000100000002000000D8




  • Last WAL in archive log folder in master: 0000000100000002000000D7




  • Last WAL in slave (pg_xlog): 0000000100000002000000D5 (3 WALs latency between slave and master) .




  • recovery.conf file in slave


    standby_mode = 'on' primary_conninfo = 'host=10.12.10.108 port=5444 user=enterprisedb password=123456 ' trigger_file = '/tmp/failover' restore_command = 'scp enterprisedb@10.12.10.108:/opt/archivelog/%f "%p"'




Now (3 WALs latency slave & master), the master fails (shutdown by manual) then the slave begin failover procedures..


2/ Questions:



  • Does slave miss 3 WALs(0000000100000002000000D6, 0000000100000002000000D7, 0000000100000002000000D8) or 1 WAL (0000000100000002000000D8) after failover ? Why ?

  • If I copy all WAL in pg_xlog from master to pg_xlog in slave . Does slave miss WAL after failover? Why ?

  • If I copy all WAL in pg_xlog from master to pg_xlog in slave (last WAL in slave: 0000000100000002000000D8 ) . How slave do a recovery ?


enter image description here





Aucun commentaire:

Enregistrer un commentaire