The stable version of MariaDB 10 has been released with better performance and new features. One major change is support for data in non-relational databases courtesy of the new Connect engine.
The Connect Engine gives you dynamic access to data including unstructured files such as log files in a folder, or any ODBC database. The Introduction to the Connect Engine on the MariaDB Knowledge Base claims:
“With CONNECT, MariaDB has one of the most advanced implementations of MED, without the need of complex additions to the SQL syntax (foreign tables are "normal" tables using the CONNECT engine).”
The other enhancement to MariaDB's NoSQL capabilities are support for dynamic columns, meaning you can store different types of data objects in different rows of the same column of a table and the ability to access data from Cassandra data directly.
While the NoSQL support is important, for many users the improvements to replication are more important. The blog post about the new version claims that MariaDB 10:
“is many times faster than previous generations of MariaDB and especially legacy database MySQL thanks to new features including parallel replication and a further advanced group commit. Also, the replication slaves are now crash-safe.”
The new release also lets you replicate data from multiple master servers to create a complete view of distributed data across datasets for real-time analysis.
MariaDB 10 now comes with built-in sharding support courtesy of the SPIDER engine. This allows big database tables to be split across multiple servers.
This is a machine that has lots to admire, but it does raise quite a few difficult questions. FarmBot Genesis will grow things for you without you having to be much involved. The technology is fascina [ ... ]