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
