[+/-]
The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application. The main benefits are increased speed and more simple management for embedded applications.
The embedded server library is based on the client/server version of MySQL, which is written in C/C++. Consequently, the embedded server also is written in C/C++. There is no embedded server available in other languages.
The API is identical for the embedded MySQL version and the client/server version. To change a threaded application to use the embedded library, you normally only have to add calls to the following functions.
| Function | When to Call |
|---|---|
mysql_library_init() |
Call it before any other MySQL function is called, preferably early in
the main() function. |
mysql_library_end() |
Call it before your program exits. |
mysql_thread_init() |
Call it in each thread you create that accesses MySQL. |
mysql_thread_end() |
Call it before calling pthread_exit()
|
Then, link your code with libmysqld.a instead
of libmysqlclient.a. To ensure binary
compatibility between your application and the server library,
always compile your application against headers for the same series
of MySQL that was used to compile the server library. For example,
if libmysqld was compiled against MySQL 5.1
headers, do not compile your application against MySQL 5.5 headers,
or vice versa.
Because the
mysql_library_
functions are also included in
xxx()libmysqlclient.a, you can change between the
embedded and the client/server version by just linking your
application with the right library. See
Section 21.8.3.40, “mysql_library_init()”.
One difference between the embedded server and the standalone server
is that for the embedded server, authentication for connections is
disabled by default. To use authentication for the embedded server,
define the
HAVE_EMBEDDED_PRIVILEGE_CONTROL
compiler flag when you invoke CMake to configure
your MySQL distribution. See
Section 2.9.4, “MySQL Source-Configuration Options”.

User Comments
Add your own comment.