473,799 Members | 2,666 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 1048

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

Similar topics

0
1610
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 backends. Whenever an entry is processed, its related fields are updated. The approaches I am considering for load-balancing are:
5
2196
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 connection so as to be able to run a locally linked version of the database outside of the production environment. No data will be modified; it will be read-only. I am struggling with docmd.transferdatabase and trying to empty the laptop-local...
116
7589
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 and some who couldn't but that it wasn't important right now. And I said, 'sure, we can do that later'. So now I've developed an app without any thought to security and am trying to apply it afterwards. Doh!, doh! and triple doh!
2
3478
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 TableDef Dim Tdfs As TableDefs Dim Pathname As String Set dbs = CurrentDb Set Tdfs = dbs.TableDefs
4
1879
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 which is linked to my frontend. Data3 will grow much more quickly than Data1 and Data2 as it will have much more data added to it on a daily basis. I would like to keep all of the data from Data1 and Data2 to a manageable size so that it can...
0
1409
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 based/synchronous replication server. It acts as a proxy server between PostgreSQL client and PostgreSQL server. No application change is needed to use pgpool. pgpool's features include:
1
3773
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 seems to be simple enough - the client/user probably just canceled the request and isn't anything to be concerned about? I get about a dozen of these per hour on a system that has about 25,000 connections/day.
17
1935
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 reports exactly where the Backend is. This blows my attempt at hidding the Backend file. I have tried to use the DIR() statement to look for the BE in my FormOpen of my 1st form but it seems to be ignored.
0
4283
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 begin it from the beginning. what are the steps to be followed out to replicate postgres database using pgpool-II. its quite urgent. Thanks, ntech
0
9689
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9550
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10269
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10032
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9085
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7573
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5597
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4148
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3764
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.