Halo DB 14 小白零基础系列（10）--HaloDB中MySQL模式下的流复制实现.pdf

Salvatore-zz

102

8页

1次

2024-03-14

免费下载

[root@halodb1 ~]# mkdir -p /data/halo/archivedir

[root@halodb1 ~]# chown -R halo:halo /data/halo/archivedir

archive_mode = on

# WAL %p WAL %f WAL

WAL

archive_command = 'test ! -f /data/halo/archivedir/%f && cp %p

/data/halo/archivedir/%f'

# WAL WAL

restore_command = 'cp /data/halo/archivedir/%f %p'

#database_compat_mode = 'postgresql' database_compat_mode = 'mysql'

#second_listener_on = false second_listener_on = 1

#mysql.halo_mysql_version = '5.7.32-log' mysql.halo_mysql_version =

'8.0.21-log'

#mysql.ci_collation = true mysql.ci_collation = true

[halo@halodb1 ~]$ pg_ctl restart

pg_ctl: PID file "/data/halo/postmaster.pid" does not exist

Is server running?

trying to start server anyway

waiting for server to start....2024-03-12 17:15:41.001 CST [2022] LOG:

starting (Halo) 1.0.14.10 (231130) on x86_64-pc-linux-gnu, compiled by gcc

(GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

2024-03-12 17:15:41.001 CST [2022] LOG: listening on IPv4 address "0.0.0.0",

port 1921

2024-03-12 17:15:41.001 CST [2022] LOG: listening on IPv6 address "::", port

1921

2024-03-12 17:15:41.003 CST [2022] LOG: listening on Unix socket

"/var/run/halo/.s.PGSQL.1921"

2024-03-12 17:15:41.005 CST [2022] LOG: listening on IPv4 address "0.0.0.0",

port 3306

2024-03-12 17:15:41.005 CST [2022] LOG: listening on IPv6 address "::", port

3306

2024-03-12 17:15:41.007 CST [2022] LOG: listening on Unix socket

"/var/run/halo/.s.PGSQL.3306"

2024-03-12 17:15:41.017 CST [2023] LOG: database system was shut down at 2024-

03-12 17:00:31 CST

2024-03-12 17:15:41.023 CST [2022] LOG: database system is ready to accept

connections

done

server started

[halo@halodb1 ~]$ psql -c "create extension aux_mysql; "

CREATE EXTENSION

halo0root=# set password_encryption='mysql_native_password';

SET

halo0root=# CREATE USER mysqltest SUPERUSER PASSWORD '123456';

CREATE ROLE

[halo@halodb1 halo]$ pg_ctl reload

server signaled

2024-03-12 18:07:29.009 CST [2022] LOG: received SIGHUP, reloading

configuration files

halo0root=# \d List of relations

Schema | Name | Type | Owner

--------+-----------+-------+-------

mysql | dual | view | halo

mysql | proc | view | halo

mysql | proc_type | table | halo

mysql | user | table | halo

(4 rows)

of 8

免费下载

halodb 国产数据库新手教程墨力计划墨力原创作者计划

文档被以下合辑收录

HaloDB小白零基础入门系列（共34篇）

羲和数据库（简称 Halo ) 易景数通自主研发的一款数据库产品。Halo数据库拥有独特的多模解析引擎（现阶段主要兼容Oracle数据库），能大幅减少代码的修改量。

文档被以下合辑收录

相关文档

评论