Multiple instances or multiple schemas?
HI, everyone
I'll be working with two databases, and I've got a chance to create mutiple instances (using mysqld_multi) or create multiple schemas in the same database. One of them will be highly transactional (Java EE glassfish web app) the other one will be the standby database, sometimes there will be connection to both DBs, but most of the time there wil be connections to the main DB only. Which method will you guys recommend? I'm asking, 'cause I'm thinking about threads, pools, etc.
Ps.
I will appreciate access to some related links (blogs, magazines...), thanks!
Victor M. Ramirez
Edited 1 time(s). Last edit at 06/14/2011 01:20PM by Victor Ramirez.
Subject
Views
Written By
Posted
Multiple instances or multiple schemas?
1996
June 14, 2011 11:24AM
732
June 15, 2011 11:55PM
720
June 16, 2011 05:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.