Toni Menendez Lopez wrote:
How many controllers are you using?
>>I am using 2 Back-Ends, which on controller in each-backend.
I did not get that. You have 2 databases on 1 controller?
Which version of MySQL are you using?
>>server version: 4.1.20-log
What components are located where?
>>What do you mean with this ?
Do you have the controller(s) and the databases on different machines?
Is your JBoss server on another machine? What is your network
architecture (how are they interconnected)?
Did you co-locate JBoss and Sequoia?
Which operating system are you using?
>>Redhat Enterprose Linus 4 update 4
Which JVM are you using?
>>java -version
>>java version "1.5.0_10"
>>Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_10-b03)
>>Java HotSpot(TM) Server VM (build 1.5.0_10-b03, mixed mode)
What is your network configuration?
>>Network configuration, I have a private network to connect the 2 BE
between each one, and after we are using jgroups.
If you have a single controller, you should not use group communication
and see big benefits.
If you have 2 controllers (one on each backend), you should try
different JGroups settings. Oftentimes, the TCP stack gives better
results. You can also give it a try with Appia to see if performance
improves.
What does your workload look like (reads vs writes, transactions, ...)?
>>In our case mainly writes !
Well, then you might want to reconsider the choice of Sequoia. Sequoia
will not provide you speedup for writes (just for reads) and will
certainly significantly slowdown your write throughput. If you don't
have strong consistency constraints, you might want to consider using
asynchronous replication instead like MySQL replication.
If you are using a single controller, you might want to set you
WaitForCompletion policy to 'first' in the load balancer settings of
your virtual database configuration file.
Hope this helps,
Emmanuel
Are you using direct JDBC or Hibernate?
>>Hibernate.
These are preliminary questions that should help highlighting
points worth investigating. Tuning requires some analysis of your
system to understand what the potential bottlenecks can be. This
is specific to your system and you might want to look for someone
providing consulting services in your area for an appropriate
answer to your needs
>> First of all I would like to try to do the tinning by ourselves
before contacting any external consulting. I would like to know if
there is any parameter to tune the sequoia.
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet
FTO @ Frog Thinker Open Source Development & Consulting
--
Web: http://www.frogthinker.org <http://www.frogthinker.org/>
email: m...@frogthinker.org <mailto:m...@frogthinker.org>
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
<mailto:Sequoia@lists.forge.continuent.org>
https://forge.continuent.org/mailman/listinfo/sequoia
------------------------------------------------------------------------
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet
FTO @ Frog Thinker
Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: m...@frogthinker.org
Skype: emmanuel_cecchet
_______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia
