Not tested, but should work: 1) use only 1 binary and only 1 instance 2) make a startup script. when starting in test mode, it will copy your datadir to a ram disk, and will create/overwrite a symlink to the ramdisk. when in normal mode, the script will copy from ram to disk and the symlink will create a symlink to the datadir on disk 3) mariadb datadir will point to the symlink Hope this helps Federico -------------------------------------------- Ven 21/11/14, Pierre GOUPIL <goupilpierre@wanadoo.fr> ha scritto: Oggetto: Re: [Maria-discuss] (no subject) A: Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net> Data: Venerdì 21 novembre 2014, 10:43 Thanks. But sorry if I'm not clear but the two MariaDB instances are on the same machine. Hence the need to be able to choose in which mode I launch the RDBMS. On Fri, Nov 21, 2014 at 10:12 AM, Andrew Braithwaite <andrew.braithwaite@graze.com> wrote: Put your MariaDB 'datadir' on a ramdisk. http://en.wikipedia.org/wiki/RAM_drive A On 21 November 2014 05:30, Pierre GOUPIL <goupilpierre@wanadoo.fr> wrote: Good morning, Is there a way to have MariaDB run in-memory? I mean, without changing the table engines. I have my production code which needs to be persisted to disk, but for my unit tests, it would be great to have an in-memory DB. I'm in the Java world and I've tried HSQLDB but its SQL implementation is way too different than that of MariaDB. Any ideas? Cheers, Zala -- NoT DeaD which can eternal live, Stranger eons death may die. (HP Lovecraft) _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- NoT DeaD which can eternal live, Stranger eons death may die. (HP Lovecraft) -----Segue allegato----- _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp