MySQL high availability

Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP

ProxySQL for connection pooling

Please join Percona’s Architect, Tibi Köröcz as he presents Utilizing ProxySQL for Connection Pooling in PHP on Tuesday August 14, 2018, at 8:00 am PDT (UTC-7) / 11:00 am EDT (UTC-4).   Register Now ProxySQL is a very powerful tool, with extended capabilities. This presentation will demonstrate how to use ProxySQL to gain functionality (seamless […]

The post Webinar Tues 8/14: Utilizing ProxySQL for Connection Pooling in PHP appeared first on Percona Database Performance Blog.

Amazon RDS Multi-AZ Deployments and Read Replicas

RDS Multi-AZ

Amazon RDS is a managed relational database service that makes it easier to set up, operate, and scale a relational database in the cloud. One of the common questions that we get is “What is Multi-AZ and how it’s different from Read Replica, do I need both?”.  I have tried to answer this question in this […]

The post Amazon RDS Multi-AZ Deployments and Read Replicas appeared first on Percona Database Performance Blog.

Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2

webinar Percona XtraDB Cluster

Including setting up Percona XtraDB Cluster with ProxySQL and PMM Please join Percona’s Architect, Tibi Köröcz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Register Now   Never used Percona XtraDB Cluster before? This is the webinar for […]

The post Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2 appeared first on Percona Database Performance Blog.

Webinar Tues 19/6: MySQL: Scaling and High Availability – Production Experience from the Last Decade(s)

scale high availability

Please join Percona’s CEO, Peter Zaitsev as he presents MySQL: Scaling and High Availability – Production Experience Over the Last Decade(s) on Tuesday, June 19th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   Percona is known as the MySQL performance experts. With over 4,000 customers, we’ve studied, mastered and […]

The post Webinar Tues 19/6: MySQL: Scaling and High Availability – Production Experience from the Last Decade(s) appeared first on Percona Database Performance Blog.

Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together

Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy […]

The post Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together appeared first on Percona Database Performance Blog.

Announcing Galera Cluster Security Release for MySQL 5.5.59, 5.6.39, 5.7.21 with Galera 3.23.

Codership is pleased to announce the release of Galera Replication library 3.23, implementing wsrep API version 25.
This release incorporates all changes up to MySQL 5.7.21, MySQL 5.6.39 and MySQL 5.5.59, including several fixes to vulnerabilities reported by Oracle in here.
New features and notable fixes in Galera replication since last binary release
by Codership (3.22):

Write set serialization has been changed to use proper memory alignment in order to avoid crashes on platforms which do not allow unaligned memory access (http://www2.galeracluster.com/e/38852/codership-galera-issues-445/88b8yp/875788176)

 
Notable bug fixes in MySQL 5.7.21:

Changing the variable wsrep_slave_threads was not effective after
a node drops from the cluster and then joins back(http://www2.galeracluster.com/e/38852/dership-mysql-wsrep-issues-319/88b8yr/875788176)

 
Notable bug fixes in 5.6.39 :

Changing the variable wsrep_slave_threads was not effective after
a node drops from the cluster and then joins back(http://www2.galeracluster.com/e/38852/dership-mysql-wsrep-issues-319/88b8yr/875788176)

 
READ THE RELEASE NOTES:
Galera Replication library 3.23
MySQL-wsrep 5.5.59
MySQL-wsrep 5.6.39
MySQL-wsrep 5.7.21
 
 
 

Bulgarian National Lottery chooses Galera Cluster

“We wanted a solution which was backward compatible with our frameworks, as we have used mainly MySQL, which was reliable and nearly 100% data consistent.  If our application were to execute a commit and receive a successful response, we needed a 100% guarantee that we have rows of data in our database — and for more than that one instance.”
There were many options E-CARD explored. “First, we tried MySQL NDB Cluster. That was a very frustrating experience. After that we tried a few other plugins and extensions of MySQL, but they weren’t complete solutions. At the end of this process, we found Galera with MySQL. It responded to our needs nearly 100% of the time.”
 
Read the full story
Bulgarian National Lottery chooses Galera Cluster

Announcing Galera Cluster for MySQL 5.5.58, 5.6.38, 5.7.20 with Galera 3.22.

Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.5.58, 5.6.38, 5.7.20 and new Galera 3.22 library, wsrep API version 25.
 

NEW FEATURES AND NOTABLE FIXES IN THE GALERA REPLICATION LIBRARY SINCE LAST BINARY RELEASE BY CODERSHIP (3.21):

 
New features and notable fixes in Galera replication since last binary release
* Reporting last committed write set fixed to respect commit ordering (MW-341)
* GComm socket level error handling improved to avoid backend thread exit
in case of unexpected input from ASIO IO service (GAL-518)
* Race condition fixed in GComm message sending codepath (GAL-520)
* Fix for EVS protocol stall due to exhausted send window setting. This
bug could stall cluster messaging until the next keepalive was sent by
some node, causing intermittent pauses in write set replication. (GAL-521)
* Code changes to avoid name collisions with FreeBSD system headers (GAL-523)
Read the full release notes (how to install, repository structure) 
 
 
NOTABLE BUG FIXES IN MYSQL-WSREP:
 
Version MySQL-wsrep 5.7.20 and Galera 3.22, wsrep API version 25.
* Preserve –wsrep-recover log for future reference when starting the server.
The preserved log is stored in a file under MySQL data directory,
either in wsrep_recovery.ok or wsrep_recovery.fail depending on recovery
success. (MW-318)
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* A bug which caused stored procedure with an error handler to commit
a statement even in case of certification error was fixed. (MW-388)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixed a crash caused by a dangling reference to wsrep status variables
array. (MW-399)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
* ALTER EVENT statement failure on slave was fixed (MW-417)
Read the full release notes  (known issues, how to install, repository structure) 
 
 
Version MySQL-wsrep 5.6.38 and Galera 3.22, wsrep API version 25
* Preserve –wsrep-recover log for future reference when starting the server.
The preserved log is stored in a file under MySQL data directory,
either in wsrep_recovery.ok or wsrep_recovery.fail depending on recovery
success. (MW-318)
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* A bug which caused stored procedure with an error handler to commit
a statement even in case of certification error was fixed. (MW-388)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixed a crash caused by a dangling reference to wsrep status variables
array. (MW-399)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
Read the full release notes (known issues, how to install, repository structure)

 
 
Version MySQL-wsrep 5.5.58 and Galera 3.22, wsrep API version 25
Notable bug fixes in MySQL-wsrep:
* Avoid returning outdated values for wsrep_ready status variable (MW-384)
* Crash during LOAD DATA for partition engine was fixed (MW-394)
* Fixes to processing of foreign key cascades. (MW-402)
* ACL checks are now enforced before replication for all DDL operations
(MW-416)
Read the full release notes (known issues, how to install, repository structure)
 

Joint Webinar with Severalnines: How to manage Galera Cluster using ClusterControl

Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.
ClusterControl is the go-to automation and management system for Galera Cluster users.
And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.
We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).

AGENDA
Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of ClusterControl
What’s new with Galera Cluster
Core feature set overview
What’s coming up
ClusterControl for Galera Cluster
Deployment
Monitoring
Management
Scaling
Live Demo
Q&A
 
Join EMEA timezone webinar Tue November 14, 10 AM CET
 
Join USA timezone webinar Tue November 14, 9 AM PST
 
Presenting:
Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.
Seppo Jaakola, Codership CEO

Joint Webinar with Severalnines: How to manage Galera Cluster using ClusterControl

Since its creation, Galera Cluster has established itself as the most popular high availability solution for MySQL and MariaDB users worldwide.
ClusterControl is the go-to automation and management system for Galera Cluster users.
And together, we’re going to walk you through all the different aspects that make Galera Cluster such a popular high availability solution for MySQL and MariaDB and how to best manage it with ClusterControl.
We’ll hear about the latest features of Galera Cluster directly from Codership, the creators of Galera Cluster. And we’ll look at how to automate everything from deployment, monitoring (how about ASCII-art graphs?), backups, failover, recovery, rolling upgrades and scaling using the ClusterControl CLI (for a change, we also have a GUI of course).
AGENDA
Introduction
About Codership, the makers of Galera Cluster
About Severalnines, the makers of ClusterControl
What’s new with Galera Cluster
Core feature set overview
What’s coming up
ClusterControl for Galera Cluster
Deployment
Monitoring
Management
Scaling
Live Demo
Q&A
 
Join EMEA timezone webinar Tue November 14, 10 AM CET
 
Join USA timezone webinar Tue November 14, 9 AM PST
 
Presenting:
Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.
Seppo Jaakola, Codership CEO
 

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569