2018年PostgreSQL中国技术大会 为什么我们抛弃MongoDB和 MySQL，选择PgSQL 张启程 qc@aochuang.cn 奥创软件研究院（上海）研发中心 2018年PostgreSQL中国技术大会 任何数据库都很好用 • 我不是一个专业的DBA ，对数据库的理解不够深入，也不 一定准确，在此抛砖引玉，只是结合我们团队业务场景来 分享下我们选择数据库的过程。 • 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL： • copy简单快速，批量复制，替换修改简单； • 每个网站一个库，单体数据量小，数据类型固定； • 后来做SCRM系统，也首选MySQL： • 需求经常改动，每次改需求先改数据库； • 数据量越来越大，越来越不了解这只海豚； 2018年PostgreSQL中国技术大会 MySQL+MongoDB • • 迫于无奈，分拆数据，将需要用到事务、调用频繁的数据 继续用MySQL,将IM中聊天记录等数据量大的数据，用 MongoDB存储，减轻MySQL负担； • 这种方式虽然可以暂时解决问题，我们自己用也没有任何 问题，可以结合各自数据库优点，发挥性能。但是我们有 很多客户是需要私有化部署数据库，让每家客户都接受这 种方式，会为甲方增加很多服务器以及运维成本，可能客 户数据量很少，也需要使用双数据库，更新运维都比较麻

数据库总体架构 应用 逻辑复制 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 SQL语句 数据 MYSQL PG ORACLE LOGICAL Broker M1 M2 M3 Mn Master 逻辑解码 产生SQL+数据 MQ消息队列 DB重放语句 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 MQ-Prototype KAFKA-MQ-Solution Cluster BackupData:2 Producer Producer Consumer DB dist-cluser multi single cluser broker1

..................................................................246 16.2. Creating a Database Cluster ........................................................................................246 16.3 ............................................................................................715 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................233 16.2. Creating a Database Cluster .................................................................................233 16.3. Starting ............................................................................................674 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................267 16.2. Creating a Database Cluster ........................................................................................267 16.3 ............................................................................................768 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................266 16.2. Creating a Database Cluster ........................................................................................266 16.3 ............................................................................................764 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................280 16.2. Creating a Database Cluster ........................................................................................280 16.3 ............................................................................................847 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................280 16.2. Creating a Database Cluster ........................................................................................280 16.3 ............................................................................................847 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................387 17.2. Creating a Database Cluster ........................................................................................387 17.2 ...........................................................................................1053 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 6 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying

..................................................................364 17.2. Creating a Database Cluster .................................................................................364 17.2.1. Network ............................................................................................995 CLUSTER ................................................................................................ a collection of databases managed by a single PostgreSQL server instance constitutes a database cluster. 5 Chapter 2. The SQL Language 2.3. Creating a New Table You can create a new table by specifying