Posted by: Anonymous Coward
on September 16, 2002 10:21 PM
Please correct me if I'm wrong (and please point me in the right direction!) but I have yet to find a way to implement data replication with a load balancing option to Open-Source databases. The project I work on (<A HREF="http://www.mcve.com/">MCVE</a mcve.com>) is a credit card processing engine for Enterprise clients, and the problem we've run into is Open Source databases aren't cutting it for the 2 million + SQL transactions that our higher-level clients run per day (granted, most of these are INSERTs). A means of load-balancing is crucial, as well as fault tolerance as downtime means lost revenues for these clients.
This is where closed-source (commercial) databases shine, especially Oracle and IBM DB2. I cannot state anything for M$ products as we do not support anything but the UNIX's.
Using the generalization that Open-Source databases are "better" doesn't cut it. Perhaps for the small-business this is true, but open-source databases will not be adopted in the Enterprise until this situation has been corrected. (I do know PostgreSQL is working on some datareplication stuff, but one project seems to do this is PERL, which is obviously not going to offer the required performance<nobr> <wbr></nobr>... I'd say we've still got 2-3 years before PostgreSQL shines in this area)
Learn about Linux
Download Linux
Get Linux help
Data Replication/Load Balancing?
Posted by: Anonymous Coward on September 16, 2002 10:21 PMThis is where closed-source (commercial) databases shine, especially Oracle and IBM DB2. I cannot state anything for M$ products as we do not support anything but the UNIX's.
Using the generalization that Open-Source databases are "better" doesn't cut it. Perhaps for the small-business this is true, but open-source databases will not be adopted in the Enterprise until this situation has been corrected. (I do know PostgreSQL is working on some datareplication stuff, but one project seems to do this is PERL, which is obviously not going to offer the required performance<nobr> <wbr></nobr>... I'd say we've still got 2-3 years before PostgreSQL shines in this area)
#