MySQL Forums
Forum List  »  Performance

Multiple instances or multiple schemas?
Posted by: Victor Ramirez
Date: June 14, 2011 11:24AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Multiple instances or multiple schemas?
1996
June 14, 2011 11:24AM


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.