Planet MySQL

Displaying posts with tag: multi-threaded slaves (reset)

Jan

2019

MySQL High Availability Framework Explained – Part II: Semisynchronous Replication

Posted by ScaleGrid.io on Tue 08 Jan 2019 17:43 UTC
Tags:

sql, Learning, database, cloud, High Availability, data, Developer, howto, mysql replication, CAP Theorem, data consistency, MySQL, Performance, node, mysql high availability, synchronous replication, mysql deployments, asynchronous replication, MySQL settings, replica set, replication lag, semisynchronous replication, multi-threaded slaves, SQL thread, MySQL Hosting, HA Framework, High Availability Framework, Binary Log Entries, Execution Speed, Failover Process, Master-Slave Configuration, MySQL Master, MySQL Slaves, Network Partition, Parallel Threads, Single-Threaded Slaves

In Part I, we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Now in Part II, we will discuss the details of MySQL semisynchronous replication and the related configuration settings that help us ensure redundancy and consistency of the data in our HA setup. Make sure to check back in for Part III where we will review various failure scenarios that could arise and the way the framework responds and recovers from these conditions.

What is MySQL Semisynchronous Replication?

Simply put, in a …

[Read more]

Jul

2018

Data Integrity and Performance Considerations in MySQL Semisynchronous Replication

Posted by ScaleGrid.io on Wed 11 Jul 2018 13:54 UTC
Tags:

High Availability, Developer, howto, mysql performance, MySQL, Performance, node, replica set, 3-Node Replica Set, asynchronous mode, Configurations on the Master Node, Configurations on the Slave Node, Data Consistency in MySQL, high data integrity, InnoDB Storage Engine, master binary logs, multi-threaded slaves, MySQL Configurations, MySQL Data Integrity, MySQL Master Node, MySQL replica set, MySQL restart, MySQL Semisynchronous Replication, MySQL Slave Node, slave SQL thread performance, SQL thread, SQL thread workers

MySQL semisynchronous replication provides improved data integrity because when a commit returns successfully, it’s known that the data exists in at least two places – the master and its slave. In this blog post, we review some of the MySQL hosting configurations that influence the data integrity and performance aspects of semisynchronous replication. We’ll be using InnoDB storage engine and GTID-based replication in a 3-node replica set (master and 2 slaves), which will ensure there is redundancy in the slaves. This means that if there are issues with one slave, we can fall back on the other.

Configurations Applicable to Both Master and Slave Nodes

…[Read more]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links