Hi Randall,
You were right regarding the connection type. I put the client on
one of the DB nodes and connecting to the DB on the same box as the client,
the 1,000 inserts took 22 seconds. When I connect to the DB on the 'other'
machine, the 1,000 inserts take about 1 second (same as on the non-DB
machine I was testing on). To me that proves that pipes are playing role.
For some reason, local communications are extremely slow on your
machine. This is the root cause of the problem.
However, Sequoia is still slow.
Yes, this is normal because Sequoia uses group communication to
multicast messages. Each group message is delivered to the remote
controller but it is also delivered locally going through a local
socket. So if your local communications are slow, you are going to pay a
big penalty for local delivery of group messages.
What I did was instead of an A->A, B->B configuration I setup A->B,
B->A setup, basically each controller works with the other machines'
database. While I was hoping this would resolve the pipe issue, and maybe
it did, the performance is still the same, about 125 seconds.
Yes, that confirms what I thought. There is an issue in your Windows
config for local communications. Even though you improved
controller->MySQL configuration with this cross-over, the group
communication still has to go through the local communication channel
for local delivery (this is how JGroups implements it).
I am not a specialist of the Windows networking stack, so I guess now
you'll have to Google for similar network performance issues. You could
also try to post on the JGroups mailing list to see if someone already
hit that problem.
Keep us posted with your progress,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
