Session
FOSDEM Schedule 2021
MariaDB

MariaDB Roles

Overview and Migration
D.mariadb
Vicentiu Ciorbaru
<p>MariaDB has had roles all the way back in 10.0 (2013). MySQL now supports roles as well, starting with 8.0. This talk will go through an overview of Roles in MariaDB and how they can be used. The talk will also highlight the differences, as well as the migration requirements, should you need to move to (or from) MariaDB.</p>

Roles in MariaDB follow the SQL Standard implementation. Roles are a very useful feature for ensuring ease of use for a DBA. Not only that, but thanks to DEFAULT ROLE, applications not previously aware of roles can make use of them transparently.

In this talk we will cover the following aspects of Roles: * Creating, granting, activating. * Roles granted to roles (the role graph) * Default Roles * Information schema tables * Differences to MySQL, migration with mariadb-dump.

Additional information

Type devroom

More sessions

2/6/21
MariaDB
Ian Gilfillan
D.mariadb
<p>A brief introduction and overview of what you can expect from the MariaDB devroom at FOSDEM</p>
2/6/21
MariaDB
max
D.mariadb
<p>MariaDB Corporation is currently working on plenty of features for MariaDB 10.6. At the same time we already have a long list of things to add in future versions of MariaDB. This talk will look at the main tasks for 10.6 and future versions of MariaDB. At the same time we are hoping to get feedback and suggestions from the community</p>
2/6/21
MariaDB
Valerii Kravchuk
D.mariadb
<p>With MariaDB in a general case (backup, proper shutdown, storage engines incompatibilities, Galera, async replication, and maybe few bugs and corner cases aside) it should be possible to easily and directly upgrade from one major version to the other, skipping any number of intermediate major versions in between. mysql_upgrade utility is designed to fix all incompatibilities in the mysql.* system tables. In frames of this talk the details of its implementation and actions are discussed, as ...
2/6/21
MariaDB
Michael "Monty" Widenius
D.mariadb
<p>This talk will present a proper procedure of migrating applications from proprietary database systems (such as Oracle or SQL Server) to MariaDB. The talk will give an overview of the steps required to successfully perform a full migration. built from the experience of migrating DBS Bank's core infrastructure from Oracle to MariaDB.</p>
2/6/21
MariaDB
pickup li
D.mariadb
<p>Introduce a use case from a Chinese who migrated one of their important applications from Oracle to MariaDB with very few modifications to the application. I will cover the entire migration process and experience, including tools to check the Oracle syntax compatibility with MariaDB and tools to compare the execution results of Oracle and MariaDB, and the proxy that receives and interprets the Oracle network protocol to MariaDB</p>
2/6/21
MariaDB
Krunal Bauskar
D.mariadb
<p>MariaDB has been releasing packages for ARM for quite some time now. ARM is known to have a lower cost of ownership there-by delivering more TPS for the same cost, effectively generating cost savings. Any changes to the working production environment would surely make DBA/dev-ops anxious and we are talking about migrating to a different architecture altogether. How complex is that? Is it feasible? Is it the right time to look into it? What about the ecosystem/other aspects?</p> <p>We will try ...
2/6/21
MariaDB
Oli Sennhauser
D.mariadb
<p>Mariabackup is another backup tool for MariaDB. But it is still not used very frequently. In this presentation we will have a short look how this backup works and what we can do with it.</p>