In the name of the MariaDB Foundation, I would like to thank Tencent for their significant contributions to the MariaDB Server in 2020. The permission to, and encouragement of, Tencent staff to contribute towards MariaDB shows a superior and practical understanding of the value proposition of open source in delivering value to everyone at the same time as reducing software maintenance costs.
About Tencent’s DB Kernel Team
Tencent has a cloud native database kernel R&D team, focusing on database kernel optimisation and architecture evolution. The team is experienced (over ten years of database R&D experience) and serves hundreds of thousands of enterprise users.
Good news for MySQL users wishing to upgrade to MariaDB: MariaDB 10.5.7 onwards understands formerly-incompatible MySQL JSON fields! This blog entry explains how to install and use them.
Introducing MYSQL_JSON plugin
Starting from MariaDB 10.5.7 (commit f6549e), it is possible to upgrade from MySQL 5.7 tables containing JSON by loading the MYSQL_JSON data type plugin.
MariaDB and MySQL JSON formats are not the same. In MySQL, the JSON type is a native type, while in MariaDB JSON is just an alias for LONGTEXT. What this means in practice is that data in JSON format are not compatible with each other.
Machine learning is one area that cannot succeed without data. Traditionally, machine learning frameworks read it from CSV files or similar data sources. This brings an interesting set of challenges because in most cases the data is stored in databases, not simple raw files. It takes time and effort to move data from one format to another. Additionally, one needs to write some code (usually python) to prepare the data just like the ML framework expects it.
I was pleasantly surprised when I saw during the MariaDB Server Fest that MindsDB, an automatic machine learning system, presented their integration with MariaDB.
Hi, my name is Kartik Soneji, and I am a second year student at Thadomal Shahani Engineering College, Mumbai. I have been programming since the age of 13. I started out with Java, then learnt a little C++ before diving head first into web development with HTML, CSS and JavaScript. I also programmed a bit in Python and Rust to see what all the hype was about.
My primary motivation to contribute to the open source community is because I strongly believe in the idea that software is free, to copy, modify and study.
Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL
In a tad more than six minutes, you’ll see exactly how UNION, INTERSECT and EXCEPT work, starting in MariaDB 10.3, a few years back.
Ian explains what they are for, and the option to change default behaviour of DISTINCT with ALL (of which the ALL option was introduced in MariaDB 10.5).
MariaDB deployments hold vast amounts of sensitive data such as intellectual property, state secrets, healthcare and financial records. HIPAA, GDPR and other government regulations require even more stringent protections and disclosures. Achieving post-compromise protection is seen as a necessary new tool available to DevOps teams.
At the first MariaDB Day in Brussels on February 2nd, Virgil Security’s CTO and co-founder Dmitry Dain presented a MariaDB demo based on the Virgil PureKit security framework that can protect stored passwords, PII and any other sensitive data even if the database had been breached – making it worthless to the attacker in the face of offline attacks (read more about security benefits in this blog post). …
Federico is a freelance database consultant, organizer of the London Open Source Database Meetup, author of the book Mastering MariaDB, and well-known member of the MariaDB community.
The series of articles will contain everything needed to migrate from SQL Server, currently including an overview of architecture differences, feature differences, a types comparison, a look at MariaDB transactions and isolation levels, as well as authorization and permissions, and replication, from the perspective of a SQL Server user. …
MariaDB Foundation is commited to ensuring MariaDB Server has a thriving community of developers and contributors. A software project cannot be maintained without proper tests. mysql-test-run is our standard testing toolkit for MariaDB Server. What it (mostly) does is run queries against one or more servers and compare their output to the expected one. This checks both behaviour and data consistency. The main principle is the server should always return the same data that is put into it.
One problem with this testing method is that it only covers the hosts’ environment. That means that if you are running Debian on x86_64 architecture, you are testing x86_64 architecture on a Debian Linux distribution. …