Re: two databases from one application
Re: two databases from one application
- Subject: Re: two databases from one application
- From: "Pierce T. Wetter III" <email@hidden>
- Date: Wed, 10 May 2006 15:22:53 -0700
On May 10, 2006, at 1:42 PM, Arturo Perez wrote:
Pierce T. Wetter III wrote:
On May 10, 2006, at 10:34 AM, Anjo Krank wrote:
WO application I am working on was pretty simple up to
this point: one apache webserver and one database
server serving data to it. The things turned more
complicated now: In addition to the first database, we
now want to add access to another database. Both of
these databases have identical schema, and the tables
in question are identical. Think of the second
database as a backup.
The discussion been interesting and all but why not just set up
some sort of replication scheme at the database level? I think all
the RDBMs popular on this list can do that....
The original author, Milan, isn't replicating the object, he's
migrating it in that he's copying the record from database1 to
database2, then deleting the copy in database1.
I suspect some kind of audit trail, like he doesn't really want to
"delete" the object, as much as mark it deleted by moving it into the
other database. So if I'm following the code correctly, the second
database ends up being a record of all the objects that have been
deleted.
Which, as I said, there's much easier ways to do...so I was hoping
Milan would talk about the real problem...
Pierce
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden