I am currently running tests with sysbench and dbdeployer on a Google Cloud Platform Debian 9 instance.  I ran into an interesting limit and lifting it was not straightforward.  I hope that by sharing this, you can avoid losing too much time.

The benchmark I am using is the insert benchmark.  I am able to run it with 2048 threads but I am not able to run it with 4096 threads (and yes, it makes

Welcome back to our blog series, Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog). Last week, we discussed some of the challenges associated with MySQL and MariaDB database systems. Today, we dive in to additional features of SQL Diagnostic Manager for MySQL, including agentless monitoring technology, cloud readiness, and customization options.

Agentless Monitoring

Unlike other monitoring and advisory tools for MySQL and MariaDB, SQL Diagnostic Manager for MySQL does not require installing monitoring agents on each MySQL and MariaDB server. Installing and maintaining monitoring agents can be a complex administration task by itself.

SQL Diagnostic Manager for MySQL uses a standard MySQL connection for monitoring. To collect data for the operating system from remote database servers, …

I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem I have found is that pt-kill is hard to understand and the documentation doesn’t have many examples (I’ll add them), so, I decided to write a post about the most common usage of pt-kill: to kill the queries that match a regexp (usually a SELECT) and have been running for more than n seconds.

Let’s assume that we are running a tool like sysbench that executes queries like:

select distinct c from sbtest1 where id between 1 and 20 order by c
select distinct c from sbtest2 where id between 5 and 25 order by c
select distinct c from sbtest3 where id between 3 and 7 order by c
select distinct c from sbtest1 where id between 2 and 8 order by c
select distinct c from sbtest3 where id between 15 and 30 order by c

and at the same time, in a different process, we are running:

SELECT SLEEP …

Overview The Skinny

In this blog post we will define what a split-brain scenario means in a MySQL database cluster, and then explore how a Tungsten MySQL database cluster reacts to a split-brain situation.

Agenda What’s Here?

• Define the term “split-brain”
• Briefly explore how the Tungsten Manager works to monitor the cluster health and prevent data corruption in the event of a network partition
• Also explore how the Tungsten Connector works to route writes
• Describe how a Tungsten MySQL database cluster reacts to a split-brain situation
• Illustrate various testing and recovery procedures

Split-Brain: Definition and Impact Sounds scary, and it is!

A split-brain occurs when a MySQL database cluster which normally has …

If you share your photos on social media, they will stay on the internet forever…

Many of us have heard or read this sentence during conversations with friends, in articles, online forums, TV shows, etc.

But how is it possible that we can’t seem to be able to fully remove our photos from the internet when we want to, and, taking this further, that our photos are never lost and always retrievable (which can both be a good and a bad thing)?

The behind-the-scenes, technical secret lies in data replication.

The very first moment when you share a photo on social media, that photo is uploaded into the closest available database server. In the second moment, that same photo is replicated into multiple other servers around the world.

This is what data …

We would like to remind you about the shows where you can find MySQL during next week, Jun 24-Jun30. Please find them below.

• Devoxx, Krakow, Poland, Jun 24-26, 2019

  • You can find MySQL among other groups (Java, Graal VM, Fn, Linux) at the Oracle booth in the expo area. Do not miss the demos (not only MySQL) we are going to run at our booth.
• MySQL User Group Frankfurt - MySQL Meetup, Germany, Jun 27, 2019
  • We are happy to invite you to join the MySQL meetup organized by MySQL User Group Frankfurt. This time Carsten Thalheimer, the  MySQL Master Principal Sales consultant is invited as a speaker. He will be talking about "MySQL 8 - The Next big Thing". The meetup starts at 7pm. More …

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.8. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

  * Importing MySQL Data into Excel

  * Exporting Excel data directly into MySQL to a new or existing table

  * Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows.

The MySQL Installer comes in 2 versions

– Full (400 MB) which includes a complete set of MySQL products with
  their binaries …

Percona is glad to announce the release of Percona XtraDB Cluster 5.6.44-28.34 on June 19, 2019. Binaries are available from the downloads section or from our software repositories.

Percona XtraDB Cluster 5.6.44-28.34 is now the current release, based on the following:

• Percona Server 5.6.44-86.0
• Codership WSREP API release 5.6.43
• Codership Galera library 3.26

All Percona software is open-source and free.

Bugs Fixed

• PXC-2480: In some …

While it shares the same heritage with MySQL, MariaDB is a different database. Over the years as new versions of MySQL and MariaDB were released, both projects have differed into two different RDBMS platforms.

MariaDB becomes the main database distribution on many Linux platforms and it’s getting high popularity these days. At the same time, it becomes a very attractive database system for many corporations. It’s getting features that are close to the enterprise needs like encryption, hot backups or compatibility with proprietary …

After upgrading the server many users start it with an unchanged config file only to find some deprecated options that they were using are no longer supported by the later server version, which causes the upgraded server to shutdown. In other cases modifying the server configuration file results in the server refusing to start when an invalid name is mistakenly entered in the configuration file.…

Facebook Twitter LinkedIn