merge? replicate? synch? federated tables? mysqldumps?

[fdelval2]

Hi,

 

I have 3 client tables I would like to merge into a single one in the central server.

 

Those client tables won't have conflicting PK, and can only insert data.

 

 

 

 

 

I thought of federated tables, but network sortages really ARE an issue, so I dismissed it. The approach should be able to store data locally, but send it to the server when available, and the server would store it altogether in a single table.

 

What would be the best approach to it?

 

 

 

Thank you