Hi,

I've a really simple scenario buy i cannot mannage to work it.

I have 1 controller and 2 databases (copied from demo). I have the system
working, and i cut the net connection to database node2. I write to database
node1 and later re-enable net connection to database node2.

The problem is that write operation aren't synchronized into database node2
automatically. what is the problem




my virtual database file:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA @VERSION@//EN" "
http://sequoia.continuent.org/dtds/[EMAIL PROTECTED]@.dtd">

<SEQUOIA>

 <VirtualDatabase name="myDBB">

   <Monitoring>
     <SQLMonitoring defaultMonitoring="off">
        <SQLMonitoringRule queryPattern="^select" caseSensitive="false"
applyToSkeleton ="false" monitoring="on"/>
     </SQLMonitoring>
   </Monitoring>

  <Backup>
     <Backuper backuperName="mysql" className="
org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"/>
     <Backuper backuperName="octopus" className="
org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
   </Backup>


  <AuthenticationManager>
     <AdminUser username="admin" password="curso"/>
     <VirtualUser vLogin="root" vPassword="test"/>
   </AuthenticationManager>

   <DatabaseBackend name="node1" driver="org.gjt.mm.mysql.Driver"
              url="jdbc:mysql://localhost/db1"
connectionTestStatement="select 1">
     <ConnectionManager vLogin="root" rLogin="isthari" rPassword="isthari">
       <VariablePoolConnectionManager initPoolSize="40" idleTimeout="30"
waitTimeout="10"/>
     </ConnectionManager>
   </DatabaseBackend>

  <DatabaseBackend name="node3" driver="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://host2/isthari" connectionTestStatement="select 1">
     <ConnectionManager vLogin="root" rLogin="isthari" rPassword="isthari">
       <VariablePoolConnectionManager initPoolSize="40" idleTimeout="30"
waitTimeout="10"/>
     </ConnectionManager>
   </DatabaseBackend>


   <DatabaseSchema/>

   <RequestManager>
     <RequestScheduler>
        <RAIDb-1Scheduler level="passThrough"/>
     </RequestScheduler>

     <RequestCache>
        <MetadataCache/>
        <ParsingCache/>
<!--       <ResultCache granularity="table"/> -->
     </RequestCache>

     <LoadBalancer>
        <RAIDb-1>
           <WaitForCompletion policy="first"/>
           <RAIDb-1-LeastPendingRequestsFirst/>
        </RAIDb-1>
     </LoadBalancer>


    <EmbeddedRecoveryLog/>

   </RequestManager>

 </VirtualDatabase>

</SEQUOIA>



Thanks

--
--
Jose Hernandez
Dpto. Formacion
Isthari
http://www.isthari.com
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to