Tag - MySQL

Examining MySQL InnoDB Persistent Statistics

MySQL InnoDB Persistent Statistics

A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of information. Let’s do just that!
Let’s start with the good news. Unlike MySQL Data Dictionary Tables (mysql.table_stats, etc),  mysql.innodb_table_stats and […]

Read more

Webinar 1/16: How to Upgrade to MySQL 8 Like a Boss

Webinar How to Upgrade to MySQL 8

During this webinar, we will review the MySQL 8.0 upgrade process. In this deep dive session, we will review the latest version of MySQL 8.0, discuss upgrade challenges, bugs, gotchas and how to successfully upgrade to MySQL 8.0.  Please join Percona Senior Technical Manager Alkin Tezuysal on Thursday, January 16th at 9 am EST […]

Read more

Introduction to Vitess on Kubernetes for MySQL – Part I of III

Vitess on Kubernetes for MySQL 1

In this blog post series, we will discuss an overview of Vitess technology. Vitess is a database clustering solution for horizontal scaling of data sets currently suitable to 250Gb – 300Gb in sizes*. It’s a proven technology used by several web-scale companies including YouTube. PlanetScale is the company behind developing and supporting this open-sourced […]

Read more

How to Use ProxySQL 2 on Percona XtraDB Cluster for Failover

xtradbcluster

If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks.
How to Test
ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use the following list of hostnames and IPs for references:

Shell

+———–+—————-+
| node_name | ip […]

Read more