All, I am with arron on this one, I have been looking to implement a sqlrelay interface for a while now, the benifit of it is that it gives us an easy migration to other RDBM's such as oracle, which is relatively hard to code natively for. As Aaron pointed out it also solves some if not all of the load balancing and redundancy issues we are facing in a large scale implementation of dbmail. With the right options in my tests against the dbmail schema in mysql it shows little to no performance hit. Except for the way it caches the result sets.
-leif > There's another project out there that, although not specifically > targetted > towards fault tolerance, adresses some of those same issues: > > http://sqlrelay.sourceforge.net/ > > Incidentally, only implementing the varchar datatype isn't as much of a > problem as you might think; right now, all results come back as char > arrays > and any numerical types need to be converted using atoi, strtoull, etc. > > Aaron > > > ""Patrick"" <[EMAIL PROTECTED]> said: > >> Hi, >> >> In a recent interview with Matt Dillon of the DragonFlyBsd project on >> OsNews >> on of his other projects was mentioned as well : BackPlane >> Fault-Tolerant >> Distributed RDMS >> >> The idea from what i can gather with this project is to create a >> scalable >> (for lack of a better word) unkillable fast database server that can be >> easily plugged into other programs. >> >> This project would help alot with a whole lot of the problems that >> people >> have with DBMail ( DB Redundancy, Issues with DB Replication Engines ) >> if of >> course it can be plugged into DBMail and its free... >> >> There are docs on its C API at : >> http://www.backplane.com/docs.shtml?doc=1 >> >> The only problems i have see so far is : >> >> Only one datatype is implemented, 'varchar'. In otherwords, everything >> is a >> string. >> >> We do not support UNIQUE >> >> ( more info at : http://www.backplane.com/docs.shtml?doc=2 ) >> >> Comments ? >> >> P >> >> _______________________________________________ >> Dbmail-dev mailing list >> [email protected] >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev >> > > > > -- > > > > _______________________________________________ > Dbmail-dev mailing list > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
