CodeIgniter Forums
Master Slave Databases - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Master Slave Databases (/showthread.php?tid=26719)



Master Slave Databases - El Forum - 01-21-2010

[eluser]Unknown[/eluser]
I have done extensive research regarding below with no luck:
How do you make CI database session write to master mysql server and read from multiple slave mysql servers?
Now the question boils down to:
How to extend CI database class write to master mysql server and read from multiple slave mysql servers without having to define each databases as $DB1 and $DB2?

I use Doctrine ORM that can be easily extended to use master and slave servers. If CI database can be used with Doctrine ORM, that's even better.

Any solution/suggestions would be greatly appreciated!


Master Slave Databases - El Forum - 01-21-2010

[eluser]danmontgomery[/eluser]
http://www.phpandstuff.com/articles/codeigniter-doctrine-from-scratch-day-1-install-and-setup