Jump to content

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 

Link to comment
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.

Link to comment
Share on other sites

  • 8 months later...

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?
Link to comment
Share on other sites

  • 11 months later...

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...