Showing entries 1 to 10 of 235
10 Older Entries »
Displaying posts with tag: High Availability (reset)
Introducing MySQL InnoDB Cluster – A Hands-On Tutorial

Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).…

Introducing MySQL InnoDB Cluster – Demo Video

Today we are introducing a new MySQL feature called MySQL InnoDB Cluster. Make sure to watch the demo video on the MySQL YouTube Channel!

Find out more by looking into the MySQL InnoDB Cluster documentation.

If you got questions or feedback please feel free to post on the MySQL Forums.…

Introducing MySQL InnoDB Cluster – MySQL HA: Out-of-Box, Easy to use High Availability

Introducing the new MySQL InnoDB Cluster Feature

MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.…

MySQL Group Replication for MySQL 5.7.15

Hi all, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere support to MySQL, like we described in the Hello World post.

We are very proud to present the eighth preview release of MySQL Group Replication plugin, based on MySQL Server 5.7.15.…

Consul, ProxySQL and MySQL HA

When it comes to “decision time” about which type of MySQL HA (high-availability) solution to implement, and how to architect the solution, many questions come to mind. The most important questions are:

  • “What are the best tools to provide HA and Load Balancing?”
  • “Should I be deploying this proxy tool on my application servers or on a standalone server?”.

Ultimately, the best tool really depends on the needs of your application and your environment. You might already be using specific tools such as Consul or MHA, or you might be looking to implement tools that provide richer features. The dilemma of deploying a proxy instance per application host versus a standalone proxy instance is usually a trade-off between “a less effective load balancing algorithm” or “a single point of failure.” Neither are desirable, but there are ways to implement a solution that balances all …

[Read more]
ProxySQL and Percona XtraDB Cluster (Galera) Integration

In this post, we’ll discuss how an integrated ProxySQL and Percona XtraDB Cluster (Galera) helps manage node states and failovers.

ProxySQL is designed to not perform any specialized operation in relation to the servers with which it communicates. Instead, it uses an event scheduler to extend functionalities and cover any special needs.

Given that specialized products like Percona XtraDB Cluster are not managed by ProxySQL, they require the design and implementation of good/efficient extensions.

In this article, I will illustrate how Percona XtraDB Cluster/Galera can be integrated with ProxySQL to get the best from both.

Brief digression

Before discussing their integration, we need to review a couple of very important concepts in ProxySQL. ProxySQL has a very important logical component: Hostgroup(s) (HG).

A hostgroup is a relation …

[Read more]
OpenStack Days East — MySQL Options in OpenStack

I recently had the pleasure of attending the first OpenStack Days East conference in NYC. This was the first OpenStack Days event that we’ve had on the East Coast of the US, but I hope that it’s the first of many!…

MySQL Group Replication: securing the perimeter!

Hi all, here is a new post following the blog series on the last MySQLvGroup Replication labs release which already presented: 1) the new features; 2) most asked questions; 3) summary of behaviour and configuration changes; and 4) the performance improvements.…

MySQL Failover, Enhanced MySQL Utilities

This blog is a 2nd part of a multi-part series on areas of  failover for MySQL.  The first installment looked at design considerations, giving us a “thinking” perspective on what we might want to adopt.  Later I will take a look at more of a business and operational way of thinking through these details.  In… Read More »

Tuning MySQL Group Replication for fun… and profit!

Group Replication introduces a new way to do replication in MySQL. With great features such as multi-master replication it brings a range of exciting deployment scenarios where some difficult problems become much easier to solve. Group Replication also brings a new set of options that may need to be configured to extract the highest performance from the underlying computing resources.…

Showing entries 1 to 10 of 235
10 Older Entries »