CVS update of libmysequoia/config (4 files)

    Date: Tuesday, January 31, 2006 @ 17:38:19
  Author: csaba
    Path: /cvsroot/carob/libmysequoia/config

   Added: virtualdatabase/mysql-db3.xml (1.1)
Modified: controller/controller-mysql.xml (1.2 -> 1.3)
          virtualdatabase/mysql-db1.xml (1.3 -> 1.4)
          virtualdatabase/mysql-db2.xml (1.3 -> 1.4)

Added a new backend for sql_comm.


---------------------------------+
 controller/controller-mysql.xml |    1 
 virtualdatabase/mysql-db1.xml   |    2 -
 virtualdatabase/mysql-db2.xml   |    2 -
 virtualdatabase/mysql-db3.xml   |   63 ++++++++++++++++++++++++++++++++++++++
 4 files changed, 66 insertions(+), 2 deletions(-)


Index: libmysequoia/config/controller/controller-mysql.xml
diff -u libmysequoia/config/controller/controller-mysql.xml:1.2 
libmysequoia/config/controller/controller-mysql.xml:1.3
--- libmysequoia/config/controller/controller-mysql.xml:1.2     Thu Dec  8 
14:59:08 2005
+++ libmysequoia/config/controller/controller-mysql.xml Tue Jan 31 17:38:19 2006
@@ -8,5 +8,6 @@
     </JmxSettings>
     <VirtualDatabase configFile="mysql-db1.xml" virtualDatabaseName="db1" 
autoEnableBackends="force"/>
     <VirtualDatabase configFile="mysql-db2.xml" virtualDatabaseName="db2" 
autoEnableBackends="force"/>
+    <VirtualDatabase configFile="mysql-db3.xml" virtualDatabaseName="comm" 
autoEnableBackends="force"/>
   </Controller>
 </SEQUOIA-CONTROLLER>
Index: libmysequoia/config/virtualdatabase/mysql-db1.xml
diff -u libmysequoia/config/virtualdatabase/mysql-db1.xml:1.3 
libmysequoia/config/virtualdatabase/mysql-db1.xml:1.4
--- libmysequoia/config/virtualdatabase/mysql-db1.xml:1.3       Mon Jan  2 
09:41:19 2006
+++ libmysequoia/config/virtualdatabase/mysql-db1.xml   Tue Jan 31 17:38:19 2006
@@ -15,7 +15,7 @@
       </VirtualUsers>
     </AuthenticationManager>
 
-    <DatabaseBackend name="csaba1" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/test?allowMultiQueries=true" 
connectionTestStatement="select 1">
+    <DatabaseBackend name="backend1" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/test?allowMultiQueries=true" 
connectionTestStatement="select 1">
       <ConnectionManager vLogin="user1" rLogin="root" rPassword="rootpass">
         <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" 
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
       </ConnectionManager>
Index: libmysequoia/config/virtualdatabase/mysql-db2.xml
diff -u libmysequoia/config/virtualdatabase/mysql-db2.xml:1.3 
libmysequoia/config/virtualdatabase/mysql-db2.xml:1.4
--- libmysequoia/config/virtualdatabase/mysql-db2.xml:1.3       Mon Jan  2 
09:41:19 2006
+++ libmysequoia/config/virtualdatabase/mysql-db2.xml   Tue Jan 31 17:38:19 2006
@@ -15,7 +15,7 @@
       </VirtualUsers>
     </AuthenticationManager>
 
-    <DatabaseBackend name="csaba2" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/test2?allowMultiQueries=true" 
connectionTestStatement="select 1">
+    <DatabaseBackend name="backend3" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/test2?allowMultiQueries=true" 
connectionTestStatement="select 1">
       <ConnectionManager vLogin="user1" rLogin="root" rPassword="rootpass">
         <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" 
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
       </ConnectionManager>
Index: libmysequoia/config/virtualdatabase/mysql-db3.xml
diff -u /dev/null libmysequoia/config/virtualdatabase/mysql-db3.xml:1.1
--- /dev/null   Tue Jan 31 17:38:19 2006
+++ libmysequoia/config/virtualdatabase/mysql-db3.xml   Tue Jan 31 17:38:19 2006
@@ -0,0 +1,63 @@
+<?xml version="1.0" encoding="UTF8"?>
+<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.3//EN" 
"http://sequoia.continuent.org/dtds/sequoia-2.3.dtd";>
+
+<SEQUOIA>
+
+  <VirtualDatabase name="comm">
+
+    <AuthenticationManager>
+      <Admin>
+               <User username="admin" password="adminpass"/>
+      </Admin> 
+      <VirtualUsers>
+        <VirtualLogin vLogin="user1" vPassword="userpass1"/>
+        <VirtualLogin vLogin="user2" vPassword="userpass2"/>
+      </VirtualUsers>
+    </AuthenticationManager>
+
+    <DatabaseBackend name="backend3" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost/comm?allowMultiQueries=true" 
connectionTestStatement="select 1">
+      <ConnectionManager vLogin="user1" rLogin="root" rPassword="rootpass">
+        <VariablePoolConnectionManager initPoolSize="10" minPoolSize="5" 
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
+      </ConnectionManager>
+      <ConnectionManager vLogin="user2" rLogin="root" rPassword="rootpass">
+        <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.hsqldb.jdbcDriver"
+        url="jdbc:hsqldb:hsql://localhost:9003" login="TEST" password="">
+        <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="VARCHAR NOT NULL"
+          dumpPathColumnType="VARCHAR NOT NULL"
+          dumpFormatColumnType="VARCHAR NOT NULL"
+          checkpointNameColumnType="VARCHAR NOT NULL"
+          backendNameColumnType="VARCHAR NOT NULL"
+          tablesColumnType="VARCHAR NOT NULL"/>
+      </RecoveryLog>
+
+    </RequestManager>
+
+  </VirtualDatabase>
+
+</SEQUOIA>