polardb / polardbx-sql

PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
Apache License 2.0
1.54k stars 325 forks source link

安装步骤疑问 #13

Closed Hoxxx closed 3 years ago

Hoxxx commented 3 years ago

源码安装参考文档中

启动PolarDB-X DN
此步骤启动一个mysql进程,作为metadb和dn
参考附录中的mysql配置文件,可进行相应修改,默认使用 4886 作为 mysql端口,32886 作为私有协议端口
默认使用 /u01/my3306 作为mysql数据目录,可以修改成其他目录
注意:启动 DN 需要使用非 root 账号完成

启动mysql:

mkdir -p /u01/my3306/{data,log,run,tmp,mysql}
/u01/mysql/bin/mysqld --defaults-file=my.cnf --initialize-insecure
/u01/mysql/bin/mysqld --defaults-file=my.cnf

这里的mysql是需要单独装一个mysql server端?还是客户端?还是需要软链接到对应目录下?

agapple commented 3 years ago

需要启动MySQL server,PolarDB-X的DN和GMS在开发环境可以复用一个MySQL进程

Hoxxx commented 3 years ago

@agapple mysql server版本有限制吗?用MariaDB 10.3.9启动DN失败

[Warning] /usr/libexec/mysqld: unknown variable 'loose_polarx_port=32886'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_galaxyx_port=32886'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_polarx_max_connections=5000'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_cluster-info=127.0.0.1:14886@1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_cluster-id=5431'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_enable_gts=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_innodb_undo_retention=1800'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_log_sql_info=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_log_sql_info_index=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_indexstat=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_tablestat=1'
[ERROR] /usr/libexec/mysqld: unknown variable 'slave_parallel_type=LOGICAL_CLOCK'
[ERROR] Aborting
Oldbread3 commented 3 years ago

@agapple mysql server版本有限制吗?用MariaDB 10.3.9启动DN失败

[Warning] /usr/libexec/mysqld: unknown variable 'loose_polarx_port=32886'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_galaxyx_port=32886'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_polarx_max_connections=5000'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_cluster-info=127.0.0.1:14886@1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_cluster-id=5431'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_enable_gts=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_innodb_undo_retention=1800'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_log_sql_info=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_log_sql_info_index=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_indexstat=1'
[Warning] /usr/libexec/mysqld: unknown variable 'loose_tablestat=1'
[ERROR] /usr/libexec/mysqld: unknown variable 'slave_parallel_type=LOGICAL_CLOCK'
[ERROR] Aborting

CN 与 DN 通过 GalaxyGlue 模块通信,仅支持 https://github.com/ApsaraDB/galaxyengine 作为 DN 和 GMS