Planet MySQL

Displaying posts with tag: Resource Agent (reset)

Apr

2019

MySQL High Availability Framework Explained – Part III: Failure Scenarios

Posted by ScaleGrid.io on Tue 16 Apr 2019 13:42 UTC
Tags:

sql, database, cloud, High Availability, Developer, howto, Pacemaker, Corosync, data consistency, MySQL, Performance, node, MySQL Crash, mysql high availability, slave promotion, replica set, MySQL Service, MySQL Semisynchronous Replication, MySQL Hosting, MySQL on AWS, HA Framework, High Availability Framework, Resource Agent, Network Partition, MySQL on Azure, Split Brain Scenario, 3-Node Cluster, Application Writes, Master MySQL, Master MySQL Goes Down, MySQL Failover Scenarios, Network Connectivity Breaks, Received Transactions, Restart MySQL, Slave MySQL Goes Down, Slave Nodes, Transactions Committed

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability.

MySQL Failure Scenarios Scenario 1 – Master MySQL Goes Down

The Corosync and Pacemaker framework detects that the master MySQL is no longer available. Pacemaker demotes the master resource and tries …

[Read more]

Nov

2018

MySQL High Availability Framework Explained – Part I

Posted by ScaleGrid.io on Thu 29 Nov 2018 16:39 UTC
Tags:

sql, database, cloud, High Availability, data, Developer, restore, Pacemaker, software stack, Corosync, MySQL, node, mysql high availability, replica set, semisynchronous replication, MySQL Semisynchronous Replication, MySQL Hosting, ScaleGrid, Aggregation Framework, Availability %, Correction Mechanism, data redundancy, DNS mapping, Downtime Per Year, Failover Mechanism, Failure Detection, HA Framework, High Availability Framework, infrastructure hosting, primary system, Redirection Mechanism, Redundancy in Infrastructure, Resource Agent, standby systems, user connections, What is High Availability

In this three-part blog series, we will explain the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. In Part I, we’ll walk you through the basics of High Availability, the components of an HA framework, and then introduce you to the HA framework for MySQL.

What is High Availability?

The availability of a computer system is the percentage of time its services are up during a period of time. It’s generally expressed as a series of 9′s. For example, the table below shows availability and the corresponding downtime measured over one year.

Availability %

…

[Read more]

Top Authors

Oracle MySQL Blogs

Team Blogs

Vendor Blogs

Search

MySQL Links