User Rating: 0 / 5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

Today while I was coding a DNS plugin against a MariaDB database, I realized that after a long idle time database closes the connection. After googling for a moment, I realized that both MySQL and MariaDB offers in its API a mechanism to allow reconnections.  So here it is the way I did it.

MYSQL *conn, *mystatus;
my_bool reconnect = 1;
conn = mysql_init(NULL);
mysql_options(conn, MYSQL_OPT_RECONNECT, &reconnect);
mystatus = mysql_real_connect(conn, MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB, 0, NULL, 0);

The key here is to add the mysql_options call before the mysql_real_connect.

Modify this to fit your needs.

blog comments powered by Disqus

About

Read about IT, Migration, Business, Money, Marketing and other subjects.

Some subjects: FusionPBX, FreeSWITCH, Linux, Security, Canada, Cryptocurrency, Trading.