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]Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.…
Tweet Share
The MySQL Development Team is very happy to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.18.
In addition to major quality improvements, 8.0.18 brings some very useful features!
This blog post will only cover InnoDB cluster’s frontend and control panel – MySQL Shell and its AdminAPI – Stay tuned for other blog posts covering MySQL Router and Group Replication!…
Facebook Twitter LinkedIn
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with substantial improvements made by our development team.
Improvements and New Features
Galera 4, included in Percona XtraDB Cluster 8.0, has many new features. Here is a list of the most essential improvements:
- Streaming replication supports large transactions
- The synchronization functions allow action coordination (wsrep_last_seen_gtid, wsrep_last_written_gtid, wsrep_sync_wait_upto_gtid)
- More granular and improved error logging. wsrep_debug is now a multi-valued variable to assist in controlling the logging, and logging messages have been significantly improved. …
Overview
Clustering provides high availability and disaster recovery, along with the ability to read-scale both locally and globally. Some clusters even provide active/active capabilities, which others have a single master.
Real time database replication is a must for clustering and other key business purposes, like reporting. There are a number of replication technologies available for MySQL, and some are even bundled into various solutions. When choosing a replication methodology, it is paramount to understand just how the data moves from source to target. In this blog post, we will examine how asynchronous, synchronous, and “semi-synchronous” replication behave when used for clustering. Also, we will explore how …
[Read more]We’re happy to announce that our white paper ‘Tungsten Clustering – Benefits & Configurations’ for MySQL, MariaDB and Percona Server is available to read on our website.
Tungsten Clustering is a one-of-a-kind software solution that provides clustering, disaster recovery and high availability for MySQL, MariaDB & Percona Server databases.
It allows enterprises running business-critical database applications to cost-effectively achieve continuous operations on a global scale with:
- Commercial-grade high availability (HA)
- Geographically redundant disaster recovery (DR)
- Global operations with geographically distributed multi-master
…
[Read more]This presentation is a summary of the MySQL 8.0.17 new features.
The post MySQL 8.0.17 - New Features Summary first appeared on dasini.net - Diary of a MySQL expert.
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the following:
- Percona Server for MySQL 5.7.27-30
- Codership WSREP API release 5.7.27
- Codership Galera library 3.28
All Percona software is open-source and free.
Bugs Fixed
- PXC-2432: PXC was not …
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the following:
- Percona Server 5.6.45-86.1
- Codership WSREP API release 5.6.44
- Codership Galera library 3.28
All Percona software is open-source and free.
Bugs Fixed
- PXC-2432: PXC was not updating …
In MySQL 8.0.17 there have been a lot of updates to the MySQL set of offerings. We’ve introduced Cloning into InnoDB Cluster 8.0.17, advances with the MySQL-Router in 8.0.17 and MySQL continues to expand its collection of automation managed features. When Group Replication was first introduced in MySQL 5.7.17, there was considerably less to manage… Read More »