Hi

Has anyone any knowledge of replicating data from SQL Server (2000 or 2005) into InfoBright/MySQL?  I’m looking into methods of doing real(ish)-time updates of changing data into Infobright.  I’ve seen it was possible, with a bit of poking, to get SQL2000 to replicate into MySQL 3.51, but haven’t seen any recent articles on the subject.

Andy

Andy,

The short answer is that I’m not aware of anyone trying to replicate from SQL Server to Infobright.

Besides the technical hurdles one might encounter, there is a practical challenge to this and it is the design intent of Infobright as an analytical database engine.  Replication, such as a 3rd party log sniffer/forwarder (see DataMirror), replicates committed transactions from the transaction log and Infobright is not optimized for transactional processing.

I realize that one may want to use Infobright to analyze data from a transactional system - since that’s where pretty much all data is originally generated and captured - and perhaps even in the same data structures, but singleton transaction replication is not the method to populate the database.  Consider replicating to a shadow staging database and bulk loading with Infobright’s high performance loader on whatever frequency makes sense for your end users.  This would be a much more efficient method.

Please refer to this blog posting for a discussion on this topic and other items relating to replication with Infobright.

Best wishes,

Thanks for the reply. That’s the method I’m working on now.  I thought it was worth asking - I mean, why re-invent the wheel?