+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: PostgreSQL Master-Slave (/showthread.php?tid=72774)
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, 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.
RE: PostgreSQL Master-Slave - KoRsar4eg - 02-11-2019
(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
