Showing entries 1 to 10 of 37718
10 Older Entries »
What's New in MariaDB MaxScale 2.1

What's New in MariaDB MaxScale 2.1 Dipti Joshi Tue, 05/23/2017 - 19:44

We are happy to announce the 2.1 GA release of MariaDB MaxScale, the next-generation database proxy for MariaDB.

MariaDB MaxScale 2.1 introduces the following key new capabilities:

Dynamic Configuration

  • Server, monitor and listeners: MaxScale 2.1 supports dynamic configuration of servers, monitors and listeners, which can be added, modified or removed during runtime. A set of new commands were added to maxadmin.

  • Database firewall filter: Rules can now be modified during runtime using the new module commands introduced in this release.

  • Persistent configuration changes: The runtime configuration changes are immediately applied to …

[Read more]
What's New in MariaDB Server 10.2

What's New in MariaDB Server 10.2 RalfGebhardt Tue, 05/23/2017 - 17:03

We are happy to announce the general availability (GA) of MariaDB Server 10.2! MariaDB Server 10.2 is the newest major version of MariaDB Server, the fastest growing open source relational database.

MariaDB Server 10.2 is the next evolution after MariaDB Server 10.1. In 10.1 the integration of Galera Cluster as a high availability solution, data-at-rest encryption and other security features like the password validation API have been the key enhancements of MariaDB Server.

Now, with MariaDB Server 10.2.6 GA, new significant enhancements are available for our users and customers, including:

  • SQL enhancements like window functions, common table expressions and JSON functions allow new use cases for MariaDB Server

  • Standard MariaDB Server replication has further optimizations …

[Read more]
MyRocks in MariaDB 10.2.6

MariaDB 10.2.6 is GA. It includes MyRocks, which isn't GA yet but is much easier to use thanks to the hard work of the MariaDB team. This is a big deal if you want performant efficiency or efficient performance. For some workloads it provides better performance than InnoDB. For most (approximately all) workloads it uses much less space and writes much more efficiently. We continue to make RocksDB and MyRocks better and there are many interesting projects in progress. It runs in production, so Domas

[Read more]
Say Hello to MariaDB TX

Say Hello to MariaDB TX Shane Johnson Tue, 05/23/2017 - 15:49

We believe an enterprise database solution requires technology, tools and services, and that it should be easy to buy, easy to deploy and easy to manage – providing a great customer and user experience from beginning to end. 

In fact, we've made ease of use a central theme in our roadmap, and with the introduction of MariaDB TX today, we're taking another first step – packaging MariaDB technology, tools and services into a unified offering to help customers succeed with MariaDB infrastructure: MariaDB Server, MariaDB MaxScale and MariaDB Cluster.

In addition to introducing MariaDB TX, we are releasing MariaDB Server 10.2 and MariaDB MaxScale 2.1.

MariaDB Server, MariaDB MaxScale and MariaDB Cluster (Galera Cluster for MariaDB), along with MariaDB connectors and drivers, form the base technology in MariaDB TX. By bringing them together, we are …

[Read more]
MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance

CTEs and Recursive CTEs appeared in MySQL 8.0; first in a Labs release and now in the official release 8.0.1. Several blogs have been published: herehere and here ; my colleague Øystein also wrote how using a CTE made one DBT3 query run twice faster.…

Log Buffer #511: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server, MySQL.


A Sneak Peek at Oracle’s Chatbot Cloud Service and 5 Key Factors Necessary for Bot ROI

Oracle JET Hybrid – NavDrawer Template Menu/Header Structure

Oracle Enterprise Linux 6.6 AMI Available on AWS

Datascape Podcast Episode 9 – What’s Up with Oracle These Days?

Sequential Asynchronous calls in …

[Read more]
MariaDB 10.2.6 Stable now available

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.6 Stable (GA). This is the first stable (GA) release in the MariaDB 10.2 series. See the What is MariaDB 10.2? page for more details on the new features in MariaDB 10.2. Download MariaDB 10.2.6 Release Notes Changelog What is MariaDB 10.2? MariaDB […]

The post MariaDB 10.2.6 Stable now available appeared first on

Enterprise Ready InnoDB Clusters

Recently MySQL launched the General Availability of their Group Replication enhancements via the MySQL Shell and MySQL Router. Although these URLs just noted go to their respective documentation pages, these collectively are part of the InnoDB Cluster offering. The MySQL shell provides sophisticated provisioning, monitored insight and management of a Group Replication setup. When provisioned as such, you… Read More »

ICP Counters in information_schema.INNODB_METRICS

In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series. 

As mentioned in the previous post, in this blog we will look at how to check on ICP counters on MySQL and Percona Server for MySQL. This also applies to MariaDB, since the INNODB_METRICS table is also available for MariaDB (as opposed to the Handler_icp_% counters being MariaDB-specific). We will use the same table and data set as in the previous post.

For simplicity we’ll show the examples on MySQL 5.7.18, but they …

[Read more]
How to Enable SSL and Remote Connections for MySQL on CentOS 7

In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.

Showing entries 1 to 10 of 37718
10 Older Entries »