crunchydata/postgres-operator

PostgreSQL Operator

在Kubernetes上运行您自己的生产级PostgreSQL即服务！

Crunchy https://www.crunchydata.com/products/crunchy-postgresql-operator/%E9%80%9A%E8%BF%87%E6%8F%90%E4%BE%9B%E5%BF%85%E8%A6%81%E5%8A%9F%E8%83%BD%E6%9D%A5%E4%BF%9D%E6%8C%81PostgreSQL%E9%9B%86%E7%BE%A4%E6%AD%A3%E5%B8%B8%E8%BF%90%E8%A1%8C%EF%BC%8C%E4%BB%8E%E8%80%8C%E8%87%AA%E5%8A%A8%E5%8C%96%E5%B9%B6%E7%AE%80%E5%8C%96%E5%9C%A8Kubernetes%E5%8F%8A%E5%85%B6%E4%BB%96%E6%94%AF%E6%8C%81Kubernetes%E7%9A%84%E5%B9%B3%E5%8F%B0%E4%B8%8A%E9%83%A8%E7%BD%B2%E5%92%8C%E7%AE%A1%E7%90%86%E5%BC%80%E6%BA%90PostgreSQL%E9%9B%86%E7%BE%A4%EF%BC%8C%E8%BF%99%E4%BA%9B%E5%8A%9F%E8%83%BD%E5%8C%85%E6%8B%AC%EF%BC%9A

PostgreSQL集群配置

https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/provisioning/%EF%BC%8C%E5%90%8C%E6%97%B6%E5%AE%8C%E5%85%A8%E8%87%AA%E5%AE%9A%E4%B9%89%E6%82%A8%E7%9A%84Pod%E5%92%8CPostgreSQL%E9%85%8D%E7%BD%AE%EF%BC%81

高可用性

由https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/%E6%94%AF%E6%8C%81%E7%9A%84%E5%AE%89%E5%85%A8%E8%87%AA%E5%8A%A8%E5%8C%96%E6%95%85%E9%9A%9C%E8%BD%AC%E7%A7%BB%E3%80%82%E4%BD%BF%E7%94%A8https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#inter-pod-affinity-and-anti-affinity%E6%8F%90%E9%AB%98%E5%BC%B9%E6%80%A7%EF%BC%9B%E6%82%A8%E5%8F%AF%E4%BB%A5%E9%85%8D%E7%BD%AE%E5%85%B6%E5%BC%BA%E5%BA%A6%EF%BC%81%E6%95%85%E9%9A%9C%E7%9A%84%E4%B8%BB%E8%8A%82%E7%82%B9%E4%BC%9A%E8%87%AA%E5%8A%A8%E4%BF%AE%E5%A4%8D%EF%BC%8C%E4%BB%8E%E8%80%8C%E5%8A%A0%E5%BF%AB%E6%81%A2%E5%A4%8D%E6%97%B6%E9%97%B4%E3%80%82

支持https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/multi-cluster-kubernetes%EF%BC%8C%E8%AF%A5%E9%9B%86%E7%BE%A4%E5%8F%AF%E5%9C%A8%E5%8D%95%E4%B8%AAKubernetes%E9%9B%86%E7%BE%A4%E5%86%85%E4%BB%A5%E5%8F%8Ahttps://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/multi-cluster-kubernetes%E4%B9%8B%E9%97%B4%E5%B7%A5%E4%BD%9C%E3%80%82

灾难恢复

备份和恢复利用开源pgBackRest工具，并https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/disaster-recovery/%E3%80%82%E8%AE%BE%E7%BD%AE%E5%A4%87%E4%BB%BD%E4%BF%9D%E7%95%99%E6%97%B6%E9%97%B4%E3%80%82%E9%80%82%E7%94%A8%E4%BA%8E%E8%B6%85%E5%A4%A7%E5%9E%8B%E6%95%B0%E6%8D%AE%E5%BA%93%EF%BC%81

TLS

通过https://access.crunchydata.com/documentation/postgres-operator/latest/pgo-client/common-tasks/#enable-tls%EF%BC%8C%E7%A1%AE%E4%BF%9D%E5%BA%94%E7%94%A8%E7%A8%8B%E5%BA%8F%E5%92%8C%E6%95%B0%E6%8D%AE%E6%9C%8D%E5%8A%A1%E5%99%A8%E4%B9%8B%E9%97%B4%E7%9A%84%E5%AE%89%E5%85%A8%E9%80%9A%E4%BF%A1%EF%BC%8C%E5%8C%85%E6%8B%AC%E5%BC%BA%E5%88%B6%E6%89%80%E6%9C%89%E8%BF%9E%E6%8E%A5%E4%BD%BF%E7%94%A8TLS%E7%9A%84%E8%83%BD%E5%8A%9B%E3%80%82

监控

使用开源https://github.com/CrunchyData/pgmonitor%E5%BA%93%E8%B7%9F%E8%B8%AAPostgreSQL%E9%9B%86%E7%BE%A4%E7%9A%84%E5%81%A5%E5%BA%B7%E7%8A%B6%E5%86%B5%E3%80%82

PostgreSQL用户管理

通过强大的命令快速添加和删除PostgreSQL集群中的用户。管理密码过期策略或使用您首选的PostgreSQL认证方案。

升级管理

安全应用PostgreSQL更新，对PostgreSQL集群的可用性影响最小。

高级复制支持

为对事务丢失敏感的工作负载选择https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/%E5%92%8Chttps://access.crunchydata.com/documentation/postgres-operator/latest/architecture/high-availability/#synchronous-replication-guarding-against-transactions-loss%E3%80%82

