| From: | Sacheen Birhade <sacheen(dot)birhade(at)veritas(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | How to choose new master from slaves. |
| Date: | 2022-08-04 07:33:00 |
| Message-ID: | MW4PR20MB4525A0AEC2F749ED7ACA9710F39F9@MW4PR20MB4525.namprd20.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi All,
I have a very basic question about streaming replication feature of Postgres.
Let's assume I have servers A, B, C, D, & E with postgres installed with streaming replication as follow:
A --> B ( sync replication )
A --> C ( async replication )
A --> D ( async replication )
A --> E ( async replication )
A is master & rest are slaves.
Now my question is:
Assume replication link between A & B may/may not stable. If A goes down, how will I choose my new master from slaves? What are criteria to choose new master?
Thanks,
Sacheen Birhade
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sacheen Birhade | 2022-08-04 07:40:56 | switch between async to sync automatically |
| Previous Message | BeeRich Lists | 2022-07-22 14:42:52 | log_directory & Permissions |