Hi,
Controllers can not share backends.
In your virtual database you have just 2 different backends (localhost1,
localhost2) and you declare 4.
You have to declare only local backend on each controller.
vm1: localhost1
vm2: localhost2
Regards,
Pierre
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part de
[EMAIL PROTECTED]
Envoyé : 29 May 2008 21:19
À : [email protected]
Objet : [Sequoia] Configuring backends for controllers
Hello
So now that my controllers seems to run, I would like to clarify some
questions..
My scenario looks like:
vm1:
ip: 192.168.64.131
backend(s): localhost1 which points to 192.168.64.131
localhost2 which points to 192.168.64.132
vm2:
ip: 192.168.64.132
backend(s): localhost2 which points to 192.168.64.132
localhost1 which points to 192.168.64.131
Starting controller on vm2, all is fine:
[EMAIL PROTECTED] bin]# ./controller.sh
20:09:55,539 INFO controller.core.Controller Sequoia controller
(2.10.10)
20:09:55,630 INFO controller.core.Controller Loading configuration file:
/usr/lib/sequoia-2.10.10-bin/config/controller/controller.xml
20:09:55,701 INFO controller.core.Controller JMX is enabled
20:09:55,782 INFO controller.core.Controller Starting JMX server on host:
192.168.64.132
20:09:55,784 WARN controller.core.Controller Could not parse RMI Server
Port 'null
20:09:56,165 INFO controller.backup.BackupManager Registering backuper
PostgreSQL to handle format PostgreSQL Plain Text Dump
20:09:56,189 INFO DatabaseBackend.myDB.localhost2 Adding connection
manager for virtual user "user"
20:09:56,207 INFO DatabaseBackend.myDB.localhost1 Adding connection
manager for virtual user "user"
20:09:56,492 WARN sequoia.controller.recoverylog Backend table BACKEND
does not match database table name case (backend)
20:09:56,493 WARN sequoia.controller.recoverylog Checkpoint table
CHECKPOINT does not match database table name case (checkpoint)
20:09:56,493 WARN sequoia.controller.recoverylog Dump table BACKEND does
not match database table name case (dump)
20:09:56,494 WARN sequoia.controller.recoverylog Log table RECOVERY does
not match database table name case (recovery)
20:09:56,560 INFO controller.RequestManager.myDB Request manager will
parse requests with the following granularity: TABLE
20:09:56,576 INFO controller.virtualdatabase.myDB Recovery log size: 0
20:09:56,577 INFO controller.virtualdatabase.myDB Using Hedera properties
file: /hedera_jgroups.properties
20:09:57,047 WARN jgroups.protocols.UDP bind_to_all_interfaces has been
deprecated; use receive_on_all_interfaces instead
-------------------------------------------------------
GMS: address is 192.168.64.132:1033
-------------------------------------------------------
20:09:59,575 INFO controller.virtualdatabase.myDB Waiting 2000 ms for
group membership to be stable
20:10:01,667 INFO controller.virtualdatabase.myDB Group myDB connected to
Member(address=/192.168.64.132:1033, uid=myDB)
20:10:01,669 INFO controller.virtualdatabase.myDB First controller in
group myDB
20:10:01,745 INFO sequoia.controller.recoverylog Checking recovery log
consistency
20:10:01,814 WARN controller.virtualdatabase.myDB Cannot enable backend
localhost2 from a known state. Resynchronize this backend by restoring a
dump.
20:10:01,816 WARN controller.virtualdatabase.myDB Cannot enable backend
localhost1 from a known state. Resynchronize this backend by restoring a
dump.
20:10:01,816 INFO controller.core.Controller Adding VirtualDatabase myDB
20:10:01,822 INFO controller.core.Controller Loading backend interceptor
classes
20:10:01,823 INFO controller.core.Controller Loading frontend interceptor
classes
20:10:01,823 INFO controller.core.Controller Interceptors initialized
20:10:01,829 INFO controller.core.Controller Waiting for connections on
0.0.0.0:25322
20:10:01,832 INFO controller.core.Controller Controller started on
2008.05.29 22 at 08:10:01 PM SAST
20:10:01,833 INFO controller.core.Controller Controller
192.168.64.132:25322 ready, listening to requests ...
20:10:01,836 INFO controller.core.PingResponder Ping responder started
#-----------------------------------------------------------------------------------------------------------------------
#-----------------------------------------------------------------------------------------------------------------------
And I can see all the backends on vm2:
[EMAIL PROTECTED] sequoia-2.10.10-bin]# bin/console.sh
Launching the Sequoia controller console
Initializing Controller module...
Initializing VirtualDatabase Administration module...
Initializing SQL Console module...
Sequoia driver (Sequoia core v2.10.10) successfully loaded.
May 29, 2008 8:10:43 PM java.util.prefs.FileSystemPreferences$7 run
WARNING: Prefs file removed in background
/root/.java/.userPrefs/_!'8!cg"n!#4!}w"v!'4!d!"p!'4!d@"l!'4!d!!u!(:!~@"x!(`!bw"p!'%!.g"j!'8!bg"z!'8!b!"l!#4!d!"l!(g!d!!u!%:!bw"u!(:!bw"s!'`=/prefs.xml
localhost:1090 > admin myDB
Virtual database Administrator Login > admin
Virtual database Administrator Password >
Ready to administrate virtual database myDB
myDB(admin) > show backends
localhost2
localhost1
#-----------------------------------------------------------------------------------------------------------------------
#-----------------------------------------------------------------------------------------------------------------------
However, when starting the controller on vm1, all hell breaks lose:
[EMAIL PROTECTED] bin]# ./controller.sh
15:25:42,515 INFO controller.core.Controller Sequoia controller
(2.10.10)
15:25:42,837 INFO controller.core.Controller Loading configuration file:
/usr/lib/sequoia-2.10.10-bin/config/controller/controller.xml
15:25:43,081 INFO controller.core.Controller JMX is enabled
15:25:43,171 INFO controller.core.Controller Starting JMX server on host:
192.168.64.131
15:25:43,174 WARN controller.core.Controller Could not parse RMI Server
Port 'null
15:25:44,027 INFO controller.backup.BackupManager Registering backuper
PostgreSQL to handle format PostgreSQL Plain Text Dump
15:25:44,105 INFO DatabaseBackend.myDB.localhost1 Adding connection
manager for virtual user "user"
15:25:44,136 INFO DatabaseBackend.myDB.localhost2 Adding connection
manager for virtual user "user"
15:25:44,772 WARN sequoia.controller.recoverylog Backend table BACKEND
does not match database table name case (backend)
15:25:44,775 WARN sequoia.controller.recoverylog Checkpoint table
CHECKPOINT does not match database table name case (checkpoint)
15:25:44,777 WARN sequoia.controller.recoverylog Dump table BACKEND does
not match database table name case (dump)
15:25:44,778 WARN sequoia.controller.recoverylog Log table RECOVERY does
not match database table name case (recovery)
15:25:44,965 INFO controller.RequestManager.myDB Request manager will
parse requests with the following granularity: TABLE
15:25:45,019 INFO controller.virtualdatabase.myDB Recovery log size: 0
15:25:45,023 INFO controller.virtualdatabase.myDB Using Hedera properties
file: /hedera_jgroups.properties
15:25:46,231 WARN jgroups.protocols.UDP bind_to_all_interfaces has been
deprecated; use receive_on_all_interfaces instead
-------------------------------------------------------
GMS: address is 192.168.64.131:1045
-------------------------------------------------------
15:25:49,463 INFO controller.virtualdatabase.myDB Waiting 2000 ms for
group membership to be stable
15:25:49,570 WARN sequoia.controller.recoverylog Checkpoint
Member(address=/192.168.64.132:1033, uid=myDB) joined group
myDB-192.168.64.131:25322-20080529152549479+0200 was stored
15:25:51,466 INFO controller.virtualdatabase.myDB Group myDB connected to
Member(address=/192.168.64.131:1045, uid=myDB)
15:25:51,467 INFO controller.virtualdatabase.myDB Group now contains 2
controllers.
15:25:51,467 INFO controller.virtualdatabase.myDB Checking virtual
database configuration with remote controllers.
15:25:51,832 ERROR controller.virtualdatabase.myDB Virtual database
configuration is not compatible with other controller settings.
15:25:52,225 ERROR controller.jmx.MBeanServer Register mbean of type
sequoia:VirtualDataBase=myDB,type=VirtualDataBase.RequestManager.ParsingCache
failed with error
sequoia:type=VirtualDataBase.RequestManager.ParsingCache,VirtualDataBase=myDB
({2})
15:25:52,235 ERROR controller.xml.DatabasesParser The virtual database
myDB could not be added to the controller (because of Error while joining
group myDB (org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other controller
settings.))
java.lang.Exception: Error while joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller settings.)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.joinGroup(DistributedVirtualDatabase.java:794)
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:728)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:295)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:344)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:227)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:751)
Caused by: org.continuent.sequoia.common.exceptions.ControllerException:
Virtual database configuration is not compatible with other controller
settings.
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.joinGroup(DistributedVirtualDatabase.java:734)
... 29 more
15:25:52,249 WARN controller.core.Controller Loading of virtual databases
configuration file failed (because of The virtual database myDB could not
be added to the controller (because of Error while joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.))).
org.xml.sax.SAXException: The virtual database myDB could not be added to
the controller (because of Error while joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller settings.))
at
org.continuent.sequoia.controller.xml.DatabasesParser.endElement(DatabasesParser.java:761)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1528)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:295)
at
org.continuent.sequoia.controller.xml.DatabasesParser.readXML(DatabasesParser.java:344)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:227)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:751)
15:25:52,254 ERROR controller.core.Controller Failed to send file to
Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException: Loading of
virtual databases configuration file failed (because of The virtual
database myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.))).
org.continuent.sequoia.common.exceptions.ControllerException: Loading of
virtual databases configuration file failed (because of The virtual
database myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.))).
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51)
at
org.continuent.sequoia.controller.core.Controller.addVirtualDatabases(Controller.java:234)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:561)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:751)
15:25:52,259 ERROR controller.core.Controller Could not load config file:
/usr/lib/sequoia-2.10.10-bin/config/virtualdatabase/mydb1-distribution-1.xml.
Error is: Failed to send file to Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException: Loading of
virtual databases configuration file failed (because of The virtual
database myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.)))..
org.continuent.sequoia.common.exceptions.ControllerException: Failed to
send file to Sequoia controller:
org.continuent.sequoia.common.exceptions.ControllerException: Loading of
virtual databases configuration file failed (because of The virtual
database myDB could not be added to the controller (because of Error while
joining group myDB
(org.continuent.sequoia.common.exceptions.ControllerException: Virtual
database configuration is not compatible with other controller
settings.))).
at
org.continuent.sequoia.common.exceptions.SequoiaException.fillInStackTrace(SequoiaException.java:103)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at
org.continuent.sequoia.common.exceptions.SequoiaException.<init>(SequoiaException.java:57)
at
org.continuent.sequoia.common.exceptions.ControllerException.<init>(ControllerException.java:51)
at
org.continuent.sequoia.controller.core.Controller.loadXmlConfiguration(Controller.java:567)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpVirtualDatabase(ControllerConfiguration.java:458)
at
org.continuent.sequoia.controller.xml.ControllerParser.configureVirtualDatabase(ControllerParser.java:649)
at
org.continuent.sequoia.controller.xml.ControllerParser.startElement(ControllerParser.java:325)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
at
org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
at
org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:127)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:177)
at
org.continuent.sequoia.controller.xml.ControllerParser.readXML(ControllerParser.java:206)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setUpByXml(ControllerConfiguration.java:275)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.setup(ControllerConfiguration.java:325)
at
org.continuent.sequoia.controller.core.ControllerConfiguration.getController(ControllerConfiguration.java:351)
at
org.continuent.sequoia.controller.core.Controller.main(Controller.java:751)
15:25:52,286 INFO controller.core.Controller Loading backend interceptor
classes
15:25:52,288 INFO controller.core.Controller Loading frontend interceptor
classes
15:25:52,292 INFO controller.core.Controller Interceptors initialized
15:25:52,315 INFO controller.core.Controller Waiting for connections on
192.168.64.131:25322
15:25:52,327 INFO controller.core.Controller Controller started on
2008.05.29 22 at 03:25:52 PM SAST
15:25:52,330 INFO controller.core.Controller Controller
192.168.64.131:25322 ready, listening to requests ...
15:25:52,574 INFO controller.core.PingResponder Ping responder started
#-----------------------------------------------------------------------------------------------------------------------
#-----------------------------------------------------------------------------------------------------------------------
vm1: config/virtualdatabases/db.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="PostgreSQL"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="admin"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="user"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="localhost1" driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.131:5432/db1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="user">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="localhost2" driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.132:5432/db1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="user">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.131:5432/reclog" login="user"
password="user">
<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>
</SEQUOIA>
#-----------------------------------------------------------------------------------------------------------------------
#-----------------------------------------------------------------------------------------------------------------------
vm2: config/virtualdatabases/db.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.10.dtd";>
<SEQUOIA>
<VirtualDatabase name="myDB">
<Distribution>
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="PostgreSQL"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="admin"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="user"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="localhost2" driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.132:5432/db1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="user">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="localhost1" driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.131:5432/db1"
connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="user">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://192.168.64.132:5432/reclog" login="user"
password="user">
<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>
</SEQUOIA>
#-----------------------------------------------------------------------------------------------------------------------
#-----------------------------------------------------------------------------------------------------------------------
I must be configuring the backends wrong in my configs. Any ideas ?
Regards
Willie
-------------------------------------------
South Africas premier free email service - www.webmail.co.za
------------------------------------------------------------------
For super low premiums, click here http://www.webmail.co.za/dd.pwm
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
This mail has originated outside your organization, either from an
external partner or the Global Internet.
Keep this in mind if you answer this message.
The information in this e-mail is confidential. The contents may not be
disclosed or used by anyone other then the addressee. Access to this
e-mail by anyone else is unauthorised.
If you are not the intended recipient, please notify Airbus immediately
and delete this e-mail.
Airbus cannot accept any responsibility for the accuracy or completeness
of this e-mail as it has been sent over public networks. If you have any
concerns over the content of this message or its Accuracy or Integrity,
please contact Airbus immediately.
All outgoing e-mails from Airbus are checked using regularly updated virus
scanning software but you should take whatever measures you deem to be
appropriate to ensure that this message and any attachments are virus
free.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
