Ask Your Question
1

multi instances sharing one db a problem?

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

mether gravatar image

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
2

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

toshio gravatar image

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.

edit flag offensive delete link more

Comments

1
I think askbot also shares user uploaded files(in case you allow them)
Fitoria gravatar imageFitoria ( 2011-08-22 14:23:52 -0500 )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 gravatar imageEvgeny ( 2011-08-22 20:45:17 -0500 )edit
0

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

Evgeny gravatar image

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

Stats

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

Seen: 173 times

Last updated: Aug 22 '11