MySQL Embedded Server (libmysqld) 將完整 MySQL 伺服器嵌入應用程式,無需獨立進程、無網路通訊開銷,適合離線桌面應用、測試框架、IoT 閘道端。官方文檔年久失修,本文提供可直接跑通的最小化步驟。
cmake . -DCMAKE_INSTALL_PREFIX=/home/mysql -DWITH_EMBEDDED_SERVER=1
make clean && make -j8 && make install
-DWITH_EMBEDDED_SERVER=1 關鍵開關。libmysqld.a / libmysqld.so 於 libmysqld/。// main.cc
#include
#include
#include
using namespace std;
const char *server_options[] = {
"mysql_test", "--defaults-file=my.cnf", NULL
};
int num_elements = (sizeof(server_options)/sizeof(char*)) - 1;
const char *server_groups[] = {
"libmysqld_server", "libmysqld_client", NULL
};
bool server_started = false;
MYSQL *mysql = NULL;
const char *db = "test";
void start_server() {
cout << "enter start_server()" << endl;
if (mysql_library_init(num_elements,
(char**)server_options,
(char**)server_groups)) {
server_started = false;
cout << "ERROR: start server failed." << endl;
} else {
server_started = true;
cout << "INFO: start server OK." << endl;
}
}
void stop_server() {
cout << "enter stop_server()" << endl;
mysql_server_end();
}
bool connect_server() {
cout << "enter connect_server()" << endl;
mysql = mysql_init(NULL);
if (!mysql) return false;
if (mysql_real_connect(mysql, NULL, NULL, NULL, db, 0, NULL, 0))
return false; // 0 表示成功
mysql->reconnect = 1;
return true;
}
void output_rows(MYSQL_RES *res) {
MYSQL_ROW row;
while ((row = mysql_fetch_row(res))) {
mysql_field_seek(res, 0);
for (unsigned i = 0; i < mysql_num_fields(res); ++i)
cout << row[i] << "\t";
cout << endl;
}
}
int main() {
start_server();
if (!server_started) return 1;
if (!connect_server()) {
cerr << "Connect failed: " << mysql_error(mysql) << endl;
stop_server(); return 1;
}
// 建表、插入、查詢示範
mysql_query(mysql, "CREATE TABLE IF NOT EXISTS t (id INT PRIMARY KEY, val VARCHAR(20))");
mysql_query(mysql, "INSERT INTO t VALUES (1, 'hello'), (2, 'embedded')");
MYSQL_RES *res = mysql_store_result(mysql); // 無結果集也需呼叫清理
if (res) { mysql_free_result(res); }
if (mysql_query(mysql, "SELECT * FROM t")) {
cerr << "Query failed: " << mysql_error(mysql) << endl;
} else {
res = mysql_store_result(mysql);
output_rows(res);
mysql_free_result(res);
}
mysql_close(mysql);
stop_server();
return 0;
}
# GNUmakefile 關鍵片段
topdir := /home/mysql/mysql-5.5.35
inc := $(topdir)/include
lib := $(topdir)/libmysqld
CXX := g++
CPPFLAGS := -I$(inc) -D_THREAD_SAFE -D_REENTRANT
CXXFLAGS := -g -Wall
LDLIBS := -L$(lib) -lmysqld -lm -lcrypt -ldl -lz -lrt -lpthread
sources := $(wildcard *.cc)
targets := $(basename $(sources))
all: $(targets)
%: %.cc
$(CXX) $(CPPFLAGS) $(CXXFLAGS) -o $@ $< $(LDLIBS)
clean:
rm -f $(targets) *.o *.core
make
cd /home/mysql
scripts/mysql_install_db --defaults-file=my.cnf
./main
| 步驟 | 關鍵 API / 檔案 | 注意事項 |
|---|---|---|
| 編譯 | -DWITH_EMBEDDED_SERVER=1 | MySQL 5.7+ 已移除 Embedded,建議用 5.6/5.5 分支 |
| 初始化 | mysql_library_init() | 傳入 --defaults-file 指定 my.cnf(含 datadir、socket 等) |
| 連線 | mysql_real_connect(..., NULL, NULL, NULL, db, 0, NULL, 0) | host/user/passwd 傳 NULL 走 Embedded 協議;port=0、unix_socket=NULL |
| 關閉 | mysql_server_end() | 釋放全域資源,必須成對呼叫 |
| 配置檔 | my.cnf 需含 [libmysqld_server]、[libmysqld_client] 群組 | 否則啟動失敗 |
datadir,不支援多進程並發存取。Embedded 適合「單機、單進程、零運維」的輕量級場景;若需多連線、高可用、雲原生,請直接部署標準 MySQL 服務。