CodeIgniter Forums

Full Version: PostgreSQL Master-Slave
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi guys, does anybody knows how to extend CI postgre driver to implement support of master-slave replication by standard query-builder class ? Is somewhere any tutorials or best practices which can cover this topic? thanks!
(02-09-2019, 10:56 AM)KoRsar4eg Wrote: [ -> ]Hi guys, does anybody knows how to extend CI postgre driver to implement support of master-slave replication by standard query-builder class ? Is somewhere any tutorials or best practices which can cover this topic? thanks!

I believe you set this up in the db, not in your application.
(02-09-2019, 03:07 PM)donpwinston Wrote: [ -> ]
(02-09-2019, 10:56 AM)KoRsar4eg Wrote: [ -> ]Hi guys, does anybody knows how to extend CI postgre driver to implement support of master-slave replication by standard query-builder class ? Is somewhere any tutorials or best practices which can cover this topic? thanks!

I believe you set this up in the db, not in your application.

I mean, for instance I have 3-4 slave servers and i want to load balance read queries between them, or implement algorithm for loop through slaves if one or couple are not available Smile