Migrating from SQL Server to MariaDB on the MariaDB Knowledge Base

A new series, Migrating from SQL Server to MariaDB is currently being developed on the MariaDB Knowledge Base by Federico Razolli.

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 Server’s continuous integration & testing available to community

How MariaDB Server is tested

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. …

2019 上海MariaDB开发者会议

(The original English version of this post is available here).

MariaDB基金会很高兴地宣布,2019 年度MariaDB开发者会议将于上海举行。继第一届2017年深圳开发者会议之后,这是该会议在中国的第二次举办。此次会议将于2019年11月19日周二开始,2019年11月21日周四结束。

此次会议将由微软上海分公司友情承办。请有意向与会者,点击此链接报名参加event page at Meetup.com. 我们建议您选择会议地址附近的酒店入住。所有会议均免费参加。

此次会议的模式将与以往相同,欢迎大家围绕所有主题进行讨论与合作。我们欢迎每一位有兴趣为MarianDB开源项目做贡献的人的参与。参与形式不限,可以为编程或其他任何方式。参与人员也不局限于核心开发人员。这是一次开放的聚会,我们欢迎喜欢开源的学习和工作方式,并愿意为MariaDB做出贡献的新伙伴和老朋友。

此次会议将围绕MariaDB开源项目展开深度演讲与交流。届时很多核心MariaDB开发者也将出席会议。

此次会议的目的在于能够提供一个面对面交流的平台,使新老开发者们能共同破解难题或者规划未来。

若您需要申请办理签证所需邀请函,请浏览此处see the visa applications page for China from Shenzhen.
若您对此次会议或者如何致力于MariaDB有任何疑问,请随时于此处发起您的讨论MariaDBdevelopers mailing list以及MariaDB discuss mailing list.

报名参加会议请点击此处 MariaDB Developers (Un)Conference here. …

2019 Developers Unconference, Shanghai, Nov 2019

(A Chinese version of this post is available here).

The MariaDB Foundation is pleased to announce the 2019 MariaDB Developers Unconference in Shanghai. This will be our second Unconference in China, after the 2017 Developers Unconference in Shenzhen, and will take place from Tuesday 19 November to Thursday 21 November 2019.

Microsoft Shanghai are kindly hosting the event. If you want to attend, please sign up on the event page at Meetup.com. We recommend you stay in a hotel near the venue.

All events are free of charge to attend.

The event will be the traditional unconference, with lots of opportunities for discussions and collaboration around any topic. …

On Contributions, Pride and Cockiness

At MariaDB Foundation, we are proud of MariaDB Server getting plenty of contributions. But we don’t want to get cocky, so here is an update about where we stand, and what we want to make happen.

First, we have shown our contribution pride in several places. On 15 February 2019, I tweeted

Repeating: On code contributions, #MariaDB beats #MySQL 1009 to 247: We have over a thousand (1009) closed pull requests on GitHub (and 179 open), MySQL has 247 closed (1 open).

In our Annual Report 2018, we spent several pages, talking about pull requests and patches, showing code contribution statistics. …

Authentication in MariaDB 10.4 — Understanding the Changes

MariaDB Server 10.4 came with a whole lot of Security related changes. Some of them are merely optimizations (like MDEV-15649), some improve existing features to be more robust (MDEV-15473, MDEV-7598) or convenient (MDEV-12835, MDEV-16266). Some are MySQL compatibility features, requested by our users (MDEV-7597, MDEV-13095).

But the first thing any MariaDB Server user, whether an experienced veteran or a newbie, does — before even issuing the first SQL statement — is logging in. Authenticating to the database server. …

Easier licensing of MCAs for MariaDB contributors

Software licensing is a difficult subject that we don’t usually want to think about. It can be confusing and frustrating trying to work out whether different licenses are compatible, and problems like dual-licensing make it even harder. We all just want to write great code, not worry about licenses!

Until now, contributors who provide improvements and bug fixes to MariaDB have been asked to declare their license choice every time they make a contribution. For new contributors, or those who just want to submit a very small fix, this can be a complicated extra step they weren’t expecting. For regular contributors, it’s extra work for every single pull request. …

2019 Developers Unconference, New York

February in New York City is again MariaDB time, and the first MariaDB Developers Unconference of 2019 will take place on Saturday 23 and Sunday 24 February, with Hudson River Trading as kind hosts.

The event is free to attend and you can join for the entire weekend, or as little time as you wish. However, it is essential to sign up in advance on the event page at Meetup.com.

The schedule of this unconference is being drafted in a public spreadsheet. Please add suggestions for sessions you would like to present or lead on this spreadsheet. …