Hi Emmanuel,
The cluster run again after a long time, as I said previously. But my
two backends didn't receive any orders while ebaling a backend.
I use sequoia 2.2.10.
I use the following url :
jdbc:sequoia://192.168.0.235,192.168.0.236/xxx (where xxx is my vdb)
And my VDB :
<VirtualDatabase name="xxx">
<Distribution groupName="xxx"
hederaPropertiesFile="/hedera_appia.properties">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="Octopus" className="...Octopus"
options="dumpServer=192.168.0.235,splitSize=500m"/>
</Backup>
<AuthenticationManager>
...
</AuthenticationManager>
<DatabaseBackend name="mtpdb-1" ...
driver="org.postgresql.Driver" url="jdbc:postgresql://192.168.0.235/xxx"
connectionTestStatement="select now()">
<DatabaseSchema dynamicPrecision="table"/>
<ConnectionManager ... >
<VariablePoolConnectionManager initPoolSize="20" minPoolSize="5"
maxPoolSize="80" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<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>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.0.235/recoverylogs" ... >
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT
NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT
NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="VARCHAR NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL"
tablesColumnType="VARCHAR NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
I have asecond coontroller on another node with the same vdb.
Thank you for your help.
Arnaud.
Emmanuel Cecchet a écrit :
Hi Arnaud,
What version of Sequoia are you using?
What JDBC URL do you use in your client application?
What is your virtual database configuration?
Thanks for the feedback,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
