Jump to content
bishi3000

How To Set Up Distributed Statistics

Recommended Posts

Hi,

 

I've been testing out Revive and I'm finding that I need to be able to scale my cluster horizontally as my traffic grows. I came across a few old OpenX blogs which mentioned configuring OpenX for 'Distributed Statistics'.

 

Is this possible with Revive ?

 

And can anyone point me in the direction of any docs which show how to set it up ?

 

Thanks

 

Keith 

Share this post


Link to post
Share on other sites

Yes, it should still be possible. However, hardware has moved on a lot since then, and I'm honestly not sure that this is the best way to do it. You would need to have a really, really, really massive installation to actually need this.

 

Better would be to scale out your solution with multiple delivery servers, but stick with a single database.

Share this post


Link to post
Share on other sites

Yes, it should still be possible. However, hardware has moved on a lot since then, and I'm honestly not sure that this is the best way to do it. You would need to have a really, really, really massive installation to actually need this.

 

Better would be to scale out your solution with multiple delivery servers, but stick with a single database.

Andrew, can you define massive installation?
 
I need to move from MySQL Cluster to a normal InnoDB implementation. Currently we have around 20M impressions day, running on 6 large webservers(32core/90GB ram, SSHD) and 4 nodes MySQL cluster(32cores/96GB), where data nodes use raid 10 on SAS disks. Obviously, it is too much power for 20M.
 
To keep delivery smooth I am thinking about 1 or 2 Web and 1 DB server, just not sure about whether use or not distributed statistics, also MariaDB is in the board.
 
Currently delivery DB stats are:  1.2K inserts/sec, 200 select/sec
 
Can you guys give me your thoughts about distributed stats and MariaDB?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...