HybridDB for PostgreSQL上手指南

  1. 云栖社区>
  2. 博客>
  3. 正文

HybridDB for PostgreSQL上手指南

明虚 2017-10-19 16:35:39 浏览1310
展开阅读全文

架构介绍

https://yq.aliyun.com/articles/73038?spm=5176.100239.blogcont225664.61.usDaOd

开通实例

https://help.aliyun.com/document_detail/50200.html?spm=5176.product35364.4.2.j854nc

实例管理

DMS: 进入实例控制台,点击“登陆数据库”

HDB,RDS PG管理客户端pgadmin:https://www.pgadmin.org/download/

HDB PG建议下载1.6.3的pgadmin版本:https://www.postgresql.org/ftp/pgadmin/pgadmin3/

产品文档

HDB PG 产品文档:https://help.aliyun.com/document_detail/49912.html

建表相关

建表语法:https://gpdb.docs.pivotal.io/500/ref_guide/sql_commands/CREATE_TABLE.html

列存压缩(压缩比3到10倍):https://help.aliyun.com/knowledge_detail/50320.html?spm=5176.7750321.6.584.HW7nCT

表分区(支持数字和日期类型上的多级分区):

数据导入与同步

HDB PG OSS 外部表文档:https://help.aliyun.com/document_detail/35457.html

ODPS 导出到OSS:https://www.atatech.org/articles/71002

HDB PG 批量更新(Upsert)方法:https://yq.aliyun.com/articles/86604

社区文档

RDS PG 社区官方手册:https://www.postgresql.org/docs/10/static/index.html
HDB PG 社区官方手册:http://greenplum.org/docs/
HDB PG 8.2 社区官方文档:https://www.postgresql.org/docs/8.2/static/
MADlib SQL机器学习库:http://madlib.apache.org/documentation.html
PostGIS文档:http://postgis.net/docs/manual-2.3/
PostGIS入门:http://workshops.boundlessgeo.com/postgis-intro/

开发指南

客户端、JDBC驱动下载:https://help.aliyun.com/document_detail/35428.html?spm=5176.7750321.6.552.8z0pL3

PG 客户端驱动:https://www.postgresql.org/docs/10/static/external-interfaces.html

Java:https://github.com/digoal/blog/blob/master/201701/20170106_05.md
PHP:https://github.com/digoal/blog/blob/master/201701/20170106_08.md
Ruby:https://github.com/digoal/blog/blob/master/201701/20170106_07.md
Python:https://github.com/digoal/blog/blob/master/201701/20170106_06.md
C:https://github.com/digoal/blog/blob/master/201701/20170106_09.md

开发规约

https://github.com/digoal/blog/blob/master/201609/20160926_01.md

最佳实践

HDB PG 数据倾斜的监测和实践:https://github.com/digoal/blog/blob/master/201708/20170821_02.md

HDB PG 负载管理(资源队列管理):https://github.com/digoal/blog/blob/master/201708/20170821_01.md

mysql->HDB PG全量、增量同步:https://github.com/aliyun/rds_dbsync

mysql->HDB PG全量、增量同步:https://help.aliyun.com/product/26590.html

分页和评估(游标 或 PK+上一次最大位点开始):https://github.com/digoal/blog/blob/master/201605/20160506_01.md

HyperLogLog的使用:https://github.com/digoal/blog/blob/master/201608/20160825_02.md

UPSERT的用法:https://github.com/digoal/blog/blob/master/201704/20170424_04.md

PostGIS例子:http://revenant.ca/www/postgis/workshop/indexing.html

锁等待查询:https://github.com/digoal/blog/blob/master/201705/20170521_01.md

典型方案

RDS PG,HDB PG案例大全(开发者的《如来神掌》):https://github.com/digoal/blog/blob/master/201706/20170601_02.md

网友评论

登录后评论
0/500
评论
明虚
+ 关注