MariaDB 10.2 includes a number of JSON functions, but why would you use JSON as aren't JSON and SQL data contradictory? This blog shows you why this isn't so and how these JSON functions can be a very useful addition to MariaDB and how MariaDB 10.2 has some other tricks that make JSON with MariaDB even more useful.
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.
Parallel Replication is a fantastic addition to the long list of new MariaDB 10.0 features. In his blog post, Remote DBA Guillaume Lefranc explains how to leverage parallel replication's potential.
Learning MySQL and MariaDB, Monty Widenius, one of the founders of MySQL and MariaDB, graciously contributed a Foreword. It's about six pages long and an interesting read for those who are familiar with MySQL and MariaDB. Of particular interest to newcomers to MariaDB, is the excerpt in this article on his perspective of MariaDB and his vision for its future, as well as MySQL.
Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initial setup MariaDB has a tick in the graphical setup environment which enables MariaDB and replaces MySQL.
It's time to get to know four of the most commonly used administration commands for your MariaDB server:
There will come a time when you must search for a particular text string in a field in MariaDB, and you may not know what database or table it might be in. It is somewhat like searching for a needle in a haystack, but fortunately we have good tools for finding our needle. I like to dump the database I'm searching into a text file and do my searches on the file, because it's a fast way to search, and you can mangle the dump file all you want without damaging anything important. When you have the results, you can run SQL queries on the appropriate tables to make the replacements.
You've decided to move from MySQL to MariaDB, but you're a little nervous. The last thing you want is to become mired in a slough of brokenness. Don't worry, because MariaDB is designed to be a drop-in replacement for MySQL. You should be able to install MariaDB over your MySQL server, and then go about your business without drama.
The simplest method follows these steps:
WordPress has evolved from a specialized blogging platform into today's most widely used open source content management software (CMS), with thousands of third-party themes and plugins. WordPress was developed with MySQL as a back end, but because MariaDB is designed as a binary drop-in replacement of the original MySQL, you can replace MySQL with MariaDB for your WordPress installation and take advantage of its better performance, along with new features such as the two new database engines: XtraDB, which replaces InnoDB, and Aria, a crash-safe alternative for MyISAM.