My question is a lot like this one. However I'm on MySQL and I'm looking for the "lowest tech" solution that I can find. The situation is that I have 2 databases that should have the same data in them but they are updated primarily when they are not able to contact each other. I suspect that there is some sort of clustering or master/s...
I need mysqldump including the data, but in database there are also couple of tables with FEDERATED engine. The mysqldump includes INSERTs for FEDERATED tables too, what makes for exemaple "Duplicate entry" errors (because the table is already filled with data). I can dump structure and data separately and then remove INSERTs for FEDERA...
So I'm trying to create a federated table using the syntax from the docs. Following this, I've created a table like so: CREATE TABLE `federated_table` ( `table_uid` int(10) unsigned not null auto_increment, ..., PRIMARY KEY (`table_uid`) ) ENGINE=FEDERATED DEFAULT CHARSET=latin1 CONNECTION='mysql://user:[email protected]:3306/';...
Perhaps this is not possible yet, but... What's the easiest way to setup Replication or Federation between MySQL and Derby? I need a way for data updates/inserts/deletes into a certain table in Derby to automatically flow into an equivalent identical table in MySQL, as quickly and efficiently as possible. This can be done in applicati...