Ask Your Question

multi instances sharing one db a problem?

asked 2011-08-19 11:47:58 -0600

mether's avatar

For the Fedora deployment, our infrastructure team wants to run Askbot in multiple machines for redundancy/high availability and have those connect to a single DB (since our DB system is not replicated yet). Is there any problems with this setup?

We are using Postgresql 8.4 with python-psycopg2-2.0.13 in RHEL 6

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2011-08-22 11:06:01 -0600

toshio's avatar

At the level we were asking, it's a coding question ;-) most web applications these days have an architecture where the only thing shared between instances is the database (Used to be called Shared Nothing but the database is shared so it's not really.) This allows deploying the web application to multiple application servers easily and the database is the only SPOF.

There are, however, still some apps that are coded that need to share other resources besides a database. For instance, we ran an application that needed to cache code repositories from hundreds of projects around the internet. This was an expensive operation in terms of disk and bandwidth and the cache could get out of sync between app servers. We ended up needing to create a nfs share for this data and forcing the cache to be created and synced only on a single node.

So really, we're asking whether askbot is a standard web app that just needs to share the database or if there's other dynamic, shared resources that we need to know about.

edit flag offensive delete link more


I think askbot also shares user uploaded files(in case you allow them)
Fitoria's avatar Fitoria  ( 2011-08-22 14:23:52 -0600 )edit
That's right - database, uploaded and the static files are shared. User sessions are stored in the database by default. You can share a memcached instance too.
Evgeny's avatar Evgeny  ( 2011-08-22 20:45:17 -0600 )edit

answered 2011-08-21 07:01:56 -0600

Evgeny's avatar

I think this is fully a deployment issue, hopefully your system administrators can figure this out. If you think something is missing in askbot to support this - please let us know.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2011-08-19 11:47:58 -0600

Seen: 301 times

Last updated: Aug 22 '11