Ok great. What about the other tables though? -Eric
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel Cecchet Sent: Thursday, November 06, 2008 1:05 PM To: Sequoia general mailing list Subject: Re: [Sequoia] MySQL Recovery Log Configuration Eric, Performance is not an issue for the log table since the index in on the id not the sql. For the checkpoint table, this table is always going to be very small so it does not really matter whether you have an index or not. The checkpoint names are built as follows: SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmssSSSZ"); return (event + "-" + controller.getControllerName() + "-" + dateFormat .format(new Date(System.currentTimeMillis()))); The longest event name is probably "transfer backend: " + db.getName() + " from " + controller.getControllerName() + " to " + targetMember.getUid() So using VARCHAR(4096) should be safe in that case. Hope this helps, Emmanuel > What about the performance impact of using Text vs VARCHAR. There is also a > field "name" in the Checkpoint table that is a PRIMARY KEY and hence cannot > be TEXT, what do I do with that one? VARCHAR(255)? Would it be better to do > VARCHAR(4096) or something instead of TEXT? > > -Eric > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emmanuel > Cecchet > Sent: Thursday, November 06, 2008 12:13 PM > To: Sequoia general mailing list > Subject: Re: [Sequoia] MySQL Recovery Log Configuration > > Hi Eric, > > Use TEXT instead of VARCHAR for fields of undefined length. > > Thanks for your interest in Sequoia, > Emmanuel > >> >> I am trying to setup Sequoia to Mirror two MySQL Servers. I have >> everything working, but the Controller fails to create the RecoveryLog >> Tables. I believe this is because VARCHAR without a length doesn't >> seem to be valid on MySQL 5.0 (what I am using). What should I set >> the type of the fields in the RecoveryLog Tables to? Or what size >> should I give them? Anyone? >> >> >> >> -Eric >> >> >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> https://forge.continuent.org/mailman/listinfo/sequoia >> > > > -- > Emmanuel Cecchet > FTO @ Frog Thinker > Open Source Development & Consulting > -- > Web: http://www.frogthinker.org > email: [EMAIL PROTECTED] > Skype: emmanuel_cecchet > _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
