+- 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: Database Connection Master Slave issue (/showthread.php?tid=69125)
Database Connection Master Slave issue - hitender.singh - 10-11-2017
Hi
I am trying to connect 2 database one for read and another for write. I am using following code for 2 connection.
In Contructor
$this->WRITE = $this->load->database('write', TRUE); //-- master
$this->READ = $this->load->database('read', TRUE); //-- slave
But whenever I execute my query the database server My WRITE DB goes to 100% in few 1000 concurrent connection. I check with Processlist command in write db and it shows sleep queries increase, even my query contains read(select query). There is no load in read db but my Write db load goes very high.
We are using RDS database
Please help
regard
Hitender