Relational databases store data in rows because a typical SQL query looks for multiple fields within a record. For example, if you ask for name, zip code and email address of all your customers in New York, the result is presented in rows, with each row containing several fields from a single record. Row structures are also well optimized to handle a lot of inserts and updates.
MariaDB’s new analytics engine – MariaDB ColumnStore - has been in the works for some time. What is it and how did it come about? This post outlines our thinking in choosing the engine and features we implemented.
URGENT UPDATE: Do not take 1.4.2 into use. We have found a problem and will provide a 1.4.3 release shortly.
We are pleased to announce that MariaDB MaxScale 1.4.2 GA is now available for download!
MariaDB works with many clients to migrate Microsoft SQL and Oracle to MariaDB. With the CONNECT storage engine we can access any ODBC data source in MariaDB. Here's a small HOWTO for those who want to give it a quick try. In this example we use MSSQL, though the same principle should be possible with Oracle ODBC servers.
In a recent presentation by Balazs Pocze from Gawker Media LLC made clear that there are many automation strategies for server management that would be worth packaging up into an extended solution like MariaDB Enterprise.
While many are at the ongoing OpenStack Summit in Austin, it came to my attention that the OpenStack project has recently published their latest user survey.
AliSQL is the fork of MySQL (maintained by Alibaba) that powers all of the group from Tmall, Taobao, Alibaba.com, 1688.com, AliExpress, Cainiao and the payment's network Alipay.
The latest top research identifies a number of big trends and challenges for databases. Jan Lindström, developer at MariaDB, summarises the key issues and challenges and how MariaDB approaches them.
Team MariaDB is touring across several European regions again. The theme for 2016 is "Data Management for Mission Critical Applications". Beside valuable presentations around database security, Big Data analysis and better scalability and high availability our technical experts will help you understand how to take advantage of the wide range of new features and enhancements available now in MariaDB 10.1, MariaDB MaxScale 1.4 and other MariaDB solutions. They will share tips & tricks to help you get the most out of your database.
I was recently talking on the #mariadb channel on FreeNode and I got a question about the often overlooked PDF documentation generation. In this blog I will show how to create a set of PDF files of the MariaDB MaxScale's documentation - a good way to keep the documentation handy. I did this on Ubuntu 14.04, but it should also work on other platforms.