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>
_______________________________________________
Carob-commits mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob-commits
