Temporary in-memory MySQL Server

Temporary in-memory MySQL Server

Second instance of MySQL server in memory:

Implementation

One time only

Our in-memory server should not expose to network. The only communication should be socket. Therefore skip-networking.

Prepare mysqld_multi for work, but mysqld_multi was not polished enough, so I went for solution to write my init script.

Preparation:

To trick unit-tests into using my new MySQL server:

echo "pdo_mysql.default_socket=/tmp/mysql_temp.sock" >/etc/php5/fpm/conf.d/99-mysql_unittest_temp.ini

Setup

Cleanup:

rm -f /etc/php5/fpm/conf.d/99-mysql_unittest_temp.ini
date 01. Jan 0001 | modified 28. May 2021
filename: MySQL Temporary in-memory instance