Planet MySQL

Displaying posts with tag: MySQL on AWS (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

2019

How to Setup a WordPress MySQL Database in the Cloud

Posted by ScaleGrid.io on Mon 29 Jul 2019 19:55 UTC
Tags:

database, Wordpress, cloud, High Availability, Developer, mysql server, howto, mysql client, localhost, mysql Database, MySQL, Wordpress MySQL, MySQL maintenance, MySQL version, MySQL Hosting, ScaleGrid, MySQL on AWS, MySQL Deployment, MySQL on Azure, MySQL Hostname, Automated Bcakups, Monitoring & Alerts, MySQL Database User, Scale On-Demand, Unlimited Databases, WordPress Data, WordPress Deployment, WordPress Developer, WordPress Sites, WordPress Website, WP Engine, wp-config

WordPress is the largest website builder platform in the world, supporting over 34% of all websites on the internet today. MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. As any WordPress developer knows, each installation requires a database in the backend, and MySQL is the database of choice for storing and retrieving your WordPress data.

In order for your WordPress website to be able to access, store and retrieve the data in your MySQL database, it needs to be hosted online through a cloud computing service. ScaleGrid offers a convenient way to setup and configure MySQL hosting for your …

[Read more]

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]

Top Authors

Oracle MySQL Blogs

Vendor Blogs

Search

MySQL Links