Hi recently needed to setup local instances of MySQL accross clients in order to allow a copy of the database to be made on client macines so that a system could be used remotely i.e: away from the master DB server (reads only). To do this my idea was to deploy local instances of MySQL and setup replicatation so that when in contact with the master all connections would be through it and replication would ensure any updates to the master DB are copied to each client.
For this I needed some way of deploying MySQL automatically as well as setting up the replication that would be neeeded also. For this it turned out that the mxj connector by MySQL almost fitt the bill perfectly apart from the fact that it didnt come with the mysql and mysqldump executables that I needed in order to create DB dumps and imports as needed to setup the replication.
Connector mxj deploys a local instance of MySQL and can import a bundled DB by default however what I needed was to import a remote DB and setup replication. For this I made a few minor adjustments to the mxj source and bundled in the mysql (console) and mysqldump executables for Windows and Linux.