Hi, By defining your sqlColumnDataType to VARCHAR(1024), your recovery log will fail with the first SQL statement that is more that 1K (statement and encoded parameters). You'd better have an application that generates very compact SQL! Checkpoints can occasionally be larger that what you defined as well (see other email to Eric).
Thanks for your feedback, Emmanuel Bogon Choi wrote: > I am using this configuration. But, this is not a perfect answer, I > think. Change if you want. > > <RecoveryLogTable tableName="logtable" logIdColumnType="BIGINT NOT NULL" > vloginColumnType="VARCHAR(50) NOT NULL" sqlColumnName="sql_data" > sqlColumnType="VARCHAR(1024) NOT NULL" > sqlParamColumnType="VARCHAR(1024)" > extraStatementDefinition=",PRIMARY KEY (log_id)"/> > <CheckpointTable tableName="checkpointtable" > checkpointNameColumnType="VARCHAR(255) NOT NULL"/> > <BackendTable tableName="backendtable" > databaseNameColumnType="VARCHAR(255) NOT NULL" > backendNameColumnType="VARCHAR(255) NOT NULL" > checkpointNameColumnType="VARCHAR(255) NOT NULL"/> > <DumpTable tableName="dumptable" dumpNameColumnType="VARCHAR(255) NOT > NULL" > dumpDateColumnType="TIMESTAMP" > dumpPathColumnType="VARCHAR(255) NOT NULL" > dumpFormatColumnType="VARCHAR(255) NOT NULL" > checkpointNameColumnType="VARCHAR(255) NOT NULL" > backendNameColumnType="VARCHAR(255) NOT NULL" > tablesColumnType="VARCHAR(255) NOT NULL"/> > > > On Thu, Nov 6, 2008 at 2:16 PM, Eric Faden <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > Hey All, > > 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] > <mailto:[email protected]> > https://forge.continuent.org/mailman/listinfo/sequoia > > > > > -- > 여호와는 네게 복을 주시고 너를 지키시기를 원하며 > 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 > 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 > (민수기 6:24-26) > ------------------------------------------------------------------------ > > _______________________________________________ > 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
