用sandbox 搭建InnoDB Cluster环境时遇到如下问题:
mysql-js> dba.deploySandboxInstance(3310)
A new MySQL sandbox instance will be created on this host in
/root/mysql-sandboxes/3310
Warning: Sandbox instances are only suitable for deploying and
running on your local machine for testing purposes and are not
accessible from external networks.
Please enter a MySQL root password for the new instance:
Deploying new MySQL instance...
Dba.deploySandboxInstance: (RuntimeError)
通过dba.help('deploySandboxInstance')看到RuntimeError的解释,但还是不知道该怎么处理
mysql-js> dba.help('deploySandboxInstance')
EXCEPTIONS
RuntimeError: f SSL support can be provided and ignoreSslError: false.
DESCRIPTION
- ignoreSslError: Ignore errors when adding SSL support for the new instance, by default: true.
检查mysqlshell的日志:
tail -f $/HOME/.mysqlsh/mysqlsh.log
ImportError: can't decompress data; zlib not available
发现python2.7 环境中缺少zlib,ssl
安装相关依赖:yum -y install zlib*,openssl
重新编译python后,重试,正常。
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-sandbox-deployment.html