在麒麟OS+龙芯环境下源码编译安装GreatSQL

[root@ky10 ~]# cat /etc/system-release
Kylin Linux Advanced Server release V10 (Tercel)

[root@ky10 ~]# uname -a
Linux ky10 4.19.90-23.19.v2101.a.ky10.loongarch64 #1 SMP Mon Sep 13 22:33:20 CST 2021 loongarch64 loongarch64 loongarch64 GNU/Linux

dnf install -y automake bison bison-devel boost-devel bzip2 bzip2-devel clang \
cmake cmake3 diffutils expat-devel file flex gcc gcc-c++ git jemalloc jemalloc-devel \
graphviz libaio-devel libarchive libcurl-devel libevent-devel libffi-devel libicu-devel libssh \
libtirpc libtirpc-devel libtool libxml2-devel libzstd libzstd-devel lz4-devel \
lz4-static make ncurses-devel ncurses-libs net-tools numactl numactl-devel numactl-libs openldap-clients \
openldap-devel openssl openssl-devel pam pam-devel perl perl-Env perl-JSON perl-Memoize \
perl-Time-HiRes pkg-config psmisc re2-devel readline-devel \
snappy-devel tar time unzip vim wget zlib-devel

[root@ky10 ~]# cd /opt && tar zxvf patchelf-0.14.tar.gz && cd patchelf-0.14 && ./bootstrap.sh && ./configure && make && make install

[root@ky10 ~]# cd /opt && tar zxvf rpcsvc-proto-1.4.tar.gz && cd rpcsvc-proto-1.4/ && ./configure && make && make install

[root@ky10 ~]# cd /opt
[root@ky10 ~]# tar zxf /opt/greatsql-8.0.25-16.tar.gz -C /opt
[root@ky10 ~]# tar zxf /opt/boost_1_73_0.tar.gz -C /opt

[root@ky10 ~]# cd /opt/greatsql-8.0.25-16

#大概要修改106行附近的内容
[root@ky10 ~]# vim extra/icu/source/i18n/double-conversion-utils.h +106

#修改这行内容，增加对龙芯架构平台的支持
    defined(__mips__) || \
=>
    defined(__mips__) || defined(__loongarch__) || \

[root@ky10 ~]# tar zcf greatsql-8.0.25-16.tar.gz greatsql-8.0.25-16

[root@ky10 ~]# cd /opt/greatsql-8.0.25-16 && \
rm -fr bld && \
mkdir bld && \
cd bld && \
cmake .. -DBOOST_INCLUDE_DIR=/opt/boost_1_73_0 \
-DLOCAL_BOOST_DIR=/opt/boost_1_73_0 \
-DCMAKE_INSTALL_PREFIX=/usr/local/GreatSQL-8.0.25-16 \
-DWITH_ZLIB=bundled \
-DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release \
-DWITH_TOKUDB=OFF \
-DWITH_ROCKSDB=OFF \
-DCOMPILATION_COMMENT="GreatSQL (GPL), Release 16, Revision 8bb0e5af297" \
-DMAJOR_VERSION=8 \
-DMINOR_VERSION=0 \
-DPATCH_VERSION=25 \
-DWITH_UNIT_TESTS=OFF \
-DWITH_NDBCLUSTER=OFF \
-DWITH_SSL=system \
-DWITH_SYSTEMD=ON \
-DWITH_AUTHENTICATION_LDAP=OFF \
&& make -j16 VERBOSE=1 && make install

[root@ky10 ~]# mkdir -p /root/rpmbuild/SOURCES/
#将源码包和boost包复制过来
[root@ky10 ~]# cp greatsql-8.0.25-16.tar.gz boost_1_73_0.tar.gz /root/rpmbuild/SOURCES/
[root@ky10 ~]# cd /opt/greatsql-8.0.25-16/build-gs
[root@ky10 ~]# rpmbuild -bb greatsql.spec

$ rpm -ivh greatsql*rpm

$ systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
...
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 1137698 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 1137732 (mysqld)
   Status: "Server is operational"
    Tasks: 39 (limit: 149064)
   Memory: 336.7M
   CGroup: /system.slice/mysqld.service
           └─1137732 /usr/sbin/mysqld
...

# 新建 /data/GreatSQL 空目录，并修改目录所有者
$ mkdir -p /data/GreatSQL
$ chown -R mysql:mysql /data/GreatSQL

# 重启mysqld服务，即自行完成重新初始化
$ systemctl restart mysqld

$ grep root /data/GreatSQL/error.log
[Note] [MY-010454] [Server] A temporary password is generated for root@localhost: dt_)MtExl594

$ mysql -uroot -p'dt_)MtExl594'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.25-16

Copyright (c) 2021-2021 GreatDB Software Co., Ltd
Copyright (c) 2009-2021 Percona LLC and/or its affiliates
Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> \s
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>

mysql> ALTER USER USER() IDENTIFIED BY 'GreatSQL-8025~%';
Query OK, 0 rows affected (0.02 sec)

#创建一个新用户GreatSQL，只允许从192.168.0.0/16网络连入，密码是 GreatSQL-2022
mysql> CREATE USER GreatSQL@'192.168.0.0/16' IDENTIFIED BY 'GreatSQL-2022';
Query OK, 0 rows affected (0.06 sec)

#创建一个新的用户库，并对GreatSQL用户授予读写权限
mysql> CREATE DATABASE GreatSQL;
Query OK, 1 row affected (0.03 sec)

mysql> GRANT ALL ON GreatSQL.* TO GreatSQL@'192.168.0.0/16';
Query OK, 0 rows affected (0.03 sec)

$ mysql -h192.168.1.10 -uGreatSQL -p'GreatSQL-2022'
...
# 切换到GreatSQL数据库下
mysql> use GreatSQL;
Database changed

# 创建新表
mysql> CREATE TABLE t1(id INT PRIMARY KEY);
Query OK, 0 rows affected (0.07 sec)

# 写入测试数据
mysql> INSERT INTO t1 SELECT RAND()*1024;
Query OK, 1 row affected (0.05 sec)
Records: 1  Duplicates: 0  Warnings: 0

# 查询数据
mysql> SELECT * FROM t1;
+-----+
| id  |
+-----+
| 203 |
+-----+
1 row in set (0.00 sec)

make[2]: Entering directory '/opt/sysbench-1.0.20/third_party/luajit/luajit'
make -C src clean
make[3]: Entering directory '/opt/sysbench-1.0.20/third_party/luajit/luajit/src'
lj_arch.h:59:2: error: #error "No support for this architecture (yet)"
 #error "No support for this architecture (yet)"
  ^~~~~
lj_arch.h:357:2: error: #error "No target architecture defined"
 #error "No target architecture defined"
  ^~~~~

$ ./configure --with-system-luajit

# 修改前
LuaJIT             : bundled
LUAJIT_CFLAGS      : -I$(abs_top_builddir)/third_party/luajit/inc

# 修改后
LuaJIT             : system
LUAJIT_CFLAGS      : -I/usr/include/luajit-2.1