I'm still having trouble getting sequoia to be happy with the recovery log
and I'm not sure what I'm doing wrong. If I'm understanding the
documentation correctly, all I have to do is create the database where the
logs will be stored, and set up the XML config for sequoia to connect to the
database and create all the tables. I've tried manually creating the tables
myself and starting from an empty database with no tables and I still can't
get it working. Anyone mind looking at my config?
I'm using mysql as the backend database. I modified the sample config to
specify sizes for the VARCHAR columns since mysql requires that. But I've
also tried it without specifying the size and it still isn't working:
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://10.1.2.1:3306/ctl1log" login="test"
password="xxxxxxx">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT
NULL"
vloginColumnType="VARCHAR(255) NOT NULL"
sqlColumnType="VARCHAR(255) NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(255) NOT NULL"
backendNameColumnType="VARCHAR(255) NOT NULL"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<DumpTable tableName="DUMP" 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"/>
</RecoveryLog>
When I use the CLI to try and load my virtual DB config:
load virtualdatabase configuration
/usr/local/sequoia/config/virtualdatabase/test.xml
I get:
Loading of virtual databases configuration file failed (because of Failed to
check JDBC Recovery log tables.).
tcpdump shows that it is at least connecting to the database server and
carrying on a conversation. Unfortunately, I'm having trouble getting mysql
to keep a query log so I can see exactly what query sequoia is building and
trying to run on the server.
-Miles
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
