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]> 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]
> https://forge.continuent.org/mailman/listinfo/sequoia
>
--
여호와는 네게 복을 주시고 너를 지키시기를 원하며
여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며
여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라
(민수기 6:24-26)
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
