mysqlnd_ms错误-getaddrinfo失败,mysqlnd_global_stats处于未知状态


mysqlnd_ms error - getaddrinfo failed, mysqlnd_global_stats in Unknown

我正在尝试设置mysqlnd_ms,以便它实现在从数据库上读取和在主数据库上写入的目的。但是,当httpd重新启动时,我会收到这个错误。

PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/mysqlnd_ms.so' - /usr/lib64/php/modules/mysqlnd_ms.so: undefined symbol: mysqlnd_global_stats in Unknown on line 0

我正在运行一个AmazonEC2x64 AMI实例,并在一个新实例上运行了以下命令:

sudo yum update
sudo yum install -y gcc make gcc-c++
sudo yum install -y httpd24 php54
sudo yum install -y php54-devel php54-mysqlnd php54-mbstring
sudo pecl install mysqlnd_ms
php -m | grep mysql

我的php.ini包含以下添加:

mysqlnd_ms.enable=1
mysqlnd_ms.force_config_usage=1
mysqlnd_ms.config_file=/etc/mysqlnd_ms.ini
extension=mysqlnd_ms.so

mysqlnd_ms.ini文件包含以下内容:

{    
"appname": {
    "master": {
        "master_0": {
            "host": "1.2.3.4",
            "db": "dbname",
            "user": "dbuser",
            "password": "dbpswd",
            "socket" : "'/var'/lib'/mysql'/mysql.sock"
        }
    },
    "slave": {
        "slave_0": {
            "host": "12.22.32.42",
            "db": "dbname",
            "user": "dbuser",
            "password": "dbpswd",
            "socket" : "'/var'/lib'/mysql'/mysql.sock"
        }
       }
}
}

要连接,我需要:

$mysqli = new mysqli("appname", "dbuser", "dbpswd", "schema");

执行以上操作会引发以下错误:

ERROR: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

Mysqli、mysql和pdo都在服务器上启用。

如果我们直接将其更改为主机名,它会起作用:

$mysqli = new mysqli("1.2.3.4", "dbuser", "dbpswd", "schema");

如何使mysqlnd_ms正常工作?

问题解决了

要解决此问题:

  1. 拆除线路:

mysqlnd_ms.enable=1

mysqlnd_ms.force_config_usage=1

mysqlnd_ms.config_file=/etc/mysqlnd_ms_cfg.ini

extension=mysqlnd_ms.so

从php.ini文件

  1. 创建一个名为"/etc/php.d/mysqlnd_ms.ini"的新文件,并将这些行放在中

  2. 重新加载httpd