FromDual has the pleasure to announce the release of the new version 2.0.2 of its popular MariaDB, Galera Cluster and MySQL multi-instance environment MyEnv.

The new MyEnv can be downloaded here. How to install MyEnv is described in the MyEnv Installation Guide.

In the inconceivable case that you find a bug in the MyEnv please report it to the FromDual bug tracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

Upgrade from 1.1.x to 2.0

Please look at the …

Parallel query execution is my favorite, non-existent, feature in MySQL. In all versions of MySQL – at least at the time of writing – when you run a single query it will run in one thread, effectively utilizing one CPU core only. Multiple queries run at the same time will be using different threads and will utilize more than one CPU core.

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. With faster disks (i.e. SSD) we can’t utilize the full potential of IOPS with just one thread.

AWS Aurora (based on MySQL 5.6) now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. I will compare AWS Aurora with MySQL …

Over the last few years, our community discussions have moved to MySQL Community Slack and MySQL Community Forums. And, Q&A discussions have moved to StackExchange and StackOverflow. The traditional MySQL mailing lists do not have any meaningful traffic, and are being discontinued.

So I encourage you to join the MySQL Community Slack. We are all there, ready to discuss and help: MySQL Engineers, and famous DBAs and developers , and newbies too. Come join us!

This is a quick reminder that on Thursday (tomorrow) there there is a Madrid MySQL Users Group Meeting where Giuseppe Maxia will be presenting dbdeployer to us. More information can be found here. Do not forget to sign up if you are interested. We look forward to seeing you there.

The post Reminder: Madrid MySQL User Group Meetup presenting dbdeployer on Thursday in Madrid first appeared on Simon J Mudd's Blog.

We would like to continue with announcing the shows where you can find & meet MySQL Community members or MySQL experts. Please find the list below (this time only for January 2019). Further events will come up later on.

• Oracle OpenWorld UK/EMEA, London, UK, Jan 16-17, 2019

  • MySQL team is going to be part of this Oracle show in London. You can visit Oracle/MySQL booth in the Zone 2-O and you can attend a talk given by Mark Swarbrick, the MySQL Principle Presales Consultant as follows:
    • MySQL 8.0: Top 10 Features for DBAs and Developers scheduled for Wed, Jan 16, 2019, 15:10-15:55, @Arena 6 (level 3) - ExCeL London
  • We are really looking forward to talking to you there!
• …

If you have set up per-process metrics in Percona Monitoring and Management, you may have found yourself in need of tuning it further to not only group processes together, but to display some of them in isolation. In this blogpost we will explore how to modify the rules for grouping processes, so that you can make the most out of this awesome PMM integration.

Let’s say you have followed the link above on how to set up the per-process metrics integration on PMM, and you have imported the dashboard to show these metrics. You will see something like the following:

This is an internal testing server we use, in which you can see a high number of VBoxHeadless (29) and mysqld (99) processes running. All the metrics in the dashboard will be grouped by the name of the command used. But, what if we …

Meet MariaDB 10.4 Support in MySQL Database Tools

We are glad to announce the release of the updated dbForge tools for MySQL. To ensure that the users of our MySQL tools can work with the most up-to-date database engines, we keep expanding connectivity options for our MySQL management tool. For this release, we have implemented support for the latest MariaDB 10.4. in  the […]

We are thrilled to inform our MySQL users that fresh and new dbForge Studio for MySQL, v8.1 has been just rolled out! To ensure that the users of dbForge Studio for MySQL can work with the most up-to-date database engines, we keep expanding connectivity options for our MySQL management tool. In this version, we have […]

In this blog post I’ll be starting another series with MySQL on the Oracle Cloud, but focusing this  post on IaaS initial setups.  In “the series” I’ll review at a high level, building an InnoDB Cluster on IaaS Compute in the Oracle Cloud, mostly focusing certain cloud characteristics as they pertain to building, staging and managing… Read More »