Ionel Roiban Posted May 5, 2017 Report Share Posted May 5, 2017 These days MySQL (or MariaDB, or Aurora at AWS) support clustering. Therefore we have multiple databases in sync and we can leverage on this capacity to improve the adserver performance. Obviously, we can write to Master, and read from Slave nodes. Is there a way to accomplish this with the current Revive code base? Has anyone figured out a solution? What would it take to bring this feature into the core. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted May 8, 2017 Report Share Posted May 8, 2017 Hi @Ionel Roiban, Master/slave doesn't really help Revive Adserver, because the admin UI needs to read and write (to update campaigns, banners, etc.), while the delivery system also needs to ready and write (to find out what to deliver, and to then log the statistics). So, pretty much all of Revive Adserver needs to talk to the master node. Master/slave really only helps if you have failover with slave to master promotion configured, for HA. If you need to distribute load for the database, then master/master replication is what's needed, unfortunately. Quote Link to comment Share on other sites More sharing options...
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.