Postgres Conference China 2016 中国用户大会 Scaling with PostgreSQL 9.6 and Postgres-XL Mason Sharp mason.sharp@gmail.com Huawei Postgres Conference China 2016 中国用户大会 whoami • Engineer at Huawei (USA clusters • GridSQL • Postgres-XC • Postgres-XL Postgres Conference China 2016 中国用户大会 Agenda • PostgreSQL 9.6 Scaling Features • Scaling Solutions • Use Cases • Postgres-XL Postgres Conference China 2016 us! • Submit a talk Postgres Conference China 2016 中国用户大会 “We need to scale” “We need replication” Postgres Conference China 2016 中国用户大会 What are your requirements? Postgres Conference China 2016

★PG-13版本 # systemctl stop postgresql-13 #先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/13/data/postgresql.conf #pg-13版本，添加或修改以下配 置 data_directory ★PG-10版本 # systemctl stop postgresql #先停止服务 # mkdir /data_pg # chown postgres:postgres /data_pg # vi /var/lib/pgsql/data/postgresql.conf #pg-10版本，添加或修改以下配置 data_directory firewall-cmd --add-port=5432/tcp --permanent # firewall-cmd --reload pg_hba.conf 配 置 保 存 在 postgres 库 下 面 的 名 为 pg_catalg 的 schema 下 的 pg_hba_file_rules表里： INSERT INTO "pg_hba_file_rules" ("line_number"

Postgres Conference China 2016 中国用户大会 实现PostgreSQL逻辑复制实战 王青松 神州飞象(北京)数据科技有限公司 Your Logo 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 简介 逻辑复制的功能是从PG的WAL日志中，读取数 据库更新信息，然后“翻译”（Decode）成逻 辑的形式，可发送到远程从库做数据同步。 PG WAL Other DB 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 为什么要选择逻辑复制？ 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 数据库总体架构 PostgreSQL PostgreSQL 动态节点管理 … 核心库 查询库 对数据库的读操作 备2 备份 归档 运维监控 数据库总体架构 应用 逻辑复制 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 SQL语句 数据 MYSQL PG ORACLE LOGICAL Broker M1

Postgres Conference China 2016 中国用户大会 PostgreSQL WAL日志解析与应用 王硕 山东瀚高基础软件股份有限公司 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 CONTENTS Part 01 Part 02 Part 03 WAL 日志简介 日志简介 WAL 日志工作原理 利用 WAL 日志我们可以做什么？ 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 Part 01 WAL 日志简介 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Write Ahead Log Files 大小为16M ； • Block为WAL日志的最小单位， 其大小8k，由PageHeaderData 、 XlogRecord、 XLogRecData组成。 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Write Ahead Log Files Segment 3 2 1 256 00000001

Legal Notice PostgreSQL is Copyright © 1996-2021 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ......................xliv 2.1. The Berkeley POSTGRES Project .........................................................................xliv 2.2. Postgres95............................................ ...........................................................................................1868 postgres................................................................................................

Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ................ xliii 2.1. The Berkeley POSTGRES Project ............................................................................... xliii 2.2. Postgres95........................................ ...........................................................................................1190 postgres................................................................................................

Legal Notice PostgreSQL is Copyright © 1996-2021 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ................ xlvii 2.1. The Berkeley POSTGRES Project .............................................................................. xlvii 2.2. Postgres95......................................... ....................................................................................1985 xxxi postgres................................................................................................

Group and is distributed under the terms of the license of the University of California below. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ...................xlv 2.1. The Berkeley POSTGRES Project .................................................................................xlv 2.2. Postgres95......................................... ...........................................................................................1190 postgres................................................................................................

Legal Notice PostgreSQL is Copyright © 1996-2020 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ....................xliii 2.1. The Berkeley POSTGRES Project .........................................................................xliii 2.2. Postgres95............................................ ...........................................................................................1768 postgres................................................................................................

Legal Notice PostgreSQL is Copyright © 1996-2020 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission to use, copy ................. xlvi 2.1. The Berkeley POSTGRES Project ............................................................................... xlvi 2.2. Postgres95......................................... ...........................................................................................1881 postgres................................................................................................