Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question
0

Tuning in Mirror service

Hi all,

After I added mirror serivce into my application, the throughput is dropped around 40% compared without mirror, I wonder there should be some tuning on the mirror service. My topology is 9 partition with 1 backup each.

As I have discovered these tunings in the forum (I guess there should be more), <bulk-size>100</bulk-size> <interval-millis>2000</interval-millis> <interval-opers>100</interval-opers> In fact, I hope someone could explain what these tunings are. (and right now, i include these tunings in the Application PU's pu.properties file)

I would like to ask any optimal tunings on the mirror service? The database I am using is MySQL 5.1, does anyone can advice on the DB side too?

Edited by: HW Chan on Apr 9, 2009 7:41 AM

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=3006]{quote}

asked 2009-04-09 04:38:13 -0600

hwchan gravatar image

updated 2013-08-08 09:52:00 -0600

jaissefsfex gravatar image
edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

Few questions/suggestions:
- What is the total TP of space operations you have within the spaces?
- Can you break the cluster into several clusters each having its owen mirror?
- Can you run the mirror on the database machine?
- Can you configure the mirror hibernate / database setup to run in batch mode?
- Have you tried to optimize the mirror replication settings (the ones you mentioned) ? The defaults are for sure not relevant for all cases.
- There are several good Mysql tuning papers on the web. Try to google for such (check out sun Mysql website).
- How many fields you have for the space classes? Have as min as you can have and place all the non indexed ones into a payload class field (which should implement Externalizable). This will speed up the replication.

Shay

answered 2009-04-09 12:39:03 -0600

shay hassidim gravatar image
edit flag offensive delete link more

Comments

For mySQL tuning you might want to take a look on these: http://video.google.com/videoplay?doc...http://jpipes.com/presentations/perf_...

Shay

shay hassidim gravatar imageshay hassidim ( 2009-04-11 06:22:28 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2009-04-09 04:38:13 -0600

Seen: 41 times

Last updated: Apr 09 '09