Re: [Sequoiadb-discuss] my questions

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Freek,

> I dont know how mailinglists works, so i send the questions to you.
> (you may put also my questions and your answers on it)
>   
You can subscribe to the *seq...@li... 
*mailing list at http://sourceforge.net/mail/?group_id=252061
> At the moment I've got 1 virtualdatabase working over 1 controller and
> three nodes (2 postgresql- and 1 mssql 2005 -server).
> I want to put a another controller in the cluster and connect them to
> the controller en the three nodes.
>
> Here are my questions:
> 1. I cant find an tutorial (with examples) how to place (install,
> configure) an second controller next to the other one.  Could give my
> some tutorials to look at?
>   
In the Sequoia distribution, there is a demo/ directory. Look at the 
demo-distributed-raidb1* scripts.
You will see the configuration files that are used in config/controller 
and config/virtualdatabase.
The install guide in doc/installGuide.pdf should contain step by step 
instructions on how to setup Sequoia with 2 controllers.
> 2. I want to put an connection between the controllers. I read in the
> official documentation and several tutorials that this connection is
> named "appia" and you can put a connection layer on it (hedera,
> jgroups, etc). But i cant find a tutorial/howto to install or
> configure it.
>   
By default, Sequoia 2.10.10 uses JGroups. You should find all necessary 
info in the install guide mentioned above. There are multiple group 
communication config file examples in the config/ directory.
> 3. Do i have change my controller.xml, so that the first controller
> can see controller 2? Or another file?
>   
You need to update your virtual database config file to add a 
'Distributed' element. See the examples and the doc.
> 4. How do i give the controllers a name? In lots of examples i see
> "name=agivenname" but doesn't work (Also if i changed the dtd.)
>   
By default a controller name is it's IP address and port number. It 
cannot be overridden in Sequoia 2.10.10 (it's bogus).
> Here a my working configs of the first controller (the files from
> controller 2 are the same with some ip-adress & port changes):
> == controller.xml ==
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-
> CONTROLLER @VERSION@//EN" "http://sequoia.continuent.org/dtds/sequoia-
> controller-@VERSION@.dtd">
> <SEQUOIA-CONTROLLER>
>   <Controller ipAddress="10.0.2.1" port="25322">
>     <JmxSettings>
>        <RmiJmxAdaptor port="1090"/>
>     </JmxSettings>
>     <VirtualDatabase configFile="topitest.xml"
>       virtualDatabaseName="topitest" autoEnableBackends="true"/>
>   </Controller>
> </SEQUOIA-CONTROLLER>
> ======================
>
> ==topitest.xml (virtualdatabase)==
> <?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="topitest">
>     <Monitoring>
>       <SQLMonitoring defaultMonitoring="off">
>          <SQLMonitoringRule queryPattern="^select"
> caseSensitive="false" applyToSkeleton ="false" monitoring="on"/>
>       </SQLMonitoring>
>     </Monitoring>
>
>     <Backup>
>     <Backuper backuperName="Octopus"
> className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
> options="zip=true"/>
> 	<Backuper backuperName="postgresqlbackuper"
> className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLBinaryBackuper"/>
> 	<Backuper backuperName="mssqlbackuper"
> className="org.continuent.sequoia.controller.backup.backupers.MSSQLBackuper"
> />
>     </Backup>
>
>     <AuthenticationManager>
>       <Admin>
>        	<User username="admin" password="topitest"/>
>       </Admin>
>       <VirtualUsers>
>         <VirtualLogin vLogin="user" vPassword="topitest"/>
>       </VirtualUsers>
>     </AuthenticationManager>
>
>     <DatabaseBackend name="ND1-UBU-RAID1" driver="org.postgresql.Driver"
>       url="jdbc:postgresql://10.0.2.5:5432/topitest"
>       connectionTestStatement="select now()">
>       <ConnectionManager vLogin="user" rLogin="postgres" rPassword="topitest">
>         <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
>           maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
>       </ConnectionManager>
>     </DatabaseBackend>
>
>     <DatabaseBackend name="ND2-UBU-RAID1" driver="org.postgresql.Driver"
>       url="jdbc:postgresql://10.0.2.7:5432/topitest"
>       connectionTestStatement="select now()">
>       <ConnectionManager vLogin="user" rLogin="postgres" rPassword="topitest">
>         <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
>           maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
>       </ConnectionManager>
>     </DatabaseBackend>
> 	
> 	<DatabaseBackend name="ND3-WIN-SQL-R1"
> driver="net.sourceforge.jtds.jdbc.Driver"
>       url="jdbc:jtds:sqlserver://10.0.2.9:1433;DatabaseName=topitest;SelectMethod=Cursor"
>       connectionTestStatement="select 1">
>
>       <ConnectionManager vLogin="user" rLogin="sa" rPassword="topitest">
>         <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
>           maxPoolSize="50" 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://10.0.2.1:5432/recovery"
> login="postgres" password="topitest">
>         <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 hope that this will get you started.

Thanks for your interest in Sequoia,
Emmanuel

-- 
Emmanuel Cecchet
FTO @ Frog Thinker 
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: ma...@fr...
Skype: emmanuel_cecchet