Diego,
- adding in the xml virtual database setup file:
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"/>
</Backup>
For MySQL you should use the MySQLBackuper instead, Octopus is only for
databases that are not supported by a specific backuper.
- and setting up the RecoveryLog like:
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/demo" login="root" password="*******">
<RecoveryLogTable tableName="logtable"
sqlColumnName="sqlcol"/>
<CheckpointTable tableName="checkpointtable"/>
<BackendTable
tableName="backendtable"/>
<DumpTable tableName="dumptable"/>
</RecoveryLog>
- The tables were created manually as specified in the userGuide
except for the column sql which i changed. And i am using VARCHAR(255)
for those columns
which are specified as VARCHAR.
The Sequoia controller creates the tables automatically, you don't need
to create these tables manually.
VARCHAR(255) is likely to be too small to store SQL. In MySQL post
5.0.3, VARCHAR should store 64K
(http://dev.mysql.com/doc/refman/5.0/en/char.html). If your SQL
statements can be larger, use TEXT instead (see
http://dev.mysql.com/doc/refman/5.0/en/blob.html for the limitations).
Hope this helps,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
