MariaDB Server 10.2 introduces Common Table Expressions (CTEs) that allows recursive SQL, that replaces the CONNECT BY syntax of older database systems. Here, we take a look at CTEs, how they relate to CONNECT BY and what these can be used for.
Authored by Shree Nair, Product Manager, Webyog
We are very excited to sponsor MariaDB’s inaugural user conference, M|17! It’s a great opportunity to introduce Webyog to the MariaDB community, and demonstrate the close collaboration between Webyog and MariaDB – we work together to provide powerful administrative tools for the fastest growing open source database.
MariaDB 10.2.4 has fantastic new features that perfectly match Replication Manager's ultimate goals: transparent automated failover on MariaDB master slave architecture (with as little as possible lost in transaction:)). We are going to explore those new features and how Replication Manager uses them for your benefit!
MariaDB ColumnStore is a massively parallel scale out columnar database. Data loading and modification behaves somewhat differently from how a row based engine works. This article outlines the options available and how these affect performance.
The 2.1 version of MaxScale introduced a new concept of module commands. This blog post takes a look at what they are, why they were implemented and where you see them when you use MaxScale.
Performance has been a central goal of MariaDB MaxScale’s architecture from the start. Core elements in the drive for performance is the use of asynchronous I/O and Linux’ epoll. With a fixed set of worker threads, whose amount is selected to correspond to the number of available cores, each thread should either be working or be idle, but never be waiting for I/O. This should provide good performance that scales well with the number of available CPUs. However, benchmarking revealed that was not entirely the case.
SQLyog is included in MariaDB Enterprise and it helps DBAs, developers and database architects save time writing queries visualized with syntax checking, designing visually complex queries, and many other powerful features for visualization, synchronization and management. This 12.4 release introduces ‘read-only’ connections as well as support for the MariaDB auth_gssapi (Kerberos) plugin.
MariaDB announced BSL 1.0 together with MariaDB MaxScale 2.0 in August 2016. After having the license “in the wild” for a few months we’ve been reaching out to Open Source advocates to get feedback on the BSL.
Join us for one of our full-day roadshows coming to a city near you! MariaDB is hosting educational roadshows across North America to showcase exciting new products and solutions, and share best practices for enabling critical enterprise features such as high availability and security. MariaDB experts will lead content-rich sessions on open source, product features, architecture and security.
Today, MariaDB ColumnStore, MariaDB's distributed columnar storage engine for analytics workload, is reaching its next major milestone – the availability of MariaDB ColumnStore 1.0.4 Beta software release.