MariaDB Day Brussels 02.02.2020 – Introducing speakers – Nikita Malyavin on 5 Application-time periods in MariaDB – new syntax and table constraints: from PORTIONs to FOREIGN KEYs

We continue presenting our MariaDB Day Speakers. Please remember to register for the event at the Meetup page.

Application-time periods is another feature of SQL-2011. It’s main purpose is to introduce a per-table PERIOD entity, which generally is a pair of temporal fields: [period start, period end), and to set up a new set of syntax and constraints.

Note: the standard forbids these fields to be of type TIME, and to have more than one period per table.

The eminent part of application-time periods is a UNIQUE semantic extension — it adds a possibility to specify a period there, with adding WITHOUT OVERLAPS after it.

MariaDB day Brussels 02.02.2020 – Introducing speakers – Vicențiu Ciorbaru on comparing MariaDB and MySQL Roles.

MySQL 8.0 has introduced roles, a feature that was present since MariaDB 10.0. There are quite a number of differences between the two databases.

During the MariaDB day Vicențiu will present a comparison between them and see how roles are useful for your application and what are the key differences to consider when working with both databases.

MariaDB Day Brussels 02.02.2020 – Introducing speakers – Vlad Bogolin on ensuring MariaDB Server’s longevity with an open build system for the community.

For a large Open Source project to survive, it needs the right testing infrastructure in place. Because of this, the MariaDB Foundation made the whole build system a community shared resource. In this talk we will show how we have accomplished this and how the community can benefit.

MariaDB Day is part of FOSDEM Fringe and will be held on Sunday 2 February 2020. Attendance is free, but space is limited, so please RSVP on the Meetup page if you plan to attend.

MariaDB Day Brussels 02.02.2020 – Introducing speakers – Andrew Hutchings on ColumnStore engine

MariaDB has an Open Source engine called ColumnStore which provides columnar storage capabilities. During the MariaDB Day Andrew Hutchings (a.k.a. LinuxJedi) will hold a talk explaining what columnar storage is, how it works and the advantages / disadvantages of it. He will also talk about how you can use it to help with things such as your analytical workloads alongside your traditional OLTP workloads.

MariaDB Day 02.02.2020 – Introducing speakers – Valerii Kravchuk on eBPF and Dynamic Tracing for MariaDB DBAs (ftrace, bcc tools and bpftrace)

eBPF on Linux 4.9+ is probably the best way to study performance problems. Basic usage of ftrace interface, bcc tools and bpftrace, as well as main bpftrace features and commands are presented. Several typical use cases (including adding dynamic probes to MariaDB servers, working with stack traces and creating Flame Graphs) are discussed.

MariaDB DAY 02.02.2020 – Introducing Speakers – Dmitry Dain on Enabling post-compromise protection for stored data with Virgil PureKit security framework and MariaDB database.

As the first MariaDB Day is approaching we begin introducing our speakers. Dmitry Dain will talk about Enabling post-compromise protection for stored data with Virgil PureKit security framework and MariaDB database.

If you’re collecting personal data, you’re responsible for protecting it. And in this day and age, the question of when a database will be compromised is not a matter of “if” but “when.” So how can developers protect data within their systems without hiring expensive consultants or outsourced firms?

In this session, Dmitry Dain presents the Virgil PureKit security toolkit which protects passwords and data from being decrypted even if the database itself is compromised.

MariaDB Day Brussels 0202 2020 Schedule

A provisional schedule for the first MariaDB Day, to be held as part of the FOSDEM Fringe in Brussels at the Bedford Hotel and Congress Centre on Sunday February 2, is now available.

MariaDB Day is a complementary event to MySQL, MariaDB and Friends, giving an opportunity to more speakers and for more in-depth MariaDB coverage.

Attendance is free, but space is limited, so please RSVP on the Meetup page if you plan to attend.

View slides and presentations as they become available.

MariaDB Day Brussels 0202 2020

The first MariaDB Day will be held in Brussels at the Bedford Hotel and Congress Centre on Sunday February 2. This is a complementary event to the MySQL, MariaDB and Friends Day at FOSDEM, which is far-oversubscribed, and gives an opportunity for other speakers and more in-depth coverage of MariaDB-related topics.

Attendance is free, but space is limited, so please RSVP on the Meetup page if you plan to attend.

We also wish to gratefully thank our sponsors, MariaDB Corporation and Virgil Security Inc., for supporting the event. Virgil Security enables a new generation of enhanced privacy and security for applications, cloud services, and the Internet of Things by providing easy-to-deploy and easy-to-use cryptographic software and services for developers and end-users. …