MySQL - master - slave

If you need to build your query with Query Builder for some reason, just use $this->db->get_compiled_select() (/_insert()/_update()/_delete()) to get the SQL generated by Query Builder, then pass it to $this->db->query() with your comments. For example:

PHP Code:

$this->db->select('something')->from('somewhere');
$sql = $this->db->get_compiled_select();
$this->db->query(sprintf("/*%s*/{$sql}", MYSQLND_MS_MASTER_SWITCH)); 


If that doesn't work for some reason, you can try passing it to simple_query() instead of query().

I will try in this way, thanks