克隆

使用简单的https://access.crunchydata.com/documentation/postgres-operator/latest/pgo-client/reference/pgo_clone/%E5%91%BD%E4%BB%A4%E4%BB%8E%E7%8E%B0%E6%9C%89%E9%9B%86%E7%BE%A4%E5%88%9B%E5%BB%BA%E6%96%B0%E9%9B%86%E7%BE%A4%E3%80%82

连接池

使用https://access.crunchydata.com/documentation/pgbouncer/%E8%BF%9B%E8%A1%8C%E8%BF%9E%E6%8E%A5%E6%B1%A0%E5%8C%96

节点亲和性

将PostgreSQL集群部署到您偏好的https://kubernetes.io/docs/concepts/architecture/nodes/

定时备份

为每个PostgreSQL集群选择备份类型（完整、增量、差异）以及https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/disaster-recovery/#scheduling-backups%E3%80%82

备份到S3

https://access.crunchydata.com/documentation/postgres-operator/latest/architecture/disaster-recovery/#using-s3%E6%88%96%E4%BB%BB%E4%BD%95%E6%94%AF%E6%8C%81S3%E5%8D%8F%E8%AE%AE%E7%9A%84%E5%AF%B9%E8%B1%A1%E5%AD%98%E5%82%A8%E7%B3%BB%E7%BB%9F%E4%B8%AD%E3%80%82PostgreSQL Operator可以从这些备份进行备份、恢复和创建新集群。

多命名空间支持

您可以通过多种不同的部署模型控制PostgreSQL Operator如何利用https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/%EF%BC%9A

• 将PostgreSQL Operator和所有PostgreSQL集群部署到同一命名空间
• 将PostgreSQL Operator部署到一个命名空间，将所有PostgreSQL集群部署到另一个命名空间
• 将PostgreSQL Operator部署到一个命名空间，并跨多个命名空间管理PostgreSQL集群
• 使用pgo create namespace和pgo delete namespace命令动态添加和删除PostgreSQL Operator管理的命名空间

完全可定制性

Crunchy PostgreSQL Operator使您能够在支持Kubernetes的平台上轻松运行自己的PostgreSQL即服务，但我们知道您可能需要进一步的定制。因此，Crunchy PostgreSQL Operator允许您进一步定制部署，包括：

• 为主节点、副本和备份存储选择不同的存储类
• 为每个PostgreSQL集群部署选择自己的容器资源类；区分应用于主节点和副本集群的资源！
• 使用您自己的容器镜像仓库，包括支持imagePullSecrets和私有仓库
• https://access.crunchydata.com/documentation/postgres-operator/latest/advanced/custom-configuration
• 为Operator API服务器使用您自己的可信证书颁发机构（CA）
• 为每个集群覆盖PostgreSQL配置

工作原理

!https://access.crunchydata.com/documentation/postgres-operator/latest/Operator-Architecture.png

Crunchy PostgreSQL Operator扩展Kubernetes以提供更高级别的抽象，用于快速创建和管理PostgreSQL集群。Crunchy PostgreSQL Operator利用称为“https://kubernetes.io/docs/concepts/extend-kubernetes/api-extension/custom-resources/%E2%80%9D%E7%9A%84Kubernetes%E6%A6%82%E5%BF%B5%E6%9D%A5%E5%88%9B%E5%BB%BA%E5%A4%9A%E4%B8%AAhttps://kubernetes.io/docs/concepts/extend-kubernetes/api-extension/custom-resources/#customresourcedefinitions%EF%BC%8C%E5%85%81%E8%AE%B8%E7%AE%A1%E7%90%86PostgreSQL%E9%9B%86%E7%BE%A4%E3%80%82

支持的平台

Crunchy PostgreSQL Operator在以下平台上经过测试：

• Kubernetes 1.13+
• OpenShift 3.11+
• Google Kubernetes Engine（GKE），包括Anthos
• VMware Enterprise PKS 1.3+

存储

Crunchy PostgreSQL Operator已在各种Kubernetes存储和存储类上进行测试，包括：

• Rook
• StorageOS
• Google Compute Engine持久卷
• NFS
• HostPath

以及更多。我们已收到有关人们将PostgreSQL Operator与其他https://kubernetes.io/docs/concepts/storage/storage-classes/%E4%B8%80%E8%B5%B7%E4%BD%BF%E7%94%A8%E7%9A%84%E6%8A%A5%E5%91%8A%E3%80%82

我们知道Kubernetes有多种不同类型的https://kubernetes.io/docs/concepts/storage/storage-classes/%EF%BC%8C%E6%88%91%E4%BB%AC%E5%B0%BD%E6%9C%80%E5%A4%A7%E5%8A%AA%E5%8A%9B%E6%B5%8B%E8%AF%95%E6%AF%8F%E4%B8%80%E7%A7%8D%EF%BC%8C%E4%BD%86%E7%94%B1%E4%BA%8E%E8%AF%A5%E9%A2%86%E5%9F%9F%E7%9A%84%E5%B9%BF%E5%BA%A6%EF%BC%8C%E6%88%91%E4%BB%AC%E6%97%A0%E6%B3%95%E5%9C%A8%E6%AF%8F%E7%A7%8D%E5%AD%98%E5%82%A8%E7%B1%BB%E4%B8%AD%E9%AA%8C%E8%AF%81PostgreSQL Operator的功能。尽管如此，PostgreSQL Operator设计为与存储类无关，并已证明可与其他存储类一起使用。存储是Kubernetes中一个快速发展的领域，我们将继续使PostgreSQL Operator适应现代Kubernetes存储标准。

此容器由[***]