Hello Everyone,
we use Sequoia as a SingelDB-Configuration JDBC-Proxy.
I have two questions:
- Our DB in the Backend will be shutdown for 2 hours everyday for
maintenance. Is there a way to reconnect the DB to the contoller
automaticly? Is the shutdown of DB a problem for the one controller
(singelDB-config)?
- Attached You will find the VDB-Config file. Our controller needs over
30 min to start. Is there a way to increase the startup speed?
Thanx for any help.
Greetings
Sebastian Zickau
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.3//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.3.dtd";>
<SEQUOIA>
<VirtualDatabase name="loga_vDB" maxNbOfConnections="100" poolThreads="true" minNbOfThreads="0" maxNbOfThreads="100" maxThreadIdleTime="60" sqlDumpLength="40">
<AuthenticationManager>
<Admin>
<User username="aduser" password="adsecret"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="apuser" vPassword="secretcon"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="logaNode" driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@kruemel.zuv.tu-berlin.de:1521:tloga" connectionTestStatement="SELECT * FROM dual">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="false"/>
<ConnectionManager vLogin="apuser" rLogin="tubis" rPassword="xyz">
<SimpleConnectionManager/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager caseSensitiveParsing="false" beginTimeout="60" commitTimeout="60" rollbackTimeout="60">
<RequestScheduler>
<SingleDBScheduler level="pessimisticTransaction"/>
</RequestScheduler>
<RequestCache>
<MetadataCache maxNbOfMetadata="1000" maxNbOfField="100"/>
<ParsingCache backgroundParsing="false" maxNbOfEntries="500"/>
</RequestCache>
<LoadBalancer transactionIsolation="databaseDefault">
<SingleDB/>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
