postgresql high availability

A few days ago, we used Heartbeat as a solution for the high-availability service architecture. Today we have tested a brand new solution that uses Keepalived to implement this function. Keepalived is a high-performance high-availability or hot standby solution for servers.

This article will cover another high-availability implementation of MySQL, namely MHA (Masterhigh avaliable). Master HA. is an open source high-availability program that provides MySQL's master-slave architecture with the ability to automatically recover from failures. I. Introduction of BASIC knowledge 1. MHA definit

Mysql high-availability architecture solution II (keepalived + lvs + read/write splitting + Server Load balancer)Mysql master-slave replication and lvs + keepalived for high load availabilityDirectory1. Preface 42. Principle 42.1 Overview 42.2 Working Principle 42.3. Actual purpose 43 solution 43.1. Environment 43.2 architecture 53.3 Design Principle 64. Install

Redis High-availability architecture best Practices First, preface May 13, 2017, the application performance Management auditorium Guangzhou station successfully ended, among them from 37 Mutual entertainment DBA Wen in the venue and you have a wonderful Redis technology sharing. Redis is an open source API that is written in ANSI C, supports the web, can be persisted in memory, key-value databases, and

??Now there are a lot of domestic users of the availability of cloud services misunderstanding, what kind of misunderstanding? For example, a cloud service provider, there is a room in South China, there is a computer room in east China.The customer mentions a requirement, what do you mean by the concept of 99% usability? Is there something wrong with my machine in the Southern engine room? My machine on its own initiative to transfer to East China co

Master-slave replication of mysql databases is relatively simple, but it is also a basis for the high availability of mysql databases, in my understanding, the high availability of all mysql Databases evolved from this master database and from simple replication. This blog is written because Master-slave replication of

Create DagConfigure the Database Availability GroupSelect the database Availability group, click the plus sign to create the database availability Group;650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/83/E4/wKioL1d_RSbysHqmAABWN7lOIJA378.jpg "/>Enter the database availability group name, witness server, and

, the 11.2.0.1 RAC that is installed on the virtual machine is chosen 11.2.0.1 because of problems with public IP and private network segments. During the installation instance, the computer crashes and restarts, and CRS fails to start. [Root@rac1 bin]#./crsctlstart CRS Crs-4124:oracle highavailability Services startup failed. Crs-4000:command startfailed, or completed with errors. [Root@rac1 bin]# Ps-ef|grep has Root 8081 1 0 03:14? 00:00:00/u01/app/grid/11.2.0/bin/ohasd.bin reboot Root 8137

Label:MMM (master-master Replication Manager for MySQL) MySQL Master Replication Manager provides a scalable suite of scripts for monitoring, failover, and management of MySQL master replication configuration. In the MMM high-availability solution, the typical application is a dual-master multi-Slave architecture, through the MySQL replication technology can realize two server mutual primary from, and at an

Tags: pxc mysql high-availability cluster architectureSome time ago, Lao Zhang introduced the mainstream MySQL high-availability Cluster Architecture trilogy in the first two parts, there are students who do not know to visit my previous blog content.First through train >> MySQL mainstream

Tags: operations will be architected Roo database middleware Data source configuration master-slave min hardware and softwareDatabase High Availability ScenariosLow-read low-write concurrency, low data volume scheme Scenario One: Dual-machine high-availability solutions 1. Database Schema diagram 2. Features A machine