SQLRelay takes care of load balancing and fail over, and also gives a very good abstraction layer with such goodies as variable binding (which may be able to help us escape the escaping and quoting concerns we have now).
What it won't help with is *redundancy* for which we'll need to design better schemas that are able to handle insertions to multiple copies of the database without needing to have a single "key master" to keep it all consistent. Aaron ""Leif Jackson"" <[EMAIL PROTECTED]> said: > 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 > >> Dbmail-dev@dbmail.org > >> http://twister.fastxs.net/mailman/listinfo/dbmail-dev > >> > > > > > > > > -- > > > > > > > > _______________________________________________ > > Dbmail-dev mailing list > > Dbmail-dev@dbmail.org > > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > > > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > --