Replicating mysql DB to local machines

Replicating mysql DB to local machines

am 17.07.2006 14:33:22 von dcha

We have an application written for a PDA that we are switching from MS
Access to Mysql. There is a central server that has all the data in a
mysql database, however when we sync from the PDA it is much faster
sync'ing to a local copy of the mysql database then on central server
(users are remote and must VPN into server).

What are the options for taking a larger mysql database and segmenting
out data for a particular user (a subset of total data) to their local
machine? Is mysql replication a good option or is there some other
technique?