Hi David,
You have a mistake in your XML. You need to use the sqlColumnName
property to rename the column. Use properties as follows in the
short example shown below.
<RecoveryLogTable
... properties ...
sqlColumnName="sqlsrc"
sqlColumnType="MEDIUMTEXT NOT NULL"
... properties ...
/>
Note that this example also uses TEXT datatype. As I look at your
definition, you'll also want to ensure that your column lengths are
long enough for things like dump paths, which tend to be pretty
hefty. If you look at the Sequoia DTD you'll see that the tables
are properly defined for Hypersonic, which allows VARCHAR to appear
without a length. To work with MySQL you need to translate these
defaults to MySQL values.
Cheers, Robert
On Jul 26, 2007, at 5:09 AM, wxw david wrote:
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
Robert Hodges, CTO, Continuent, Inc.
Email: [EMAIL PROTECTED]
Mobile: +1-510-501-3728 Skype: hodgesrm
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
