VV_silent Posted January 3, 2019 Report Posted January 3, 2019 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. Quote
Ian Posted January 4, 2019 Report Posted January 4, 2019 yes. but you need distributed statistics. Quote
andrewatfornax Posted January 15, 2019 Report Posted January 15, 2019 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.... Quote
Recommended Posts
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.