Jump to content

Recommended Posts

Hello. 

Is it possible to configure revive ad to use mysql slave for reading for example ? 

Currently I have around 14k ops on my db server and I'm searching  for load balancing solution. 

Share this post


Link to post
Share on other sites

A possibly more nuanced answer:

  1. No - you cannot use MySQL Slaves for read-only DB access with Revive Adserver - there is no support in the application to direct reads to slave databases, and writes to a master database.
  2. We do not recommend the use of distributed statistics any more - it's effectively unsupported.
  3. 14k ops (presumably database operations?) is not necessarily a large number - depends on the timescale. I have seen Revive Adserver running on a single MySQL and perform 2.5k ops per second. It really depends on what bottleneck you are seeing - and what other optimizations you have attempted re: performance.

Maybe it's time to write a performance optimization guide....

 

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