Embedded Server

Since version 4.0 MySQL server supports Embedded server. Embedded server is an easy to install server used by applications that do not require multi-user work with MySQL server. For example, Embedded server can be used for money access machines, automatic cash desks, different electronic facilities and so on. Please refer to MySQL Reference Manual for more details on features and using of Embedded server. Also you can find some information about licensing Embedded server in MySQL Reference Manual. Please refer to Embedded Demo for a sample.

Which version of Embedded server to use

MySQL Embedded Server 4.0 should be recompiled to be used in your application.

MySQL Embedded Sever 5.0 is not included into the binary installation pack. Below is a quotation from the MySQL Reference Manual:

"The Embedded MySQL server library is NOT part of MySQL 5.0. It is part of previous editions and will be included in future versions, starting with MySQL 5.1."

That is why we have not tested MyDAC with the MySQL Embedded Sever 5.0.

So, we recommend using MySQL Embedded Server 4.1. As MySQL Embedded Server has some problems working with the InnoDB storage, we recommend disabling this storage engine. You can do this by checking the "Disable InnoDB storage engine" option in the TMyEmbConnection editor on the Params tab. Another way is to add the --skip-innodb parameter to the TMyEmbConnection component manually.



On the start (first opening a connection), MySQL Embedded Server searches for the setting values in the next order:

Usually to set-up Embedded Server it is enough to set basedir and datadir.But sometimes some additional settings are required, for example to disable usingInnoDB engine (--skip-innodb). The detailed list of settings you can find at MySQL Reference Manual.

Pay attention that all paths must be set through "/" but not "\".

Note, parameters names are case-sensitive.

If datadir is located in the read-only storage, then you need to set OnLog andOnLogError event handlers to prevent server from attempts to create log-files in datadir.


Simultaneous access to the same data from several instances of MySQL server (for example, to MySQL server and Embedded server) can be a reason of data loss.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback