Jump to content

Partitioning the Database

Recommended Posts

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.

Link to comment
Share on other sites

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.

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

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