Showing entries 1 to 10 of 37586
10 Older Entries »
Improved wsrep-stages and related instrumentation in Percona XtraDB Cluster

In this blog post, we’ll look at how we’ve improved wsrep-stages and related instrumentation in Percona XtraDB Cluster.

Introduction

When you execute a workload and need to find out what the given thread is working on, “SHOW PROCESSLIST” comes to the top of your mind. It is an effective way to track the thread status. We decided to improve the stages in Percona XtraDB Cluster to make “SHOW PROCESSLIST” more meaningful.

In the blog below, we will check out the different wsrep-stages and the significance associated with them.

Loading of data

Running a simple insert/sysbench prepare workload. The state is stable as it mainly captures …

[Read more]
Open Source DBA Ethos

I’m in Santa Clara at the Percona Live Conference and Expo.  I have been here less than 24 hours, but I have already had conversations with many fellow DBAs, some that I have met and worked with before, and others whom I am meeting for the first time.  It has been three years since my last visit, but being here shows you that as an Open Source DBA, you’re in sort of a “big family” of like minded, top notch, professionals.

I am proud to be an open source DBA because of our apparent values, values you see in almost everyone when you come to an event like this.

Who are we as Open Source DBAs ?

  • We are system experts.  Open source DBAs know their operating system.  They are not only focused on the database.
  • We are developers.  We contribute to source code within …
[Read more]
Come See VividCortex at Percona Live This Week!

We're thrilled it's finally that time of year: Percona Live 2017! This event is among the most important in the database community—there no other conference like it, where you can find such a meeting of industry leaders, gathered to discuss open-source databases and monitoring.

“Open-source communities fuel much of today’s data innovation," said Baron  Schwartz, VividCortex's founder and CEO. "If you want to be at the forefront of the ever-evolving data performance landscape, then Percona Live is the place to be. We’re looking forward to meeting up with the brightest minds who are charting the future of the high-performance data tier. I always come away from this event energized and excited about the huge opportunity we have to work cross-industry and to make a meaningful impact on business performance, as digital transformation through data fluency becomes an engine for growth and competitive advantage.”

[Read more]
MySQL 8.0 Collations: Migrating from older collations

From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb4_0900_ai_ci. MySQL 8.0 is also coming with a whole new set of Unicode collations for the utf8mb4 character set.

This will allow use of the complete Unicode 9.0.0 character set in MySQL, and for new applications this is great news.…

39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey

Galera Cluster is the most used high availability solution for OpenStack components and datastore for the third year in the row according to recent OpenStack survey. Since last year the deployments of all Galera Cluster have increased 5 points.  39% of the OpenStack users report that they use Galera Cluster in production. The number includes MariaDB Galera Cluster, Galera Cluster for MySQL and Percona XtraDB Cluster. MariaDB Galera Cluster ranks now number one database solution before MariaDB, MySQL and MongoDB.

READ THE FULL REPORT (page 47)

Webinar Replay and Q&A: High Availability in ProxySQL for HA MySQL infrastructures

Thanks to everyone who participated in our recent webinar on High Availability in ProxySQL and on how to build a solid, scalable and manageable proxy layer using ProxySQL for highly available MySQL infrastructures.

This second joint webinar with ProxySQL creator René Cannaò saw lots of interest and some nice questions from our audience, which we’re sharing below with this blog post as well as the answers to them.

Building a highly available proxy layer creates additional challenges, such as how to manage multiple proxy instances, how to ensure that their configuration is in sync, Virtual IP and fail-over; and more, which we’ve covered in this webinar with René. And we demonstrated how you can make your ProxySQL highly available when deploying it from ClusterControl (download & try it free).

If you missed …

[Read more]
Handy stored procedure for regular DBA tasks

As a stored procedures fan, I use MySQL stored procedures to get some of my DBA tasks accomplished. To make it simple, I have a template stored procedure that can be customized for several purposes.
The template syntax contains cursor, continue handler, loop, if condition and prepared statement. Thought it may be useful for others – at least, who are searching for the MySQL Stored Procedure syntax – so I’m publishing this post!

Use case: Reorganize tables partition:

In MySQL Cluster, it is required to reorganize all NDB tables’ partitions after adding new data nodes to rebalance the data across all nodes. Also the tables need to be optimized afterwards to reclaim the memory space. For this task I use the following procedure:

DROP PROCEDURE IF EXISTS reorganize_tables;
DELIMITER //
CREATE PROCEDURE reorganize_tables (IN db_name VARCHAR(50))
BEGIN

[Read more]
Releasing ProxySQL 1.4.0

Releasing ProxySQL 1.4.0 (beta)

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!
Today I am excited to announce the release of ProxySQL 1.4.0, the first beta release of series 1.4.x .
All ProxySQL versions 1.3.x will be mostly bug fixes releases, and unlikely will introduce new features: all the new features will go into ProxySQL 1.4.x .
This also mean that if you are using ProxySQL in production, you should continue using 1.3.x .
Instead, if you are not using ProxySQL in production yet, I strongly recommend trying 1.4.0 and report bugs if you find any.

It can be downloaded here, and freely usable and accessible according to GPL license.
Please report any bugs or feature requests on github …

[Read more]
Improving the Parallel Applier with Writeset-based Dependency Tracking

MySQL 8.0.1 introduces a new mechanism to track the dependencies between transactions. This feature is used to optimize the binary log applier on asynchronous replication slaves, improving the throughput significantly on workloads where there is low-concurrency on the master and/or on systems with very fast storage.…

Percona XtraDB Cluster Transaction Replay Anomaly

In this blog post, we’ll look at a transaction replay anomaly in Percona XtraDB Cluster.

Introduction

Percona XtraDB Cluster/Galera replays a transaction if the data is non-conflicting but, the transaction happens to have conflicting locks.

Anomaly

Let’s understand this with an example:

  • Let’s assume a two-node cluster (node-1 and node-2)
  • Base table “t” is created as follows:
create database test;
use test;
create table t (i int, c char(20), primary key pk(i)) engine=innodb;
insert into t values (1, 'abc'), (2, 'abc'), (4, 'abc');
select * from t;
mysql> select * from t;
+---+------+
| i | c |
+---+------+
| 1 | abc |
| 2 | abc |
| 4 | abc |
+---+------+
  • node-2 starts runs a transaction (trx-2):
[Read more]
Showing entries 1 to 10 of 37586
10 Older Entries »