Planet MySQL

Displaying posts with tag: 3-Node Replica Set (reset)

Oct

2019

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

Posted by ScaleGrid.io on Thu 24 Oct 2019 16:03 UTC
Tags:

sql, database, amazon, cloud, High Availability, Testing, Developer, Benchmarks, aws, cloud infrastructure, queries per second, Amazon RDS, MySQL configuration, MySQL, Performance, mysql deployments, replica set, replication lag, open source database, Read Replica, 3-Node Replica Set, MySQL Hosting, ScaleGrid, Compare MySQL Providers, MySQL on AWS, MySQL AWS, MySQL Instances, #1 Cloud Provider, 95th Percentile Latency, AWS High Performance Instances, Balanced Workload, EBS Data Disk, EC2 Instance, High Latency, Higher Throughput, Local SSD, Low Throughput, Lower Latency, Multi-AZ Deployment, MySQL AWS Performance, MySQL RDS, MySQL RDS Performance, MySQL RDS Pricing, Read-Intensive, ScaleGrid MySQL, ScaleGrid vs. Amazon RDS, Write-Intensive

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. As organizations continue to migrate to the cloud, it’s important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure. While many AWS users default to their managed database solution, Amazon RDS, there are alternatives available that can improve your MySQL performance on AWS through advanced customization options and unlimited EC2 instance type support. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS. In this post, we compare the performance of MySQL Amazon RDS …

[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