Hi Jordan, Depending on what version of Sequoia you are using, if you create a blank database which the recovery user has access to, when Sequoia originally starts up it will create all the relevant tables for you. I discovered this after trying to determine how to create the tables myself.
Regards, On Tue, 02 Oct 2007 11:49:05 -0700 Jordan Michaels <[EMAIL PROTECTED]> wrote: > There we go. I found what I was looking for (example "Create table" > statements) in the DTD: > > http://sequoia.continuent.org/dtds/sequoia-2.10.9.dtd > > =) > > Warm regards, > Jordan Michaels > Vivio Technologies > http://www.viviotech.net/ > BlueDragon Alliance Member > [EMAIL PROTECTED] > > > Jordan Michaels wrote: > > Hey Robert, > > > > Hmm... That XML file looks almost exactly like the one I've been > > looking at. I guess I'm just confused as to how the XML file > > explains what fields I need to create in order to build proper > > recovery tables. > > > > So no one has any working examples of tables that they're using? I'm > > just looking for example structures to point me in the right > > direction. > > > > Thanks in advance! > > > > Warm regards, > > Jordan Michaels > > Vivio Technologies > > http://www.viviotech.net/ > > BlueDragon Alliance Member > > [EMAIL PROTECTED] > > > > > > Robert Hodges wrote: > >> Hi Jordan, > >> > >> Look in the example XML files under doc/example, such > >> as RAIDb1-postgresl-cluster.xml. They show the tags to define > >> recovery log tables. > >> > >> Thanks, Robert > >> > >> Robert Hodges, CTO, Continuent, Inc. > >> Email: [EMAIL PROTECTED] > >> <mailto:[EMAIL PROTECTED]> Mobile: +1-510-501-3728 > >> Skype: hodgesrm > >> > >> > >> On Oct 1, 2007, at 3:32 PM, Jordan Michaels wrote: > >> > >>> Hey all, > >>> > >>> I'm in the process of setting up a proof-of-concept cluster using > >>> Sequoia. If I can get it up and working, I will be demonstrating > >>> it to a board of directors in the next couple weeks who are > >>> pretty anxious to see a functional example. > >>> > >>> Right now, I'm at the part where you set up the recovery tables > >>> in your recovery database, but I'm concerned that I'm not seeing > >>> all the columns that I will be needing in my databases. I'm > >>> looking at this page: > >>> > >>> http://sequoia.continuent.org/doc/infocenter/topic/org.continuent.sequoia.doc/html/Write_the_RequestManager_element_definition.html > >>> > >>> And it implicitly gives SQL code on how to set up the first > >>> table, but there are three more that it doesn't give example SQL > >>> code for. I could attempt to guess at the table structure based > >>> on the parameters of the example XML virtual database config > >>> file, but I noticed that the example recovery log table does have > >>> an actual table row that is not specified in the attributes of > >>> the XML file (the "sqlColumnName_param" column - it's not > >>> mentioned in the "hsqldb-raidb1-distribution-1.xml" file). > >>> > >>> Would someone be willing to share the SQL table structure code > >>> for these other 3 tables they have set up and working? If someone > >>> wouldn't mind posting that, I would be very appreciative. > >>> > >>> Thanks in advance! > >>> -- > >>> Warm regards, > >>> Jordan Michaels > >>> Vivio Technologies > >>> http://www.viviotech.net/ > >>> BlueDragon Alliance Member > >>> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >>> _______________________________________________ > >>> Sequoia mailing list > >>> [email protected] > >>> <mailto:[email protected]> > >>> https://forge.continuent.org/mailman/listinfo/sequoia > >> > >> ------------------------------------------------------------------------ > >> > >> _______________________________________________ > >> Sequoia mailing list > >> [email protected] > >> https://forge.continuent.org/mailman/listinfo/sequoia > > _______________________________________________ > > Sequoia mailing list > > [email protected] > > https://forge.continuent.org/mailman/listinfo/sequoia > > > > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia -- Stuart James Senior Systems Administrator PayPoint Internet Payment Services 203 High Street, Tonbridge TN9 1BW, UK Direct: +44 (0)1732 300205 Mobile: +44 (0)7809 504773 SECPay Ltd registered offices. 1 The Boulevard, Shire Park, Welwyn Garden City, Hertfordshire, AL7 1EL This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. SECPay Ltd does not accept responsibility for changes made to this message after it was sent. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by SECPay Ltd in this regard and the recipient should carry out such virus and other checks as it considers appropriate. _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
