federated tables? synchronization? replication? backup?

[fran cisco]

Hi,

I have a scenario where I don't really know what would be the best approach.



Example



I would like to have a suppliers table, where multiple clients can insert rows.
Ideally, if the table was centralized, it could supply with incremental codes, so it doesn't matter who creates a new record.

Centralized ideal table
_________________________
1 - SupplierA (created by client GERMANY)
2 - SupplierB (created by client FRANCE)
3 - SupplierC (created by client GERMANY)
.
.


In such case, federated tables would be the best, but Internet shortages may occur, thus rendering this option useless.


Then, it is clear that every client should have a local table to insert their records, with some kind of prefix.


Local table for client GERMANY
_________________________
G1 - SupplierA
G2 - SupplierC

Local table for client FRANCE
_________________________
F1 - SupplierB



This way, it would be possible to send it to the server when Internet is available, and then, merge them into a single table on the centralized server.


Centralized server table
_________________________
G1 - SupplierA
G2 - SupplierC
F1 - SupplierB






But I don't know what approach to use.

Crontab job + mysqldump?

Any kind of synch tool?

Could I merge information from multiple client tables into one?

Is there any federated tables which store date while offile?


I really accept any advice or approach you might think of.

thak you