First time here? Check out the FAQ!
1

multi instances sharing one db a problem?

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

mether's avatar
1.5k
mether
asked 2011-08-19 11:47:58 -0600
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

0

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.

Evgeny's avatar
13.2k
Evgeny
answered 2011-08-21 07:01:56 -0600
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
2

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 http://en.wikipedia.org/wiki/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.

toshio's avatar
36
toshio
answered 2011-08-22 11:06:01 -0600
edit flag offensive 0 remove flag delete link

Comments

1
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
add a comment see more comments