read-only + writable DAOs (scaling, database replication)
Let's assume I have the following database configuration:
-1 Master Database
-2 Replicated Databases (from Master)
Do I have two types of DAOs? One that's writable (accessing master) and one that's read-only for access to replicated DBs?
E.g.
WritableFooDAO
ReadOnlyFooDAO
*** OR ***
How about getting the connection based on the type of operations. E.g.
void getConnection(boolean writable);
UPDATE/CREATE: getConnection(true);
SELECT: getConnection(false);
-> The getConnection() method would act as a proxy returning a connection from the master / replicated database depending if a read-only connection for SELECT statements was requested.
x
[736 byte] By [mhhdudua] at [2007-11-26 14:59:40] 