Database Connection Master Slave issue |
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 |
Welcome Guest, Not a member yet? Register Sign In |