We have a web based application running on tomcat (5.5.9) on an Gentoo (2.6.16)
linux distribution. It uses hibernate (3.0), MySQL database (4.10) and MySQL
J/connector(5.0.4) for database connectivity. Currently we are investigating
Sequoia to provide load balancing and transparent failover features.
We are using collocated controller configuration, a RAIDb-1 configuration with
just one database backend. We have setting to enable the virutal database
during controller startup. We have observed that the controller is extremely
slow to startup - over 10 mins. There are about 144 tables in the database with
no more than about 10 columns in each table. Can you recommend ways to improve
startup performance, as in production usage this is too long to wait for
controller to come up.
Controller.xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER
2.10.2//EN" "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.2.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<Report hideSensitiveData="true" generateOnShutdown="true"
generateOnFatal="true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor port="1090"/>
</JmxSettings>
<VirtualDatabase configFile="tradeideasmonitor-raidb1.xml"
virtualDatabaseName="tradeideasmonitor" autoEnableBackends="true" />
</Controller>
</SEQUOIA-CONTROLLER>
Virtualdatase.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";>
<SEQUOIA>
<VirtualDatabase name="tradeideasmonitor">
<AuthenticationManager>
<Admin>
<User username="admin" password="XXXXX"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="tradeideasm" vPassword="XXXX"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="tradeideasmonitor" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://XXXXX:3306/tradeideasmonitor" connectionTestStatement="SELECT
1">
<ConnectionManager vLogin="tradeideasm" >
<VariablePoolConnectionManager initPoolSize="5" minPoolSize="5"
maxPoolSize="200" idleTimeout="3000" waitTimeout="10000"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-RoundRobin/>
</RAIDb-1>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
Machine specs:
RAM = 4GB in 1GB sticks of 400Mhz DDR2 ECC Registered CL3 RAM.
Processor:
$ cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.806
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm
constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 5609.79
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.806
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm
constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.76
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.806
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm
constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.73
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.806
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm
constant_tsc pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.66
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
