Yes, we use Sequoia to scale our reads and to create an active-active
cluster environment. I think that the balancing is the point of this
fast results.
Some questions:
- Which jdk do u use?
- 32 Bit or 64 Bit 2003 Server?
- Did you configure your mysql correctly? Maybe you can tune the
backends (we tuned postgres a lot)
- Are u using special options for the jvm?
...
sounded very very slow :(
so far,
chris
Randall Fidler schrieb:
Interesting...
Are you using Sequoia to scale your DB reads? Is that how you're getting
the improvement of 170 vs 130?
As I said, it's VERY slow when I try to do 1000 inserts, taking over 2
minutes but going directly to the DB takes less than a second.
Just for giggles, here's the hardware:
Controller and DB running on:
Dual Xeon
2GB RAM
833Mhz FSB (might only be 800, who knows!?)
Windows 2003 Server
I'm hoping it's something stupid I did with the config file but thus far I
don't see it. I used the examples that were provided for raidb1
configuration.
Thanks,
Randall
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Christopher
Hartung
Sent: Wednesday, May 02, 2007 6:51 AM
To: [email protected]
Subject: Re: [Sequoia] Performance
We used to test our environment with JDBCBench. Directly to our DB-Node we
get results like ~130 tps. With sequoia we get more than ~170 tps.
our environment:
Controller: 2x IBM x346 | 64 Bit Java Sun-JDK | 4 GB Ram
DB-Node: 2x IBM x445 | 32 - Bit Postgres | 32 GB Ram (don't ask why ;) )
BS: CentOS 4 / 5
special jvm options:
-server -d64 -Xms3G -Xmx3G -Xincgc -XX:+UseLargePages
And other special Kernel parameter (for example shmmax etc.)
This environment isn't productive yet, but it's still fast ;)
Randall Fidler schrieb:
Hello,
I setup Sequoia 2.10 with MySQL 4.1 and have found that if I try
to do 1k inserts that it takes approx 130 seconds with Sequoia and
less than 1 second going directly to the DB with native MySQL driver.
I'm using the same driver for the direct test as I've provided to
Sequoia so there's no difference there and also, Sequoia is setup in a
mirror configuration.
Any suggestions? I really would like to utilize Sequoia but at the
speeds I'm seeing it's not practical.
Best regards,
Randall
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
