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

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.4.6, the first stable release in the MariaDB 10.4 series, and MariaDB Connector/J 2.4.2, the latest stable release in the MariaDB Connector/J 2.4 series. See the release notes and changelogs for details. Download MariaDB 10.4.6 Release Notes Changelog What is MariaDB 10.4? MariaDB APT […]

The post MariaDB 10.4.6, First Stable 10.4 Release, and MariaDB Connector/J 2.4.2 Now Available appeared first on MariaDB.org.

The Question Recently, a customer asked us:

We were wondering if the Connectors would be able to bind to localhost/127.0.0.1 instead of 0.0.0.0:3306? Since the Connector is installed on the application servers, all of the connections are coming from localhost. We would like to limit this exposure so that the 3306 port is not exposed externally. We ask because we are failing PCI checks that are able to access the database port externally.

The Answer YES!

You may set the IP address for the Connector to listen on by using the tpm command option: property=server.listen.address={IP_ADDRESS}

To force the Connector to listen on the localhost only use the following example:

shell> tools/tpm configure alpha --property=server.listen.address=127.0.0.1
shell> tools/tpm update --replace-release

Use the IP …

ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice.

Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also seen strange behavior in the connection handling when reaching the CPU saturation point.

At this point, we noticed that the frontend_connections counter in the stats_mysql_users table was not decreasing even after the connections were no longer present at the network level. This counter is used to check the max_connections value in the mysql_users configuration table, causing frontend connections to receive a “Too many connections” error. So we determined that the key element here is to scale it properly. Obviously, all the major cloud providers can help us here as they all have features like auto-scaling groups.

Jervin Real of Percona has recently …

Just a reminder for the shows where you can find MySQL at this week, please find them below:

• GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019

  • Vittorio Cioe, the Sr. MySQL Sales Consultant will talk about MySQL Enterprise during the shared slot with Linux/Cloud team. Talk is scheduled for 10:05-10:25 on Jun 18.
• OpenExpo Europe, Madrid, Spain, Jun 20, 2019
  • Find MySQL & Linux team at our shared booth at OpenExpo Europe as Gold sponsor.
  • Planned MySQL talk:
    • "MySQL 8.0: Highly Available, JSON , NoSQL & Document Store" by Keith Hollman, the MySQL Principal Sales Consultant. Time: 16:40-17:10.
• …

MySQL 8.0 introduces many new features. We will have a look at the exciting histogram  feature in MySQL 8.0

Histogram:

What is Histogram?

In General, a histogram is an accurate representation of the distribution of numerical data. In MySQL, It will be useful to collect data distribution for a specific column.

What problem it solves?

In general DB Optimizer gives us the best execution plan, But the stats make the execution plan better and better .The data distribution of values in columns can make good impact in optimiser in case of column with less distinct values.

We will see an example of how it helps optimizer in some cases. 

I have used a production case. MySQL version is 8.0.15 installed in ubuntu 18.04 (32GB RAM,8 core) with optimal configuration. Let us try to optimise a …

Welcome to our new blog series Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog). This series will discuss the features of SQL Diagnostic Manager for MySQL designed to enable organizations to scale their existing resources for database administration. This week, we focus on the challenges associated with MySQL and MariaDB database systems.

The MySQL and MariaDB database systems are rapidly becoming the de-facto choice for traditional enterprises as well as pioneering Web 2.0 companies. Webyog has been consistently delivering powerful tools exclusively on the MySQL and MariaDB platform for the last 15 years.

While the adoption rate of MySQL and MariaDB continues to grow in momentum, it poses some unique challenges for traditional database administrators and their organizations. Some of these challenges are:

• Find problematic SQL queries
• Analyze MySQL and MariaDB performance data …