mysqlnd_ms_dump_servers
(Информация о версии неизвестна, возможно, только в SVN)
mysqlnd_ms_dump_servers — Returns a list of currently configured servers
Описание
Returns a list of currently configured servers.
Список параметров
Возвращаемые значения
FALSE
on error. Otherwise, returns an array with two entries
masters and slaves each of which contains
an array listing all corresponding servers.
The function can be used to check and debug the list of servers currently used by the plugin. It is mostly useful when the list of servers changes at runtime, for example, when using MySQL Fabric.
masters and slaves server entries
Key | Description | Version |
---|---|---|
name_from_config |
Server entry name from config, if appliciable. NULL if no configuration name is available. |
Since 1.6.0. |
hostname |
Host name of the server. |
Since 1.6.0. |
user |
Database user used to authenticate against the server. |
Since 1.6.0. |
port |
TCP/IP port of the server. |
Since 1.6.0. |
socket |
Unix domain socket of the server. |
Since 1.6.0. |
Примечания
Замечание:
mysqlnd_ms_dump_servers() requires PECL mysqlnd_ms >> 1.6.0.
Примеры
Пример #1 mysqlnd_ms_dump_servers() example
{ "myapp": { "master": { "master1": { "host":"master1_host", "port":"master1_port", "socket":"master1_socket", "db":"master1_db", "user":"master1_user", "password":"master1_pw" } }, "slave": { "slave_0": { "host":"slave0_host", "port":"slave0_port", "socket":"slave0_socket", "db":"slave0_db", "user":"slave0_user", "password":"slave0_pw" }, "slave_1": { "host":"slave1_host" } } } }
<?php
$link = mysqli_connect("myapp", "global_user", "global_pass", "global_db", 1234, "global_socket");
var_dump(mysqlnd_ms_dump_servers($link);
?>
Результат выполнения данного примера:
array(2) { ["masters"]=> array(1) { [0]=> array(5) { ["name_from_config"]=> string(7) "master1" ["hostname"]=> string(12) "master1_host" ["user"]=> string(12) "master1_user" ["port"]=> int(3306) ["socket"]=> string(14) "master1_socket" } } ["slaves"]=> array(2) { [0]=> array(5) { ["name_from_config"]=> string(7) "slave_0" ["hostname"]=> string(11) "slave0_host" ["user"]=> string(11) "slave0_user" ["port"]=> int(3306) ["socket"]=> string(13) "slave0_socket" } [1]=> array(5) { ["name_from_config"]=> string(7) "slave_1" ["hostname"]=> string(11) "slave1_host" ["user"]=> string(12) "gloabal_user" ["port"]=> int(1234) ["socket"]=> string(13) "global_socket" } } }
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- MySQL Drivers and Plugins
- Mysqlnd replication and load balancing plugin
- mysqlnd_ms_dump_servers
- mysqlnd_ms_fabric_select_global
- mysqlnd_ms_fabric_select_shard
- mysqlnd_ms_get_last_gtid
- mysqlnd_ms_get_last_used_connection
- mysqlnd_ms_get_stats
- mysqlnd_ms_match_wild
- mysqlnd_ms_query_is_select
- mysqlnd_ms_set_qos
- mysqlnd_ms_set_user_pick_server
- mysqlnd_ms_xa_begin
- mysqlnd_ms_xa_commit
- mysqlnd_ms_xa_gc
- mysqlnd_ms_xa_rollback
Коментарии
Shouldn't it be:
var_dump(mysqlnd_ms_dump_servers($link));
?