欢送来到 GreatSQL社区分享的MySQL技术文章，如有疑难或想学习的内容，能够在下方评论区留言，看到后会进行解答
- GreatSQL社区原创内容未经受权不得随便应用，转载请分割小编并注明起源。
本次介绍如何利用Docker来将GreatSQL源码编译成二进制文件，以及制作二进制包、RPM包等。
本文介绍的运行环境是CentOS 7.9：
[root@greatsql ~]# cat /etc/redhat-releaseCentOS Linux release 7.9.2009 (Core)[root@greatsql ~]# uname -aLinux greatsql 3.10.0-1160.11.1.el7.x86_64 #1 SMP Fri Dec 18 16:34:56 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux1、筹备工作
1.1、配置yum源
开始编译之前，倡议先配置好yum源，不便装置一些工具。
以阿里、腾讯两大云主机为例，能够这样配置（两个yum源自行二选一）：
[root@greatsql ~]# mv /etc/yum.repos.d/CentOS-Base.repo{,.orig}#阿里云[root@greatsql ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo#腾讯云[root@greatsql ~]# wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.cloud.tencent.com/repo/centos7_base.repo#替换完后，更新缓存[root@greatsql ~]# yum clean all[root@greatsql ~]# yum makecache1.2、装置docker
[root@greatsql]# yum install -y docker[root@greatsql]# systemctl start docker1.3、提前下载几个必要的安装包
别离下载几个编译过程中须要的依赖包：
boost, https://boostorg.jfrog.io/artifactory/main/release/1.73.0/source/boost_1_73_0.tar.gzgit, https://github.com/git/git/archive/v2.27.0.tar.gz, 下载后重命名为 git-v2.27.0.tar.gzpatchelf, https://github.com/NixOS/patchelf/archive/refs/tags/0.12.tar.gz, 下载后重命名为 patchelf-0.12.tar.gzrpcsvc-proto, https://github.com/thkukuk/rpcsvc-proto/releases/download/v1.4/rpcsvc-proto-1.4.tar.gz下载GreatSQL源码包：https://gitee.com/GreatSQL/GreatSQL/archive/greatsql-8.0.25-15.tar.gz1.4、构建docker镜像
用上面这份Dockerfile构建镜像，这里以CentOS 7为例：
FROM centos:7ENV LANG en_US.utf8RUN yum install -y epel-release && \curl -o /etc/yum.repos.d/CentOS-Base.repo http://mirrors.cloud.tencent.com/repo/centos7_base.repo && \yum clean all && \yum makecacheRUN yum install -y yum-utils && \yum install -y wget diffutils net-tools vim git gcc gcc-c++ automake libtool cmake cmake3 \make psmisc openssl-devel zlib-devel readline-devel bzip2-devel expat-devel gflags-devel \bison bison-devel flex wget unzip libcurl-devel libevent-devel libffi-devel lz4-devel lz4-static \file clang bzip2 snappy-devel libxml2-devel libtirpc libtirpc-devel numactl-devel numactl-libs \numactl gtest-devel openldap-devel openldap-clients rpcgen pam-devel valgrind boost-devel rpm* tar \centos-release-scl libzstd libzstd-static libzstd-devel perl-Env perl-JSON time libaio-devel \ncurses-devel ncurses-libs pam python-devel redhat-lsb-core scl-utils-build pkg-config ccacheRUN yum install -y devtoolset-10-gcc*RUN echo 'scl enable devtoolset-10 bash' >> /root/.bash_profile# update gitCOPY git-v2.27.0.tar.gz /tmp/RUN cd /tmp/ && tar -xzvf git-v2.27.0.tar.gz && cd git-2.27.0 && make prefix=/opt/git/ all && make prefix=/opt/git/ installRUN mv /usr/bin/git /usr/bin/git.bk && ln -s /opt/git/bin/git /usr/bin/git# update patchelf 0.12COPY patchelf-0.12.tar.gz /tmp/RUN cd /tmp && tar -xzvf patchelf-0.12.tar.gz && cd patchelf && ./bootstrap.sh && ./configure && make && make installCOPY rpcsvc-proto-1.4.tar.gz /tmp/rpcsvc-proto-1.4.tar.gzRUN tar zxvf /tmp/rpcsvc-proto-1.4.tar.gz -C /tmp && cd /tmp/rpcsvc-proto-1.4/ && ./configure && make && make installRUN rm -fr /tmp/*COPY boost_1_73_0.tar.gz /opt/RUN ln -fs /usr/bin/cmake3 /usr/bin/cmake开始构建docker镜像，胜利后再保留到本地并导入本地镜像：
[root@greatsql ~]# docker build -t centos7-greatsql .... ...[root@greatsql ~]# docker save -o centos7-greatsql.tar centos7-greatsql[root@greatsql ~]# docker load -i centos7-greatsql.tar创立一个docker容器，并将GreatSQL源码包copy进去：
[root@greatsql ~]# docker run -itd --name greatsql --hostname=greatsql centos7-greatsql bash[root@greatsql ~]# docker cp /opt/greatsql-8.0.25-15.tar.gz greatsql:/opt/[root@greatsql ~]# docker exec -it greatsql bash[root@greatsql /]# ls -l /opt/-rw------- 1 root root 128699082 Jul 27 06:56 boost_1_73_0.tar.gzdrwxr-xr-x 5 root root 4096 Jul 28 06:38 git-rw------- 1 1000 1000 526639994 Jul 27 05:59 greatsql-8.0.25-15.tar.gzdrwxr-xr-x 3 root root 4096 Jul 28 06:34 rh2、编译GreatSQL
进入容器后，解压GreatSQL和boost源码包：
[root@greatsql /]# tar zxf /opt/greatsql-8.0.25-15.tar.gz -C /opt[root@greatsql /]# tar zxf /opt/boost_1_73_0.tar.gz -C /opt/greatsql-8.0.25-15/2.1、只编译二进制文件
如果只是想在本机应用，则能够只编译出二进制文件即可，无需打包或制作RPM包。用上面的命令进行编译：
[root@greatsql /]# cmake3 /opt/greatsql-8.0.25-15 \-DBUILD_TESTING=OFF -DUSE_GTAGS=OFF -DUSE_CTAGS=OFF \-DUSE_ETAGS=OFF \-DUSE_CSCOPE=OFF -DWITH_TOKUDB=OFF \-DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=RelWithDebInfo \-DFEATURE_SET=community \-DCMAKE_INSTALL_PREFIX=/usr/local/GreatSQL-8.0.25-15-Linux \-DMYSQL_DATADIR=/usr/local/GreatSQL-8.0.25-15-Linux/data \-DROUTER_INSTALL_LIBDIR=/usr/local/GreatSQL-8.0.25-15-Linux/lib/mysqlrouter/private \-DROUTER_INSTALL_PLUGINDIR=/usr/local/GreatSQL-8.0.25-15-Linux/lib/mysqlrouter/plugin \-DCOMPILATION_COMMENT='GreatSQL (GPL), Release 15, Revision e36e91b7242' \-DWITH_PAM=ON -DWITH_ROCKSDB=ON -DROCKSDB_DISABLE_AVX2=1 -DROCKSDB_DISABLE_MARCH_NATIVE=1 \-DWITH_INNODB_MEMCACHED=ON -DWITH_ZLIB=bundled -DWITH_NUMA=ON -DWITH_LDAP=system \-DFORCE_INSOURCE_BUILD=1 -DWITH_LIBEVENT=bundled -DWITH_ZSTD=bundled \-DWITH_BOOST=/opt/greatsql-8.0.25-15/boost_1_73_0cmake过程如果没报错，就会输入相似上面的后果：
... ...-- Build files have been written to: /opt/greatsql-8.0.25-15接下来能够开始正式编译了：
[root@greatsql ~]# make -j30 VERBOSE=1 && make install参数 -j30 设定为并行编译的逻辑CPU数量，能够指定为比逻辑CPU总数少一点，不要把所有CPU都跑满。
编译实现后，就会将二进制文件装置到 /usr/local/GreatSQL-8.0.25-15-Linux.x86_64 目录下。
2.2、编译并打包成二进制文件包或RPM包
如果是想要在编译完后也能拷贝到其余服务器上应用，也能够间接编译生成二进制包或RPM包，能够用上面的命令编译：
[root@greatsql ~]# cd /opt/greatsql-8.0.25-15/build-gs/[root@greatsql ~]# export your_processors=30 #同上，批改并行CPU数量[root@greatsql ~]# export TAR_PROCESSORS=-T$your_processors[root@greatsql ~]# export MAKE_JFLAG=-j$your_processors[root@greatsql ~]# mkdir -p workdir[root@greatsql ~]# cp /opt/boost_1_73_0.tar.gz /opt/greatsql-8.0.25-15/build-gs/[root@greatsql ~]# cp /opt/greatsql-8.0.25-15.tar.gz /opt/greatsql-8.0.25-15/build-gs/workdir/# 抉择1：编译并打包成二进制包[root@greatsql ~]# bash -xe ./percona-server-8.0_builder.sh --builddir=`pwd`/workdir --get_sources=0 --install_deps=0 --with_ssl=1 --build_tarball=1 --build_src_rpm=0 --build_rpm=0 --no_git_info=1 --local_boost=1# 抉择2：编译并打包成RPM包[root@greatsql ~]# bash -xe ./percona-server-8.0_builder.sh --builddir=`pwd`/workdir --get_sources=0 --install_deps=0 --with_ssl=1 --build_tarball=0 --build_src_rpm=1 --build_rpm=1 --no_git_info=1 --local_boost=1编译过程中如果遇到相似上面的patchelf报错：
+ patchelf --replace-needed libreadline.so.7 libreadline.so bin/mysqlpatchelf: cannot normalize PT_NOTE segment: non-contiguous SHT_NOTE sections能够参考这个patch：patchelf: Fix alignment issues with contiguous note sections #275，批改下源码，在容器里从新手动编译patchelf。
编译完结后，就会在 /opt/greatsql-8.0.25-15/build-gs/workdir/ 目录下生成相应的二进制包、RPM包：
[root@greatsql build-gs]# du -sh workdir/TARGET/40M workdir/TARGET/GreatSQL-8.0.25-15-Linux-glibc2.17-x86_64-minimal.tar.xz500M workdir/TARGET/GreatSQL-8.0.25-15-Linux-glibc2.17-x86_64.tar.xz[root@greatsql build-gs]# du -sh workdir/rpm/greatsql-*14M workdir/rpm/greatsql-client-8.0.25-15.1.el8.x86_64.rpm30M workdir/rpm/greatsql-client-debuginfo-8.0.25-15.1.el8.x86_64.rpm3.4M workdir/rpm/greatsql-debuginfo-8.0.25-15.1.el8.x86_64.rpm23M workdir/rpm/greatsql-debugsource-8.0.25-15.1.el8.x86_64.rpm2.1M workdir/rpm/greatsql-devel-8.0.25-15.1.el8.x86_64.rpm4.6M workdir/rpm/greatsql-mysql-router-8.0.25-15.1.el8.x86_64.rpm27M workdir/rpm/greatsql-mysql-router-debuginfo-8.0.25-15.1.el8.x86_64.rpm13M workdir/rpm/greatsql-rocksdb-8.0.25-15.1.el8.x86_64.rpm204M workdir/rpm/greatsql-rocksdb-debuginfo-8.0.25-15.1.el8.x86_64.rpm60M workdir/rpm/greatsql-server-8.0.25-15.1.el8.x86_64.rpm343M workdir/rpm/greatsql-server-debuginfo-8.0.25-15.1.el8.x86_64.rpm1.4M workdir/rpm/greatsql-shared-8.0.25-15.1.el8.x86_64.rpm2.5M workdir/rpm/greatsql-shared-debuginfo-8.0.25-15.1.el8.x86_64.rpm440M workdir/rpm/greatsql-test-8.0.25-15.1.el8.x86_64.rpm18M workdir/rpm/greatsql-test-debuginfo-8.0.25-15.1.el8.x86_64.rpm这就能够用在copy到其余服务器上安装应用了。
3、初始化GreatSQL
本次打算在上面3台服务器上部署MGR集群：
先在nodeA服务器上执行上面的初始化工作，另外两个服务器也照做一遍即可。
首先编辑 /etc/my.cnf 配置文件，可参考采纳上面的配置参数：
#my.cnf[mysqld]user = mysqlport = 3306#主从复制或MGR集群中，server_id记得要不同#另外，实例启动时会生成 auto.cnf，外面的 server_uuid 值也要不同#server_uuid的值还能够本人手动指定，只有合乎uuid的格局规范就能够server_id = 3306basedir=/usr/local/GreatSQL-8.0.25-15-Linux.x86_64datadir = /data/GreatSQLsocket = /data/GreatSQL/mysql.sockpid-file = mysql.pidcharacter-set-server = UTF8MB4skip_name_resolve = 1#若你的MySQL数据库次要运行在境外，请务必依据理论状况调整本参数default_time_zone = "+8:00"#performance setttingslock_wait_timeout = 3600open_files_limit = 65535back_log = 1024max_connections = 512max_connect_errors = 1000000table_open_cache = 1024table_definition_cache = 1024thread_stack = 512Ksort_buffer_size = 4Mjoin_buffer_size = 4Mread_buffer_size = 8Mread_rnd_buffer_size = 4Mbulk_insert_buffer_size = 64Mthread_cache_size = 768interactive_timeout = 600wait_timeout = 600tmp_table_size = 32Mmax_heap_table_size = 32M#log settingslog_timestamps = SYSTEMlog_error = /data/GreatSQL/error.loglog_error_verbosity = 3slow_query_log = 1log_slow_extra = 1slow_query_log_file = /data/GreatSQL/slow.loglong_query_time = 0.1log_queries_not_using_indexes = 1log_throttle_queries_not_using_indexes = 60min_examined_row_limit = 100log_slow_admin_statements = 1log_slow_slave_statements = 1log_bin = /data/GreatSQL/binlogbinlog_format = ROWsync_binlog = 1binlog_cache_size = 4Mmax_binlog_cache_size = 2Gmax_binlog_size = 1Gbinlog_rows_query_log_events = 1binlog_expire_logs_seconds = 604800#MySQL 8.0.22前，想启用MGR的话，须要设置binlog_checksum=NONE才行binlog_checksum = CRC32gtid_mode = ONenforce_gtid_consistency = TRUE#myisam settingskey_buffer_size = 32Mmyisam_sort_buffer_size = 128M#replication settingsmaster_info_repository = TABLErelay_log_info_repository = TABLErelay_log_recovery = 1slave_parallel_type = LOGICAL_CLOCK#能够设置为逻辑CPU数量的2倍slave_parallel_workers = 64binlog_transaction_dependency_tracking = WRITESETslave_preserve_commit_order = 1slave_checkpoint_period = 2#mgr settingsloose-plugin_load_add = 'mysql_clone.so'loose-plugin_load_add = 'group_replication.so'loose-group_replication_group_name = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaa1"#MGR本地节点IP:PORT，请自行替换loose-group_replication_local_address = "172.16.16.10:33061"#MGR集群所有节点IP:PORT，请自行替换loose-group_replication_group_seeds = "172.16.16.10:33061,172.16.16.11:33061,172.16.16.12:33061"loose-group_replication_start_on_boot = OFFloose-group_replication_bootstrap_group = OFFloose-group_replication_exit_state_action = READ_ONLYloose-group_replication_flow_control_mode = "DISABLED"loose-group_replication_single_primary_mode = ON#innodb settingstransaction_isolation = REPEATABLE-READinnodb_buffer_pool_size = 64Ginnodb_buffer_pool_instances = 8innodb_data_file_path = ibdata1:12M:autoextendinnodb_flush_log_at_trx_commit = 1innodb_log_buffer_size = 32Minnodb_log_file_size = 2Ginnodb_log_files_in_group = 3innodb_max_undo_log_size = 4G# 依据您的服务器IOPS能力适当调整# 个别配一般SSD盘的话，能够调整到 10000 - 20000# 配置高端PCIe SSD卡的话，则能够调整的更高，比方 50000 - 80000innodb_io_capacity = 4000innodb_io_capacity_max = 8000innodb_open_files = 65535innodb_flush_method = O_DIRECTinnodb_lru_scan_depth = 4000innodb_lock_wait_timeout = 10innodb_rollback_on_timeout = 1innodb_print_all_deadlocks = 1innodb_online_alter_log_max_size = 4Ginnodb_print_ddl_logs = 1innodb_status_file = 1#留神: 开启 innodb_status_output & innodb_status_output_locks 后, 可能会导致log_error文件增长较快innodb_status_output = 0innodb_status_output_locks = 1innodb_sort_buffer_size = 67108864#innodb monitor settingsinnodb_monitor_enable = "module_innodb"innodb_monitor_enable = "module_server"innodb_monitor_enable = "module_dml"innodb_monitor_enable = "module_ddl"innodb_monitor_enable = "module_trx"innodb_monitor_enable = "module_os"innodb_monitor_enable = "module_purge"innodb_monitor_enable = "module_log"innodb_monitor_enable = "module_lock"innodb_monitor_enable = "module_buffer"innodb_monitor_enable = "module_index"innodb_monitor_enable = "module_ibuf_system"innodb_monitor_enable = "module_buffer_page"innodb_monitor_enable = "module_adaptive_hash"#pfs settingsperformance_schema = 1#performance_schema_instrument = '%memory%=on'performance_schema_instrument = '%lock%=on'执行上面的命令进行初始化：
[root@greatsql ~]# /usr/local/GreatSQL-8.0.25-15-Linux.x86_64/bin/mysqld --defaults-file=/etc/my.cnf --initialize-insecure初始化时可选项有 --initialize 和 --initialize-insecure 两种，前者会为root账号生成一个随机明码，后者不会。在这里为了省事，选用后者，生产环境里请务必要为root用户设置平安明码。
之后就能够启动mysqld过程了：
[root@greatsql ~]# /usr/local/GreatSQL-8.0.25-15-Linux.x86_64/bin/mysqld --defaults-file=/etc/my.cnf &GreatSQL是基于Percona Server的分支版本，默认状况下须要用到jemalloc这个库，如果启动过程中报告相似上面的谬误，只须要再装置jemalloc或者libaio等相干的软件包即可：
/usr/local/GreatSQL-8.0.25-15/bin/mysqld: error while loading shared libraries: libjemalloc.so.1: cannot open shared object file: No such file or directory补充装置libjemalloc库即可：
[root@greatsql ~]# yum install -y jemalloc jemalloc-devel如果想要敞开mysqld过程，执行上面的命令即可：
# 假如此时root还是空明码[root@greatsql ~]# /usr/local/GreatSQL-8.0.25-15-Linux.x86_64/bin/mysql -uroot -S/data/GreatSQL/mysql.sock shutdown查看版本号：
root@GreatSQL [(none)]> \s...Server version: 8.0.25-15 GreatSQL, Release 15, Revision 80bbf22abbd...Enjoy GreatSQL :)
本文由博客一文多发平台 OpenWrite 公布！