CodeIgniter Forums
PostgreSQL Master-Slave - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: PostgreSQL Master-Slave (/thread-72774.html)



PostgreSQL Master-Slave - KoRsar4eg - 02-09-2019

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!


RE: PostgreSQL Master-Slave - donpwinston - 02-09-2019

(02-09-2019, 11: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.


RE: PostgreSQL Master-Slave - KoRsar4eg - 02-11-2019

(02-09-2019, 04:07 PM)donpwinston Wrote:
(02-09-2019, 11: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