Basic Question - Embedded Server

Bryan · Post by **Bryan** » Mon 10 Dec 2007 17:19

Hello group... I have a basic question about MySQL.

If I want to access a MySQL database on a local client machine using MyDAC for MySQL, do I need to install MySQL server, or does the libmysqd.dll library act as the server?

Thanks!
Bryan

Antaeus · Post by **Antaeus** » Wed 12 Dec 2007 09:00

libmysqld.dll is the MySQL Embedded server. You can use this server I you do not need remote connections to your database.

Bryan · Post by **Bryan** » Wed 12 Dec 2007 17:18

Antaeus,
Thank you for your reply.

I will need remote access to my database, but I also want to sycronize my remote database to a local database on the client side for when users are not connected to the internet.
In this case, they will choose to connect to the local client side database instead of the master remote database.
I will have to make the ability to syncronize the local client side to the remote master DB.

Will the libmysqld.dll work for this case?

Thanks for any expert advise you may have.
Regards,
Bryan

Antaeus · Post by **Antaeus** » Thu 13 Dec 2007 12:31

libmysqld.dll will not help in this case. You need one more instance of MySQL Server (not Embedded MySQL).
To synchronize information on your local and remote servers, you may setup replication.