Highload website database architecture

classic Classic list List threaded Threaded
1 message Options
a-9
Reply | Threaded
Open this post in threaded view
|

Highload website database architecture

a-9

Hi,

I am building a web app backed by database postgresql and currently the
site is under a humongous torrent of hits. I have a question regarding
the database backend config.

The database folder has a file called postgresql.cons where we can
specify no of active connections to the database -N which is currently
1024 and also specify the shared buffers. Is there any thumbrule in
deciding the -N and also the no of shared buffers for my config of 4
frontend servers and 1 database backend server. There is no global or
memcached mechanisms in use.

Any pointers would be greatly appreciated.

Thanx
a


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups "cherrypy-users" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups-beta.google.com/group/cherrypy-users?hl=en
-~----------~----~----~----~------~----~------~--~---