Pick Mysql 的开源国产数据库来了

Whoami：6年+金融、政府、医疗领域工作经验的DBA
Certificate：PGCM、OCP、YCP
Skill：Oracle、Mysql、PostgreSQL、国产数据库
Platform：CSDN、墨天轮、公众号（呆呆的私房菜）

[root@host-01 ~]# uname -a
Linux host-01 3.10.0-957.el7.x86_64 #1 SMP Thu Oct 4 20:48:51 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

[root@host-01 ~]#  yum install -y gcc make autoconf automake libtool uuid-devel libicu-devel zlib-devel openssl-devel readline-devel gdb ltrace strace

[root@host-01 ~]# groupadd -g 2001 halo
[root@host-01 ~]# useradd -u 2001 -g halo halo

[root@host-01 ~]#  su - halo
[halo@host-01 ~]$ unzip openHalo-master.zip

[halo@host-01 openHalo-master]$ ./configure --prefix=/home/halo/openhalo/1.0 --enable-debug --with-uuid=ossp --with-icu CFLAGS=-O2
[halo@host-01 openHalo-master]$ make -j 8 && make install
[halo@host-01 openHalo-master]$ cd contrib/
[halo@host-01 contrib]$ make -j 8 && make install

[halo@host-01 ~]$ cat >> ~/.bashrc <<EOF
export PGHOME=/home/halo/openhalo/1.0
export PGDATA=/home/halo/openhalo/data
export PGHOST=/home/halo/openhalo
export PATH=$PATH:$PGHOME/bin
export LD_LIBRARY_PATH=$PGHOME/lib
EOF


[halo@host-01 ~]$ source ~/.bashrc

[halo@host-01 openhalo]$ pg_ctl init
The files belonging to this database system will be owned by user "halo".
This user must also own the server process.
The database cluster will be initialized with locale "zh_CN.UTF-8".
The default database encoding has accordingly been set to "UTF8".
initdb: could not find suitable text search configuration for locale "zh_CN.UTF-8"
The default text search configuration will be set to "simple".
Data page checksums are disabled.
creating directory /home/halo/openhalo/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... PRC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
/home/halo/openhalo/1.0/bin/pg_ctl -D /home/halo/openhalo/data -l logfile start

cat >> $PGDATA/postgresql.conf <<EOF
listen_addresses = '*'
database_compat_mode = 'mysql' 
mysql.listener_on = true
mysql.port = 3306
unix_socket_directories = '/home/halo/openhalo'
EOF


cat >> $PGDATA/pg_hba.conf <<EOF
host   all             all             0.0.0.0/0               md5
EOF

pg_ctl start

[halo@host-01 ~]$ psql
halo0root=# CREATE EXTENSION aux_mysql CASCADE;
NOTICE:  installing required extension "uuid-ossp"
CREATE EXTENSION

mysql -uhalo -h10.28.12.21
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.32-log MySQL Server (GPL)


Copyright (c) 2000, 2022, 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> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mys_sys            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)


mysql> create database chendb;
Query OK, 0 rows affected (0.01 sec)


mysql> create table chendb.`students` (
    ->     `student_id` INT UNSIGNED AUTO_INCREMENT COMMENT '学生唯一标识',
    ->     `name` VARCHAR(50) NOT NULL COMMENT '学生姓名',
    ->     `gender` ENUM('男','女') DEFAULT NULL COMMENT '性别',
    ->     `age` TINYINT UNSIGNED CHECK (age BETWEEN 12 AND 30) COMMENT '年龄范围12-30岁',
    ->     `email` VARCHAR(100) UNIQUE COMMENT '唯一邮箱地址',
    ->     `enrollment_date` DATE NOT NULL DEFAULT (CURRENT_DATE) COMMENT '入学日期',
    ->     `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
    ->     PRIMARY KEY (`student_id`),
    ->     INDEX `idx_email` (`email`(20))  
    -> )
    -> ;
Query OK, 0 rows affected (0.04 sec)
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


mysql> use chendb;


mysql> INSERT INTO `students` (`name`, `gender`, `age`, `email`)
    -> VALUES ('张三', '男', 18, 'zhangsan@school.com');
Query OK, 1 row affected (0.01 sec)


mysql> select * from `students`;
+------------+--------+--------+-----+---------------------+-----------------+---------------------+
| student_id | name   | gender | age | email               | enrollment_date | created_at          |
+------------+--------+--------+-----+---------------------+-----------------+---------------------+
|          1 | 张三   | 男     |  18 | zhangsan@school.com | 2025-04-08      | 2025-04-08 21:30:03 |
+------------+--------+--------+-----+---------------------+-----------------+---------------------+
1 row in set (0.00 sec)