Load balancing PostgreSQL with Windows Servers
I have a question concerning the possibilities of load balancing when using PostgreSQL with Windows Servers. On Unix systems this is made possible by using pgpool-II. How can I achieve the same with Windows?
I know that you cannot mix systems when it comes to replication. Pgpool documentation states:
Can I mix different platforms of PostgreSQL as pgpool-II backends, for example Linux and Windows?
In streaming replication mode, no
What about a different scenario? Can I run pgpool on a Unix machine, and configure replication & load balancing on a pool of Windows Servers?
I'm using Windows Server 2008 R2 in case it matters.
Can I run pgpool on a Unix machine, and configure replication & load balancing on a pool of Windows Servers?
Yes, you can. That's probably the best option in your situation, barring porting PgPool-II to Windows.
However, I suspect that load balancing across read replicas isn't necessary most of the time people do it, and that appropriate database tuning, indexing and configuration is often sufficient.
链接地址: http://www.djcxy.com/p/77388.html