|
Oups, I forgot to also tell that when all my client processes are
stopped, active transactions remain on each backend: +--------------------------+-------------------------------------------------------------------------------------------+ | Backend Name | sd01 | | Driver | com.mysql.jdbc.Driver | | URL | jdbc:mysql://192.168.22.192/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true | | Active transactions | 4 | | Pending Requests | 0 | | Read Enabled | true | | Write Enabled | true | | Is Initialized | true | | Static Schema | false | | Connection Managers | 1 | | Total Active Connections | 14 | | Persistent Connections | 0 | | Total Requests | 6248 | | Total Transactions | 586 | | Last known checkpoint | <unknown> | +--------------------------+-------------------------------------------------------------------------------------------+ | Backend Name | sd02 | | Driver | com.mysql.jdbc.Driver | | URL | jdbc:mysql://192.168.22.193/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true | | Active transactions | 1 | | Pending Requests | 0 | | Read Enabled | true | | Write Enabled | true | | Is Initialized | true | | Static Schema | false | | Connection Managers | 1 | | Total Active Connections | 11 | | Persistent Connections | 0 | | Total Requests | 6247 | | Total Transactions | 586 | | Last known checkpoint | <unknown> | +--------------------------+-------------------------------------------------------------------------------------------+ Gérard BUNEL a écrit : Hello, I'm currently doing load testing on an application based on: sequoia 2.10.6, MySQL 5.0.37, RedHat 4ES, JDK 1.5.0_11Just for this test I have set up the configuration with one controller holding 2 backends. When launched, it seems that one of the backend supports the majority of the transactions and the other seems ok as shown below: +--------------------------+-------------------------------------------------------------------------------------------+ | Backend Name | sd01 | | Driver | com.mysql.jdbc.Driver | | URL | jdbc:mysql://192.168.22.192/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true | | Active transactions | 101 | | Pending Requests | 4 | | Read Enabled | true | | Write Enabled | true | | Is Initialized | true | | Static Schema | false | | Connection Managers | 1 | | Total Active Connections | 101 | | Persistent Connections | 0 | | Total Requests | 2135 | | Total Transactions | 154 | | Last known checkpoint | <unknown> | +--------------------------+-------------------------------------------------------------------------------------------+ | Backend Name | sd02 | | Driver | com.mysql.jdbc.Driver | | URL | jdbc:mysql://192.168.22.193/matisse?zeroDateTimeBehavior=convertToNull&autoReconnect=true | | Active transactions | 0 | | Pending Requests | 0 | | Read Enabled | true | | Write Enabled | true | | Is Initialized | true | | Static Schema | false | | Connection Managers | 1 | | Total Active Connections | 10 | | Persistent Connections | 0 | | Total Requests | 2134 | | Total Transactions | 154 | | Last known checkpoint | <unknown> | +--------------------------+-------------------------------------------------------------------------------------------+ At a time the first backend is disabled and many transactions are aborted. If I do the same test with only one backend enabled, everything works fine. I've done the same test with sequoia 2.10.9 and encountered the same problem. Bug in controller ? I really need an answer on this problem, please, help !!! Gérard -- *Gérard BUNEL *Chef de Projet ____________________________________________________________________ Technopôle Brest Iroise Site du Vernis – CS 23866 29238 Brest Cedex 3 Tél : + 33 2 98 05 43 21 Fax : + 33 2 98 05 20 34 www.altran.com <http://www.altran.com> --
Gérard
BUNEL |
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
