23 Apr
2010
23 Apr
'10
10:40 a.m.
Hi,
On Fri, 23 Apr 2010 00:52:48 +0900 Romeo Theriault romeotheriault@gmail.com wrote:
Yes, sounds like a good use-case for flexclones.
Fine.
We are also thinking about using FlexClone for rapid switching between dev and prod environments, but the main need is the above one.
I'm not a DBA, so maybe it's my lack of understanding in the topic area, but I'm not entirely sure what you mean by rapid switching between dev and prod environments. But with mysql you could bring the DB down, change the datadir variable in the my.cnf file to point to the new data files and then bring mysql back up on those. Is that what you mean?
I'm not a DBA either -- the idea was to *not* bring the DB down ;-) I realise this will be difficult, though.
Thanks, Simon
--
Simon Vallet
Ingénieur systèmes, réseaux, sécurité
CEA DSV/IG/GEN - Genoscope
Tél.: +33 1 60 87 36 06
Mél.: sjv@genoscope.cns.fr