hi all,
I set up the following Sequoia (2.10.10) architecture:
1 controller, 2 backends (MySQL 5.1) and 1 recovery (MySQL 5.1)
I can start the controller and enable the backends. I can also access the
cluster and perform some queries. Items appeared on the backends. Everything
seems to work fine.
However, I noticed bad performances, especially for insertion queries. A
simple insertion in a virtual database takes about 0.500 s.
Does anybody already notice that kind of measures? I'm looking for a way to
optimize these queries. I tried different appia configurations, but I wasn't
able to find one which correspond to what I expected.
I also noticed some strange logs from the controller:
**********
2008-06-26 11:52:13,169 INFO DatabaseBackend.sequoiaDB.debian112125 Adding
connection manager for virtual user "root"
2008-06-26 11:52:13,169 WARN DatabaseBackend.sequoiaDB.debian112126 Default
connection manager undefined in backend configuration, setting to a
VariablePoolConnectionManager
**********
This is quite amazing since as you can see below I configured a connection
manager...
Here is a part of my virtual database configuration file:
-------------------------------------------------------------------------------------------
<Distribution hederaPropertiesFile="/hedera_appia.properties">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQLBackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options=""/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="myuserame" password="mypassword"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="user"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="debian112125" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:12125/sequoiaDB" connectionTestStatement="select
1">
<ConnectionManager vLogin="user" rLogin="dbuser" rPassword="dbpwd">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="5"
maxPoolSize="50" idleTimeout="30" waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="debian112126" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://127.0.0.1:12126/sequoiaDB" connectionTestStatement="select
1">
<ConnectionManager vLogin="user" rLogin="dbuser" rPassword="dbpwd">
<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>
-------------------------------------------------------------------------------------------
I would be glad if someone could give me an advice to improve the
performances of my cluster. Thanks
gaël charrière
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
