We are developing a web based solution running on Linux and uses MySQL as database. We have the challenge that we have to fetch data from a Lotus Domino 5.1 database. This works very slow because the connection to the Lotus database is slow and we do not get our client to update this. So we like to build a synchronization tool that automatically synchronized the Lotus with Mysql as soon a table has changed on either of the databases. This way the client can continue to work on Lotus and we have a copy on MySQL for the fast access on the web to keep our application performance.
I wonder if anyone ever has heard of a product that is affordable or open source. Any assistance would be welcome. I look for products, articles, links, etc. anything that would help us on either creating it from scratch or buy a existing solution.