create a user with select permission only don't work? 2014-11-21 13:13 GMT-02:00 Irwanto <irwan_forum@yahoo.co.id>:
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 <https://id.overview.mail.yahoo.com/mobile/?.src=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
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle