Roy,
I will have to look into the MSSQLBackuper, where can I find documents on
that?
Right now the only documentation is in the source code of the
implementation. Have a look at
package org.continuent.sequoia.controller.backup.backupers;
/**
* MSSQL backuper inspired from the PostgreSQL backuper. <br>
* This backuper takes the following options: <br>
* urlHeader: expected URL header for the backend. Default is
* "jdbc:jtds:sqlserver:" <br>
* driverClassName: driver class name to load. Default is the driver class
* defined for the targeted backend. If you need to use a specific
driver for
* backup/restore operation, you can force it here.
* <p>
* To use it, edit the virtual database config's <Backup> node:
*
* <pre>
* <Backup>
* <Backuper backuperName="MSSQLServer"
className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"
options=""/>
* <Backuper backuperName="MSSQLServerWithjTDSDriver"
className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"
options="urlHeader=jdbc:jtds:sqlserver:,driverClassName=net.sourceforge.jtds.jdbc.Driver"/>
* <Backuper backuperName="MSSQLServerWithMSDriver"
className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"
options="urlHeader=jdbc:microsoft:sqlserver:,driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
* </Backup>
*</pre>
*
* Then in the console to take the backups:<br>
* backup mybackend database.dump MSSQLServer \\<fileserver>\<share>
*
* @author <a href="mailto:[EMAIL PROTECTED]">Adam
Fletcher</a>
* @author <a href="mailto:[EMAIL PROTECTED]">Mykola Paliyenko</a>
* @author <a href="mailto:[EMAIL PROTECTED]">Emmanuel
Cecchet</a>
* @author <a href="mailto:[EMAIL PROTECTED]">Stephane Giron</a>
*/
public class MSSQLBackuper implements Backuper
Let me know if the patch in
https://forge.continuent.org/jira/browse/SEQUOIA-906 must be applied.
I'll push it in CVS.
Yep sure does, I figured this much but needed to confirm. I am wondering
what the best way to deal with multiple data centers is then with Sequoia,
any insight you might have I'd love to hear.
It really depends on your environment, workload, replication needs, link
reliability, sensitivity to partitions, etc...
I provide consulting services and custom developments if you are
interested. Feel free to contact me.
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
