|
Hi, I spent most of the day getting sequoia setup and
configured, and now I’m not even sure if it does what I need it to.
I have two different databases that I need to combine into one source for some
reporting. The reports have to match rows from the two sources, having
them in one central location would be so much easier to work with. I created a virtual database with 2 backends, one for each
different data source. They both go in and are enabled, but when I run
show tables; , I only see tables from the first database backend. Is that
what is supposed to happen or is it a misconfiguration? I need it to show
me all of the tables from both databases. So my basic question is, can
sequoia combine different databases like this or is it only for clustering
databases that are identical? Here’s the controller output and some stuff I ran from
the console, as far as I can tell everything is setup correctly. If I
switch the order of the database backends, I get the tables from the first
backend in the virtualdb.xml file. I see the merged word down there, to
me merged would mean it has both tables? Thanks a lot, John 15:23:08,815 INFO controller.core.Controller
Sequoia controller (2.10) 15:23:09,080 INFO controller.core.Controller
Loading configuration file: /D:/sequoia/config/controller/controller.xml 15:23:09,533 INFO controller.core.Controller
JMX is enabled 15:23:09,690 INFO controller.core.Controller
Starting JMX server on host: ***.***.***.*** 15:23:11,377 INFO
backend.DatabaseBackend.pyxis Adding connection manager for virtual user
"*****" 15:23:11,408 INFO
backend.DatabaseBackend.pathways Adding connection manager for virtual user
"**" 15:23:11,705 INFO
controller.RequestManager.pharmaData Request manager will parse requests with
the following granularity: TABLE 15:23:11,752 WARN
controller.virtualdatabase.pharmaData No recovery log has been configured,
enabling backend without checkpoint. 15:23:12,815 INFO
backend.DatabaseBackend.pyxis Detected backend as: Microsoft SQL Server 15:23:18,955 INFO
controller.RequestManager.pharmaData Setting new virtual database schema. 15:23:19,065 INFO
controller.RequestManager.pharmaData Database backend pyxis is now enabled 15:23:19,268 INFO backend.DatabaseBackend.pathways
Detected backend as: Microsoft SQL Server 15:23:22,377 INFO
controller.RequestManager.pharmaData Virtual database schema merged
with new schema. 15:23:22,393 INFO controller.RequestManager.pharmaData
Database backend pathways is now enabled 15:23:22,424 INFO controller.core.Controller
Adding VirtualDatabase pharmaData 15:23:22,455 INFO controller.core.Controller
Waiting for connections on 0.0.0.0:25322 15:23:22,502 INFO controller.core.Controller
Controller started on 2006.09.26 39 at 03:23:22 PM EDT 15:23:22,502 INFO controller.core.Controller
Controller ***.***.***.***:25322 ready, listening to requests ... pharmaData(admin) > show backend * +--------------------------+------------------------------------------------------------------------+ | Backend
Name |
pyxis
| |
Driver
| net.sourceforge.jtds.jdbc.Driver
| |
URL
| jdbc:jtds:sqlserver://****/pyxis_central;SelectMethod=Cursor | | Active transactions
|
0
| | Pending Requests
|
0
| | Read
Enabled
|
true
| | Write
Enabled |
true
| | Is
Initialized |
true
| | Static
Schema |
false
| | Connection Managers
|
1
| | Total Active Connections |
5
| | Persistent Connections |
0
| | Total
Requests |
0
| | Total
Transactions |
0
| | Last known checkpoint |
<unknown>
| +--------------------------+------------------------------------------------------------------------+ | Backend
Name |
pathways
| |
Driver
|
net.sourceforge.jtds.jdbc.Driver
| |
URL
|
jdbc:jtds:sqlserver://****/pathways;SelectMethod=Cursor
| | Active transactions
|
0
| | Pending
Requests |
0
| | Read
Enabled
|
true
| | Write
Enabled |
true
| | Is
Initialized |
true
| | Static
Schema | false
| | Connection Managers
|
1
| | Total Active Connections |
5
| | Persistent Connections |
0
| | Total
Requests |
0
| | Total
Transactions |
0
| | Last known checkpoint |
<unknown>
| +--------------------------+------------------------------------------------------------------------+ pharmaData(admin) > show virtualdatabase config <?xml version="1.0"
encoding="UTF-8"?> <!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD
SEQUOIA 2.10//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.dtd"> <SEQUOIA> <VirtualDatabase
name="pharmaData" maxNbOfConnections="0"
poolThreads="true" minNbOfThreads="0"
maxNbOfThreads="0" maxThreadIdleTime="60"
sqlDumpLength="40"> <Monitoring>
<SQLMonitoring defaultMonitoring="on"/> </Monitoring> <Backup/>
<AuthenticationManager>
<Admin>
<User username="*****" password="****"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="****" vPassword="****"/>
</VirtualUsers> </AuthenticationManager> <DatabaseBackend
name="pyxis" driver="net.sourceforge.jtds.jdbc.Driver"
url=""
connection TestStatement="select 1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="false"/>
<ConnectionManager vLogin="***" rLogin="***"
rPassword="****">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5" maxPoolSize="50" idleTimeout="30"
waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend> <DatabaseBackend
name="pathways" driver="net.sourceforge.jtds.jdbc.Driver"
url=""
connectionTe stStatement="select 1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="false"/>
<ConnectionManager vLogin="*****" rLogin="***"
rPassword="****">
<VariablePoolConnectionManager initPoolSize="10"
minPoolSize="5" maxPoolSize="50" idleTimeout="30"
waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend> <RequestManager
caseSensitiveParsing="false" beginTimeout="60"
commitTimeout="60" rollbackTimeout="60">
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<RequestCache>
<MetadataCache maxNbOfMetadata="10000"
maxNbOfField="0"/>
<ParsingCache backgroundParsing="false"
maxNbOfEntries="5000"/>
</RequestCache>
<LoadBalancer transactionIsolation="databaseDefault">
<RAIDb-1>
<WaitForCompletion policy="first"
enforceTableLocking="false"
deadlockTimeoutInMs="30000"/>
<MacroHandling rand="float" now="timestamp"
currentDate="date" currentTime="time"
currentTimestamp="timestamp" timeOfDay="timestamp"
timeResolution="1 000"/>
<RAIDb-1-LeastPendingRequestsFirst/>
</RAIDb-1>
</LoadBalancer>
</RequestManager> </VirtualDatabase> </SEQUOIA> pharmaData(admin) > |
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
