Split database connection for read/write

[Rudy]

@ryan, would you consider adding the ability for PW to split database connections for read and write? I think it will be really useful, especially for high-traffic sites.

Something like this (https://laravel.com/docs/master/database#using-multiple-database-connections) or WordPress HyperDB (https://wordpress.org/plugins/hyperdb/)

Thanks
Rudy

 

[dragan]

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

[Rudy]

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

[arjen]

I don't think Ryan will read this. You would have more luck if you create a request on Github.

[Rudy]

@arjen thanks, will do.

[Karinne Cyphers]

+1 This would be something we could really use as well!