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负担； • 这种方式虽然可以暂时解决问题，我们自己用也没有任何 问题，可以结合各自数据库优点，发挥性能。但是我们有 很多客户是需要私有化部署数据库，让每家客户都接受这 种方式，会为甲方增加很多服务器以及运维成本，可能客 户数据量很少，也需要使用双数据库，更新运维都比较麻

........................................................................................319 22. Backup and Restore .................................................................................... .........323 22.2. File system level backup..............................................................................................323 22.3. On-line backup and point-in-time recovery (PITR) ... ......325 22.3.2. Making a Base Backup ...................................................................................327 22.3.3. Recovering with an On-line Backup.................................

........................................................................................301 22. Backup and Restore .................................................................................... ............305 22.2. File system level backup.......................................................................................305 22.3. On-line backup and point-in-time recovery (PITR) ....... ..........307 22.3.2. Making a Base Backup ............................................................................309 22.3.3. Recovering with an On-line Backup....................................

Signaling Functions......................................................................284 9.26.3. Backup Control Functions .......................................................................285 9.26 ........................................................................................548 24. Backup and Restore .................................................................................... ....................................................................552 24.2. File System Level Backup....................................................................................553 24.3. Continuous

Functions.............................................................................302 9.26.3. Backup Control Functions ..............................................................................303 ........................................................................................581 24. Backup and Restore .................................................................................... ....................................................................585 24.2. File System Level Backup...........................................................................................586 24

........................................................................................351 23. Backup and Restore .................................................................................... .........354 23.2. File system level backup..............................................................................................355 23.3. On-line backup and point-in-time recovery (PITR) ... ......357 23.3.2. Making a Base Backup ...................................................................................359 23.3.3. Recovering with an On-line Backup.................................

........................................................................................353 23. Backup and Restore .................................................................................... .........356 23.2. File system level backup..............................................................................................357 23.3. On-line backup and point-in-time recovery (PITR) ... ......359 23.3.2. Making a Base Backup ...................................................................................361 23.3.3. Recovering with an On-line Backup.................................

........................................................................................372 23. Backup and Restore .................................................................................... .................................................................375 x 23.2. File System Level Backup...........................................................................................376 23 .378 23.3.2. Making a Base Backup ...................................................................................379 23.3.3. Recovering using a Continuous Archive Backup ..........................

........................................................................................372 23. Backup and Restore .................................................................................... .................................................................375 x 23.2. File System Level Backup...........................................................................................376 23 .378 23.3.2. Making a Base Backup ...................................................................................379 23.3.3. Recovering using a Continuous Archive Backup ..........................

........................................................................................494 24. Backup and Restore .................................................................................... ....................................................................498 24.2. File System Level Backup...........................................................................................499 24 .501 24.3.2. Making a Base Backup ...................................................................................503 24.3.3. Recovering using a Continuous Archive Backup ..........................