maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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