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
