Jump to content

Split database connection for read/write

Recommended Posts

@Rudy Did you consider using innoDB tables? Apparently they're better suited for heavy read-write operations (row-level vs. table-level locking). There are a few discussions in the forums with pros and cons of that approach.

  • Like 1

Share this post

Link to post
Share on other sites

@dragan, thanks for replying. We host quite a few PW sites (in the hundreds). They are using AWS Aurora database. I want to take advantage of AWS replicas and being able to separate read and write requests on the database level. 

Yes, we've already using InnoDB for all of our database tables.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...