VV_silent 0 Report post Posted January 3 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
Ian vM 55 Report post Posted January 4 yes. but you need distributed statistics. Share this post Link to post Share on other sites
andrewatfornax 78 Report post Posted Tuesday at 06:17 AM A possibly more nuanced answer: 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. We do not recommend the use of distributed statistics any more - it's effectively unsupported. 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
