Hello I have tried that as well, but then when I want to transfer the backup from localhost1 to the other backend (running on the other controller), then vm1 does not know about that backend. Unfortunately I am not near the vm's right now, thus I can't give you the output I get. Will do so later today.
Regards Willie > 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 > ------------------------------------------- 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
