Question: Two instances on different server with only one postgres database ?
0
jpvillemin • 10 wrote:
Is this possible to set two instances of galaxy on server 1 and server 2, and to install only one database on server 1 for both of them.
I 'm actually trying to do that. The two instances launch well but when i try to upload file , I get some erros about failing the erase of some metada ....I'm not at work , i don't have the exact error right now.
If i only run one of the instance (even instance on server 1 and database on server 2) it will works fine.
An idea about that ? thanks.
ADD COMMENT
• link
•
modified 3.0 years ago
by
Jennifer Hillman Jackson ♦ 25k
•
written
3.0 years ago by
jpvillemin • 10
Each Galaxy instance must have an independent set of tables otherwise they will stomp all over each other and cause serious problems. Of course, one single postgresql server can support more than one database but every independent Galaxy instance requires a separate database (eg galProd and galTest).
Is it possible to set a kind of mirroring ? Multiple instances on several instances (each with his own database) sharing same histories, dataset etc...
Not that I am aware of. A single instance can be scaled up to cope with thousands of users (eg usegalaxy.org), but each instance must have exclusive control of a complete set of database tables. There was discussion of "federated" Galaxy instances but I'm not sure anyone has working code yet. Send code!