I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover.
.-----. .--------.
| | W | DB |
| PGP |-----+----------->| MASTER |----.
| | | | | |
`-----` | `--------` | STREAMING REPLICATION
| .--------. |
| R | DB | |
+----------->| SLAVE1 |<---+
| |
`--------`
What is the ideal network configuration for this setup.
1) Should I use multiple NICs on the postgres server, so that service and replication can be setup on different networks ?
2) If I use multiple NICs, will PGpool be able to detect the service state and replication state reliably ?
What are the network configuration best practices, in this scenario ?
Thanks for your help.
Aucun commentaire:
Enregistrer un commentaire