What purpose you made it.. Why not use master-slave replication it, you can test in slave server  for test, Or dont use auto commit so you can rollback it, but alter table, drop auto commit Dikirim dari Yahoo Mail pada Android Dari:"Pierre GOUPIL" <goupilpierre@wanadoo.fr> Tanggal:Jum, 21 Nov 2014 pada 15:30 Judul:Re: [Maria-discuss] (no subject) That looks sweet, indeed. But my (quick) search doesn't give me a clue on how to set this up on-demand: I want a DB which persists on disk for the app and another one that stays in memory for the tests. Any pointers, please? Cheers! On Fri, Nov 21, 2014 at 9:15 AM, Oleksandr Byelkin <sanja@montyprogram.com> wrote: Hi! On 21.11.14 06:30, Pierre GOUPIL 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? /dev/shm on Linux (there is something similar for other OSes) 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)

_______________________________________________
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