Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Codeigniter Multi Tenant Takes long time in loading tenant database

March 17, 2014 7:19am

Subscribe [1]

#1 / Mar 17, 2014 7:19am
[email protected]
1 posts
I am developing a multi tenant app in CodeIgniter, where every tenant has its own db. At run time I find the tenant name and then load its db info from my master database. In My_Model a function establishes connection with slave database
```
function getDbConFig() {
    $dsn = 'mysql://'.$this->dbs_user.':'.$this->dbs_pwd.'@'.$this->dbs_dbhost.'/'.$this->dbs_dbnam;
    if(!empty($this->dbs_user) && !empty($this->dbs_dbhost) && !empty($this->dbs_dbnam)){
        $this->db_slave = $this->load->database($dsn, TRUE);
    }
}
```
Every thing is working fine, but problem is it take very long time in establishing slave database connect.

Any help will be appreciated.