473,387 Members | 1,834 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

more than one instance of pgpool for a backend?

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1
0 1032

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Krishna Prasad | last post by:
Hello, I am in the process of designing the following kind of system -- A MySQL database holds hundreds of thousands of entries. All of these entries are periodically processed by a set of...
5
by: Derickson | last post by:
I am working with a production runtime Access 2000 db, split front-end and back-end. Running on a network, I need a nightly copy of the backend transferred to a laptop with a temporary network...
116
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data...
2
by: cmd | last post by:
I use a utility database and the following code to link from an original backend to a temporary backend, in order to replace the original with a newer version: Dim dbs As Database Dim tdf As...
4
by: Wayne | last post by:
I have a backend database (Backend1.mdb)that has 3 main data tables, I'll call them Data1, Data2 and Data3, plus several other associated tables. All relationships are set in the backend database...
0
by: Tatsuo Ishii | last post by:
pgpool 1.0, yet another open source replication software for PostgreSQL is now available at: ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-1.0.tar.gz pgpool is a single master/query...
1
by: postgresql.org | last post by:
I've started using pgpool and while everything appears to be working, I've been getting a lot of the following errors in my logs: ---- ERROR: pid 14761: pool_read: EOF encountered ---- This...
17
by: ApexData | last post by:
Hello Split DB (FE & BE) Linked. FE compiled to MDE. For security reasons, I have hidden the BackEnd. However, If the network is down or the FE can't find the Backend, then an Access Error...
0
by: ntech | last post by:
Hello, i have successfully installed Pgpool-II in linux but i need to know how to replicate databases using it. i dont understand the steps provided in different sites. so, can anyone help me to...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.