Hi Mahmoud,
Please find answers in line...
Please find answers in line...
Dear All ,as I try to configure Postgres Stream Replication Failover strategy some questions pop-up so can you please help on answering these concerns
1. What happens to the master server when I kill the slave server?
It depends on what type replication mode, you use.
i. In case synchronous replication master-slave always running if slave not available then master goes to waiting state.
ii. In case asynchronous replication if slave not available, then master server work.
i. In case synchronous replication master-slave always running if slave not available then master goes to waiting state.
ii. In case asynchronous replication if slave not available, then master server work.
2. Is replication going to affect insert speed on the master server?
All write operation performed on master server only. To improve performance you can use slave for select operations.
3. What happens when I kill master and slave is running? is there an automatic way to check and auto promote ?
If Master kills, then Slave is continue running in recovery mode. You can manually promote the Slave as Master. There are so many tools available to perform the auto failover.
4. If I started inserting into slave (which will become master) server until old master is back, do I have to reverse the configuration?
Yes, you can rebulid manually. There are so many tools available to perform the auto switchover.
