more than one instance of pgpool for a backend?
От | Janning Vygen |
---|---|
Тема | more than one instance of pgpool for a backend? |
Дата | |
Msg-id | 200410051117.24062.vygen@gmx.de обсуждение исходный текст |
Список | pgsql-general |
Hi, pgpool seems to be very nice. I will use it in production environment as soon as possible, but have a question regarding pgpool: I have four different databases/user combinations which should have different numbers of possible connection. let my db have 80 concurrent connections and i want to divide them like this: admin@db1 10 user@db1 40 admin@db2 5 user@db2 25 At the moment i run four different instances af apache with PHP and connect via pg_pconnect. My MaxClients directives are set to the values above, so if all connections are busy you can't even connect to apache and maybe you get a timeout. That's not nice, but i keep my database from overloading and still have enough resources for different databse/user combination. (OT: I would love to here someone running successful PerChildMPM on apache2, at the moment i need four apaches on four different ports to configure MaxClient) How can i achive it with pgpool? Is it possible to run four pgpools for an backend. running pgpool on port 9000-9004 each configured to the values above and have one database cluster handle the pgpool connections? Can i still use synchronous replication and so on. My first guess is: it should work as pgpool handles all connections via independent preforked childs and it should not matter wheather a child is forked from one parent or another. But as i dont know alle the internals, i would like to here an expert opinion. kind regards, janning
В списке pgsql-general по дате отправления: