Thanks Sergei, I think I'll look for that. I'll tell you all how it goes.
Cheers!
Hi, Pierre!
On Nov 21, Pierre GOUPIL wrote:
> 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?
If you want to start two different mysqld processes, search for
--datadir command line option.
If you want to have that within one mysqld process (one database on
disk, another on /dev/shm) use symlinks or DATA DIRECTORY/INDEX
DIRECTORY table options.
Regards,
Sergei