There are real-time replication solutions for both open-source db solutions.
The following is on the MySQL Master-Slave replication:
http://dev.mysql.com/doc/refman/5.0/en/replication.html
PGCluster does Multi-Master Synchronous Replication:
http://pgcluster.projects.postgresql.org/
jbw
Second Delfino wrote:
yeah, figured. thanks :) was kinda hopin that the replication wud be
something close to "real-time".. not the type where you'd replicate at
the end of the day/week/month.. know wat i mean?thanks
On 5/29/06, *Joby Walker* <zorloc-dcz5jOA4Wtdg9hUCZPvPmw@xxxxxxxxxxxxxxxx
<mailto:zorloc-dcz5jOA4Wtdg9hUCZPvPmw@xxxxxxxxxxxxxxxx>> wrote:
Database replication can not be reliably done at the web application
level. It is a *VERY* bad idea. Replication must be at the database
level -- it is the only way to ensure data integrity. Both MySQL and
PostgreSQL have replication solutions as do commercial products.
jbw
Second Delfino wrote:
> is there a way in symfony wherein you have one application but many
> databases and for every transaction committed in one database, you'll
> have a replicate in your main database? furthermore for the same
idea as
> above, what if these are remote databases we're dealing with?
--
Second Delfino
Quezon City, Philippines
|
