Greenplum on Kubernetes 容器化MPP数据库 AGENDA 云数据库背景 云数据库实现方案 Greenplum on Kubernetes Greenplum Operator 总结 云数据库背景 云数据库背景 ● 资源变化 ○ 本地资源 → 云 ○ 静态资源 → 弹性需求 ● 数据变化 ○ 内部数据 → 多数据源 ○ 数据规模 → 不易预测 ○ 数据格式 Kubernetes 计算资源 Pod ● Pod ○ 计算任务 → 容器 → Pod ○ 资源分配：CPU，内存，磁盘 ○ 资源调度：Pod → Node ● Pod管理 ○ 无状态计算资源组：Deployment ○ 有状态计算资源组：StatefulSet ● Pod持久存储 ○ 通过PVC申请PV存储资源 ● StatefulSet ○ Pod网络地址不变 ○ Pod与PV映射关系不变 Kubernetes Network Interconnect Standby Pod Master Pod Segment Pod Segment Instance Segment Pod Segment Instance Segment Pod Segment Instance Segment Pod Segment Instance Master StatefulSet (2)

© Copyright 2018 Pivotal Software, Inc. All rights Reserved. Kubernetes Operator for Massively Parallel Postgres Goutam Tadi (@goutamtadi) Senior Software Engineer, Pivotal Software Inc Email: gp-kubernetes@pivotal Agenda ● Intro to Greenplum ● Kubernetes 101 ● Greenplum for Kubernetes ○ Components ■ Greenplum Operator ■ Greenplum Cluster ● Demo Massively Parallel Postgres Greenplum Greenplum Data Platform ANALYTICAL Kubernetes Master Pod kubelet kube-proxy docker Node Pod kubelet kube-proxy docker Node Greenplum on Kubernetes 101 Kubernetes Master Pod kubelet kube-proxy docker Node Pod kubelet kube-proxy

Upgrade 301 Backing Up and Restoring a Database 305 Completing the Migration 306 Working With Hash Operator Classes in Greenplum 6 307 Enabling iptables (Optional) 308 Enabling iptables (Optional) 0 How Declaring Distribution Keys 735 Custom Distribution Key Hash Functions 736 Example Custom Hash Operator Class 736 Choosing the Table Storage Model 738 VMware Greenplum v6.19 Documentation VMware, Inc Expressions 882 Column References 883 Positional Parameters 883 Subscripts 884 Field Selection 884 Operator Invocations 885 Function Calls 885 Aggregate Expressions 885 Limitations of Aggregate Expressions

Upgrade 292 Backing Up and Restoring a Database 296 Completing the Migration 297 Working With Hash Operator Classes in Greenplum 6 297 Enabling iptables (Optional) 299 Enabling iptables (Optional) 0 How Declaring Distribution Keys 726 Custom Distribution Key Hash Functions 727 Example Custom Hash Operator Class 727 Choosing the Table Storage Model 729 VMware Greenplum v6.18 Documentation VMware, Inc Expressions 873 Column References 874 Positional Parameters 874 Subscripts 875 Field Selection 875 Operator Invocations 876 Function Calls 876 Aggregate Expressions 876 Limitations of Aggregate Expressions

Upgrade 226 Backing Up and Restoring a Database 229 Completing the Migration 230 Working With Hash Operator Classes in Greenplum 6 231 Enabling iptables (Optional) 232 Enabling iptables (Optional) 0 How Declaring Distribution Keys 658 Custom Distribution Key Hash Functions 659 Example Custom Hash Operator Class 659 Choosing the Table Storage Model 661 VMware Greenplum v6.17 Documentation VMware, Inc Expressions 805 Column References 806 Positional Parameters 806 Subscripts 807 Field Selection 807 Operator Invocations 808 Function Calls 808 Aggregate Expressions 808 Limitations of Aggregate Expressions

Backup 297 Backing Up and Restoring a Database 300 Completing the Migration 301 Working With Hash Operator Classes in Greenplum 6 301 Enabling iptables (Optional) 303 How to Enable iptables 303 Example Declaring Distribution Keys 724 Custom Distribution Key Hash Functions 725 Example Custom Hash Operator Class 725 Choosing the Table Storage Model 727 Heap Storage 727 Append-Optimized Storage 727 Expressions 874 Column References 875 Positional Parameters 875 Subscripts 876 Field Selection 876 Operator Invocations 877 Function Calls 877 Aggregate Expressions 877 Limitations of Aggregate Expressions

Functions 478 Backing Up and Restoring a Database 479 Completing the Migration 480 Working With Hash Operator Classes in Greenplum 6 480 Migrating from Open Source Greenplum Database to VMware Greenplum 482 Declaring Distribution Keys 563 Custom Distribution Key Hash Functions 564 Example Custom Hash Operator Class 564 Choosing the Table Storage Model 566 Heap Storage 566 Append-Optimized Storage 567 Expressions 793 Column References 794 Positional Parameters 794 Subscripts 794 Field Selection 795 Operator Invocations 795 Function Calls 796 Aggregate Expressions 796 Limitations of Aggregate Expressions

Functions 459 Backing Up and Restoring a Database 460 Completing the Migration 461 Working With Hash Operator Classes in Greenplum 6 461 Migrating from Open Source Greenplum Database to VMware Greenplum 463 Declaring Distribution Keys 534 Custom Distribution Key Hash Functions 535 Example Custom Hash Operator Class 535 Choosing the Table Storage Model 537 Heap Storage 537 Append-Optimized Storage 538 Expressions 764 Column References 765 Positional Parameters 765 Subscripts 765 Field Selection 766 Operator Invocations 766 Function Calls 767 Aggregate Expressions 767 Limitations of Aggregate Expressions

Functions 484 Backing Up and Restoring a Database 485 Completing the Migration 485 Working With Hash Operator Classes in Greenplum 6 486 Migrating from Open Source Greenplum Database to VMware Greenplum 487 Declaring Distribution Keys 558 Custom Distribution Key Hash Functions 558 Example Custom Hash Operator Class 559 Choosing the Table Storage Model 561 Heap Storage 561 Append-Optimized Storage 561 Expressions 785 Column References 785 Positional Parameters 786 Subscripts 786 Field Selection 786 Operator Invocations 787 Function Calls 787 Aggregate Expressions 788 Limitations of Aggregate Expressions

Functions 467 Backing Up and Restoring a Database 468 Completing the Migration 468 Working With Hash Operator Classes in Greenplum 6 469 Enabling iptables (Optional) 470 How to Enable iptables 471 Example Declaring Distribution Keys 537 Custom Distribution Key Hash Functions 538 Example Custom Hash Operator Class 538 Choosing the Table Storage Model 540 Heap Storage 541 Append-Optimized Storage 541 Expressions 757 Column References 758 Positional Parameters 758 Subscripts 758 Field Selection 759 Operator Invocations 759 Function Calls 760 Aggregate Expressions 760 Limitations of Aggregate Expressions