方案，方便网友学习以及验证，希望对大家学习 mysql 高可用有所帮助。这也是本文档 的目的所在 由于本人经验和水平有限，有不对之处烦请指出，多交流，互相帮助，共同进步。 下面的几种高可用方案在 Centos 5.5 64bit /mysql 5.1.63 环境测试通过。 目前 Mysql 的高可用主要有 Lvs+Keepalived、Heartbeat、MMM、mysql cluster 三种方式， 实战环境介绍 服务器名 IP VIP 系统 Mysql Master 10.1.1.113 10.1.1.176 Centos 5.5 64bit 5.1.63 Backup 10.1.1.75 10.1.1.176 Centos 5.5 64bit 5.1.63 2.4.3 Mysql 的安装和配置 Mysql 的安装和配置相对来讲非常简单，这里就不做介绍，有兴趣的朋友 VIP 系统 Mysql Master 10.1.1.113 10.1.1.176 10.1.1.177 Centos 5.5 64bit 5.1.63 Backup 10.1.1.75 10.1.1.176 10.1.1.177 Centos 5.5 64bit 5.1.63 3.5.2 Mysql 的安装和配置 Mysql 的安装和配置相对来讲非常简单，这里就不做介绍，有兴趣的朋友可

Playbook 314 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 315 Greenplum Database Cloud Technical Recommendations 317 Operating System 317 Storage 317 Enterprise Linux 64-bit 7.x (See the following Note.) Red Hat Enterprise Linux 64-bit 6.x CentOS 64-bit 7.x CentOS 64-bit 6.x Ubuntu 18.04 LTS Oracle Linux 64-bit 7, using the Red Hat Compatible Kernel group-based workload management on RedHat 6.x and CentOS 6.x systems. This issue is caused by a Linux cgroup kernel bug. This kernel bug has been fixed in CentOS 7.x and Red Hat 7.x systems. VMware Greenplum

Playbook 304 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 305 Greenplum Database Cloud Technical Recommendations 308 Operating System 308 Storage 308 Enterprise Linux 64-bit 7.x (See the following Note.) Red Hat Enterprise Linux 64-bit 6.x CentOS 64-bit 7.x CentOS 64-bit 6.x Ubuntu 18.04 LTS Oracle Linux 64-bit 7, using the Red Hat Compatible Kernel group-based workload management on RedHat 6.x and CentOS 6.x systems. This issue is caused by a Linux cgroup kernel bug. This kernel bug has been fixed in CentOS 7.x and Red Hat 7.x systems. VMware Greenplum

PGCLIENTENCODING 495 Example Ansible Playbook 495 Ansible Playbook - Greenplum Database Installation for CentOS 7 496 Greenplum Database Security Configuration Guide 498 Securing the Database 499 Accessing resolves several issues. Features Greenplum Database 6.14.0 includes these new and changed features: CentOS/RHEL 8 and SUSE Linux Enterprise Server x86_64 12 (SLES 12) Clients packages are available with version 1.13. To support this change on RHEL/CentOS 6 platforms, the Greenplum Database package now requires libevent2 instead of libevent. RHEL/CentOS 7 requirements are unchanged. See the PgBouncer

PGCLIENTENCODING 476 Example Ansible Playbook 476 Ansible Playbook - Greenplum Database Installation for CentOS 7 477 Greenplum Database Security Configuration Guide 479 Securing the Database 480 Accessing resolves several issues. Features Greenplum Database 6.14.0 includes these new and changed features: CentOS/RHEL 8 and SUSE Linux Enterprise Server x86_64 12 (SLES 12) Clients packages are available with version 1.13. To support this change on RHEL/CentOS 6 platforms, the Greenplum Database package now requires libevent2 instead of libevent. RHEL/CentOS 7 requirements are unchanged. See the PgBouncer

} } 快速上⼿ Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 20/206 ODBC⽅式连接 ⽅式连接 Linux操作系统：CentOS 6.5 64位 1. 安装 postgresql odbc驱动 # yum install postgresql-odbc.x86_64 -y 2. 编辑/etc/odbcinst.ini⽂件，配置odbc驱动 UCloud 优刻得 22/206 如出现以上内容，则表⽰psqlodbc配置成功。 其他⽅式 其他⽅式 1.udw客⼾端的⽅式访问 1.1 udw（greenplum）客⼾端⽅式访问（以Centos为例） 如果你选择的数据仓库类型是greenplum、可以采⽤下⾯的⽅式访问 1）下载greenplum客⼾端解压 快速上⼿ Greenplum数据仓库 UDW Copyright © 2012-2021 nt的安装路径 4） 连接数据库 psql -h hostIP（或域名） –U username -d database -p port –W 1.2 udw（udpg）客⼾端⽅式访问（以Centos为例） 如果你选择的数据仓库类型是udpg、可以采⽤下⾯的⽅式访问 快速上⼿ Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 24/206

PGCLIENTENCODING 473 Example Ansible Playbook 473 Ansible Playbook - Greenplum Database Installation for CentOS 7 474 Greenplum Database Security Configuration Guide 477 VMware Tanzu Greenplum 6 Documentation resolves several issues. Features Greenplum Database 6.14.0 includes these new and changed features: CentOS/RHEL 8 and SUSE Linux Enterprise Server x86_64 12 (SLES 12) Clients packages are available with version 1.13. To support this change on RHEL/CentOS 6 platforms, the Greenplum Database package now requires libevent2 instead of libevent. RHEL/CentOS 7 requirements are unchanged. See the PgBouncer

Playbook 238 Example Ansible Playbook 0 Ansible Playbook - Greenplum Database Installation for CentOS 7 239 Greenplum Database Cloud Technical Recommendations 241 Operating System 241 Storage 241 Enterprise Linux 64-bit 7.x (See the following Note.) Red Hat Enterprise Linux 64-bit 6.x CentOS 64-bit 7.x CentOS 64-bit 6.x Ubuntu 18.04 LTS Oracle Linux 64-bit 7, using the Red Hat Compatible Kernel group-based workload management on RedHat 6.x and CentOS 6.x systems. This issue is caused by a Linux cgroup kernel bug. This kernel bug has been fixed in CentOS 7.x and Red Hat 7.x systems. If you use RedHat

PGCLIENTENCODING 308 Example Ansible Playbook 309 Ansible Playbook - Greenplum Database Installation for CentOS 7 310 Greenplum Database Cloud Technical Recommendations 312 VMware Tanzu Greenplum v6.20 Documentation Enterprise Linux 64-bit 7.x (See the following Note.) Red Hat Enterprise Linux 64-bit 6.x CentOS 64-bit 7.x CentOS 64-bit 6.x Ubuntu 18.04 LTS Oracle Linux 64-bit 7, using the Red Hat Compatible Kernel group-based workload management on RedHat 6.x and CentOS 6.x systems. This issue is caused by a Linux cgroup kernel bug. This kernel bug has been fixed in CentOS 7.x and Red Hat 7.x/8.x systems. VMware Tanzu

PGCLIENTENCODING 401 Example Ansible Playbook 401 Ansible Playbook - Greenplum Database Installation for CentOS 7 402 Greenplum Database Security Configuration Guide 404 Securing the Database 404 Accessing resolves several issues. Features Greenplum Database 6.14.0 includes these new and changed features: CentOS/RHEL 8 and SUSE Linux Enterprise Server x86_64 12 (SLES 12) Clients packages VMware Tanzu Greenplum version 1.13. To support this change on RHEL/CentOS 6 platforms, the Greenplum Database package now requires libevent2 instead of libevent. RHEL/CentOS 7 requirements are unchanged. See the PgBouncer