![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461962626.webp)
Mysqlnd replication and load balancing plugin (
mysqlnd_ms
)
2606
"port": "db_server_port",
"socket": "db_server_socket"
}
}
}
}
If a setting is omitted, the plugin will use the value provided by the user API call used to open a
connection. Please, see the
using section names example [2604]
above.
The configuration file format has been changed in version 1.1.0-beta to allow for chained filters. Filters
are responsible for filtering the configured list of servers to identify a server for execution of a given
statement. Filters are configured with the
filter
keyword. Filters are executed by mysqlnd_ms
in the order of their appearance. Defining filters is optional. A configuration section in the plugins
configuration file does not need to have a
filters
entry.
Filters replace the
pick[]
setting from prior versions. The new
random
and
roundrobin
provide the
same functionality.
Example 20.269. New
roundrobin
filter, old functionality
{
"myapp": {
"master": {
"master_0": {
"host": "localhost"
}
},
"slave": {
"slave_0": {
"host": "192.168.78.136",
"port": "3306"
},
"slave_1": {
"host": "192.168.78.137",
"port": "3306"
}
},
"filters": {
"roundrobin": [
]
}
}
}
The function
mysqlnd_ms_set_user_pick_server
has been removed. Setting a callback
is now done with the
user
filter. Some filters accept parameters. The
user
filter requires and
accepts a mandatory
callback
parameter to set the callback previously set through the function
mysqlnd_ms_set_user_pick_server
.
Example 20.270. The
user
filter replaces
mysqlnd_ms_set_user_pick_server
"filters": {
"user": {
"callback": "pick_server"
}
}
The validity of the configuration file is checked both when reading the configuration file and later when
establishing a connection. The configuration file is read during PHP request startup. At this early stage
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...