when i start my controller with two mysql backends,i just cannot initialize
backends,the console tell me recovery log is required.
however,when i add recovery log element as follows:
<RecoveryLog driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/test"
login="user" password="">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR(8) NOT NULL" sqlddColumnType="VARCHAR(8)
NOT NULL"
extraStatementDefinition=",PRIMARY KEY (id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR(8) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR(8) NOT NULL"
backendNameColumnType="VARCHAR(8) NOT NULL"
checkpointNameColumnType="VARCHAR(8) NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR(8) NOT NULL"
dumpDateColumnType="VARCHAR(8) NOT NULL"
dumpPathColumnType="VARCHAR(8) NOT NULL"
dumpFormatColumnType="VARCHAR(8) NOT NULL"
checkpointNameColumnType="VARCHAR(8) NOT NULL"
backendNameColumnType="VARCHAR(8) NOT NULL"
tablesColumnType="VARCHAR(8) NOT NULL"/>
</RecoveryLog>
and then i start controller as follows:
./controller.sh -f ~/CJDBC/config/controller/controller-raidb1.xml
20:11:06,277 INFO controller.core.Controller Sequoia controller (2.10.8)
20:11:06,415 INFO controller.core.Controller Loading configuration file:
/home/oracle/CJDBC/config/controller/controller-raidb1.xml
20:11:06,535 INFO controller.core.Controller JMX is enabled
20:11:06,582 INFO controller.core.Controller Starting JMX server on host:
192.168.0.166
20:11:06,963 ERROR controller.xml.DatabasesParser Xml document has not been
validated.
20:11:06,963 ERROR controller.xml.DatabasesParser Attribute "sqlddColumnType"
is not declared for element "RecoveryLogTable".
20:11:06,966 WARN controller.core.Controller Loading of virtual databases
configuration file failed (because of Controller Xml configuration file is not
valid.).
org.xml.sax.SAXException: Controller Xml configuration file is not valid.
it seems that the column names of tables in recovery log are fixed(when i
modify the column name "sql" to "sqldd",it throwed error),but column name "sql"
is not valid in mysql,how can i do?
does RAIDb-1 need recovery log?why the tables and the schema of tables of
recovery log are fixed?anyone who had configured mysql cluster can give me some
suggestion?
any suggestion i will great appreciate!
---------------------------------
雅虎免费邮箱3.5G容量，20M附件！_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
