Suggestions please.... MySQL and client application

[Bryan]

Hello all,

I have a MySQL DB on a remote server. Currently I retrieve the data for my client application by use of a perl script that generates xml output that my client app reads.
To me this is not very efficient.

Questions:
1. With your components, I can connect direclty to my MySQL DB. This is great. My client user do not always have an internet connection (only periodically due to traveling).
Is is possible to connect to remote MySQL DB, retrieve all records since last check and add the records to local MySQL DB?

2. Does your components work with a local MySQL DB. So I would have a remote master database on my web server, then a client database that gets update records as the user does db updates?

3. If so, do you have any examples on how to use and what is required for having a client side MySQL Database?

I'm using Rad Studio 2007.
I am very interested in your products.
Thank you for any advise and please tell me if I am trying to solve my problem in a not recommended way.

Kind regards,
Bryan

[Antaeus]

It is not a problem for MyDAC to connect to a local MySQL server. Just assign 'localhost' (without quotes) to the TMyConnection.Server property.

I can suggest you two ways to synchronize local databases with the remote one:
- MySQL replication;
- your own procedure for synchronization (for that the TCRBatchMove component of MyDAC can be useful).