In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.

First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during the webinar.

Q: What do you recommend for benchmarking NDB cluster? Which should be used and how?

A: The issue with benchmarking NDB cluster is not the tool choice, but …

In a spirit of open source, and furthering our stated mission to be the unbiased champions of open source database software, we’re excited to introduce this community initiative. Our aim is to provide a platform for members of the open source database community to exchange ideas and knowledge, make suggestions and sound out ideas.

In some ways, you might view it as an all year-round, online celebration of what delegates enjoy about the Percona Live Open Source Database Conference. Something of a misnomer since Percona Live – as many readers will already know – is not just about Percona Software but embraces all open source database technology.

So it will be with this blog space.

Who will write for the Percona community blog?

If you already blog, then maybe you don’t want to be providing content for this blog too. Then again – if you post great …

MySQL Cluster 7.6 is GA!
If you’re eager to give the recently announced MySQL Cluster 7.6 GA a spin, I’ll walk you through a quick and simple way to get started using MySQL Cluster Manager 1.4.6.

Bootstrap and go!

1. Download and install MCM and MySQL Cluster
2. Bootstrap a cluster with MCM
   
   $ mcmd –bootstrap
3. Connect to the database, and have at it
   
   $ mysql -h 127.0.0.1 -P 3306 -u root

That simple.…

This year the Zero to DBA Hero track at the Southeas  Llinuxfest expands to a second day.  The event is free to attend but it helps if you pre register.  Here is the agenda of that you will see in Charlotte June 8th, 9th, and 10th.


MySQL Talks at SELF – Zero to DBA Hero Track Linode Ballroom
Friday
9am 20 years of MySQL, 20 years of PHP, and 10 Years of SELF -- What the heck has been going on? Dave Stokes
10:15 Introducing the MySQL Document Store
Charles Bell, PhD
11:30 Performance Analysis and Troubleshooting Methodologies for Databases Peter Zaitsev
1:30 MySQL Without the SQL -- Oh My! Dave Stokes
4:00 Introducing MySQL InnoDB Cluster Charles Bell, PhD
Saturday
9am …

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

Shortly after the last dispatch, I jetted off for a spot of vacation (which really meant I was checking out the hype behind Blockchain with a database developer lens at the Blockchain Week NYC), and then some customer visits in Seoul, which explains the short hiatus. Here’s to making this more regular as the summer approaches.

I am about to embark on a fairly long trip, covering a few upcoming appearances: Lisbon for the Percona Engineering meeting, SouthEastLinuxFest in Charlotte, the …

      Bernd Ocklin | MySQL Cluster Engineering Director

It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time. 

MySQL Cluster is a distributed database combining linear scalability and high availability. An ultra-high speed database, MySQL Cluster provides in-memory real-time access with transactional consistency across partitioned and distributed data sets designed for highly available mission critical applications.

MySQL Cluster’s shared nothing architecture delivers an incredible 99.9999% availability and is used within the core of systems that serve billions of mobile phone users, leading online-games and high demand web services. 

This new MySQL Cluster 7.6 version is all about supporting and optimizing performance on the latest off the shelf hardware, increasing its ability to both scale up on ever …

In this series of blogs I will do my best to demonstrate how to set up and run Cluster in Cloud environment by hand and by utilizing MCC. For detailed configuration, I will use MCC (Auto-installer). Some of the information regarding this setup is provided in post by Mikael. Information regarding Auto-installer is available in our documentation, HTML help files in share/MCC distribution directory and in my blog post.

Cloud setup It might come as surprise but for initial testing any instance should do. I started with 1CPU/1GB RAM ones. The target topology was:

• Host #1: Management node and Cluster client tools.
• Host #2: Multi-threaded DATA node. …

We are are an vendor neutral and independent open source database technologies consulting, support and remote DBA services provider with several customers using MySQL GA, MySQL Enterprise, InnoDB/XtraDB, Percona Server, MariaDB, MyRocks and ClickHouse. The customers continue doing business with us for being an technology / vendor agnostic company. We spend considerable amount of time doing research on open source database technologies, Often customers ask us about the performance comparison between InnoDB and MyRocks so we decided to write this post to compare performance between InnoDB (MySQL 8.0) and MyRocks (MariaDB 10.3.7) using Sysbench 1.0.14:

Software Infrastructure we have used for this benchmarking : 

MySQL 8.0 / InnoDB  (no custom tuning done for performance)

[root@localhost sysbench]# cat /etc/redhat-release 
CentOS Linux release 7.3.1611 (Core) …

MySQL 8.0.11 comes with a catalog of 5108 spatial reference systems (SRSs). 4628 projections (flat maps), 479 geographic (ellipsoidal) representations of Earth, and one Cartesian all-purpose abstract plane (SRID 0). And if for some reason that isn’t enough, we can create our own.…

Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.

Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for MySQL 5.7.22-22 is the current GA release in the Percona Server for MySQL 5.7 series. Percona …