Oracle 5.0, Reference Manual

Page: 2639 / 3232

Mysqlnd replication and load balancing plugin (
mysqlnd_ms
)
2619
update everywhere clusters that have no built-in partitioning. The
filter is a multi filter which returns zero, one or multiple of its input
servers. Thus, it must be followed by other filters to reduce the
number of candidates down to one for statement execution.
Keyword Description Version
user
defined
node
group
name
One or more node groups must be defined. A
node group can have an arbitrary user defined
name. The name is used in combination with
a SQL hint to restrict query execution to the
nodes listed for the node group. To run a
query on any of the servers of a node group,
the query must begin with the SQL hint
/
*user defined node group name*/
.
Please note, no white space is allowed
around
user defined node group name
.
Because
user defined node group
name
is used as-is as part of a SQL hint, you
should choose the name that is compliant with
the SQL language.
Each node group entry must contain a list of
master
servers. Additional
slave
servers are
allowed. Failing to provide a list of
master
for
a node group
name_of_group
may cause
an error of type
E_RECOVERABLE_ERROR
like
(mysqlnd_ms) No masters configured
in node group 'name_of_group' for
'node_groups' filter
.
The list of master and slave servers must
reference corresponding entries in the
global master respectively slave server
list. Referencing an unknown server in
either of the both server lists may cause
an
E_RECOVERABLE_ERROR
error like
(mysqlnd_ms) Unknown master
'server_alias_name' (section
'name_of_group') in 'node_groups'
filter configuration
.
Example 20.283. Manual partitioning
{
"myapp": {
"master": {
"master_0": {
"host": "localhost",
"socket": "\/tmp\/mysql.sock"
}
},
"slave": {
"slave_0": {
"host": "192.168.2.28",
"port": 3306
},
"slave_1": {
"host": "127.0.0.1",
"port": 3311
}
},
Since 1.5.0.