Thanks Once Again Emmanuel, Got it all setup, I was confused if this was possible due to the virtualDatabaseName directive in controller configuration (this is a required field).
So I just put in whatever name and config file there to keep the sequoia controller happy at startup. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: Monday, March 10, 2008 11:04 AM To: Sequoia general mailing list Subject: Re: [Sequoia] SQL Query Jonathan, > Can I define in one controller configuration file, 3 different virtual > databases and their backends w/recovery logs? > You can load as many virtual database configuration files as you want in a controller. Controller and virtual database configuration files must be different, but having multiple virtual database configurations in the same file should work. > Currently I have 4 databases, (mysql, foobar1, foobar2, foobar3) and 4 > controllers. I'd like to have one controller (eventually 2 on different > hosts), talking to all of the backends, recovery tables, etc. > Yes you can have 1 controller and load the 4 virtual databases in it. > Furthermore can I define all virtualdatbases within one configuration > file? So when I load virtualdatabase configuration /path/to/vdb.xml the > command show virtualdatabases will list all databases in question? > I am not sure that the 'load virtual database' command of the console allows that, but in your controller config file you can specify to the controller which virtual database to load from which file (eventually the same one) at startup time. Thanks for your interest in Sequoia, Emmanuel -- Emmanuel Cecchet - Research scientist EPFL - LABOS/DSLAB - IN.N 317 Phone: +41-21-693-7558 _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
