MySQL - master - slave

What about master slave support in one of next versions?

The relation master - slave is MYSQL setup/configuration task, its not work for the framework..

MYSQL 5.5 Replication Docs > http://dev.mysql.com/doc/refman/5.5/en/replication.html

Best VPS Hosting : Digital Ocean

How you can say this?
How will use I in Codeigniter select from slave?

What do you understand under Mysql Master - Slave ?

If its a Replication MYSQL service handles this relation.

If its some kind of duplication with 2 instances you need to specify 2nd DB connection inside your app..

Best VPS Hosting : Digital Ocean

You can install mysqlnd extension and mysqlnd_ms plugin. It will transparently query slave(s) when needed so no code change is required in your app or CI.

More info here: http://php.net/manual/en/book.mysqlnd-ms.php

What about that?

You can install mysqlnd extension and mysqlnd_ms plugin. It will transparently query slave(s) when needed so no code change is required in your app or CI.

More info here: http://php.net/manual/en/book.mysqlnd-ms.php

yes I know that but in CI active record there is no option to add comments in query? Is there any option for this?

What do you understand under Mysql Master - Slave ?

If its a Replication MYSQL service handles this relation.

If its some kind of duplication with 2 instances you need to specify 2nd DB connection inside your app..

you just do not get it

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().

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide

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