Emmanuel:
Thanks for the info on the initialize command.
If I stop the controllers and delete all tables from
both the virtual database and the recovery log database,
will that have the same effect?
Thanks,
Neil
--
Neil Aggarwal, (214)986-3533, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel
Cecchet
Sent: Friday, January 12, 2007 5:03 AM
To: Sequoia general mailing list
Subject: Re: [Sequoia] How to completely reinitialize virtualdatabase?
Hi Neil,
> Is there a way to completely reinitialize a virtualdatabase
> to an empty state?
>
The best way is to use the 'initialize' command and re-populate the
cluster from a selected node. This is similar to the cluster
initialization procedure or procedure to recover from a complete cluster
outage
(http://sequoia.continuent.org/doc/infocenter/topic/org.continuent.sequoia.d
oc/html/Activating_the_cluster.html)
> It is good enough to stop the controllers and delete
> all the tables from the backend databases?
>
No, you need to cleanup the virtual database recovery log. This is what
the 'initialize' command does basically.
You can drop the recovery log database manually if you wish to do that
manually.
Hope this helps,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
