Tag Archives: MariaDB
Galera Cluster for MySQL is a 100% synchronized cluster in regards to data modification operations (DML). It is ensured by the optimistic locking model and ability to rollback a transaction, which cannot be applied on all nodes. However, schema changes (DDL operations) are not transactional in MySQL, which adds complexity when you need to perform an upgrade or change schema of the database.
Changes made by DDL may affect results of the queries. Therefore all modifications must replicate on all nodes prior next data access. For operations which run momentarily it can be easily achieved, but schema changes may take hours to apply.
…
Galera R&D team is currently finalizing new features targeted for the next MariaDB 10.5 release. This presentation is a high level overview of the most prominent Galera clustering features under work, such as:
* Non Blocking DDL – for less turbulence of schema upgrades in a cluster
* Cluster Error Voting – for immediate recovery of node failures
* XA transaction Support – for executing XA transactions in a multi-master cluster
* GTID consistency – for consistent GTIDs in hybrid cluster / replication topologies
* Black Box – cluster hardening through more detailed diagnostics
…
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.
…
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 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.
…
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.
…
In our quest to promote development of MariaDB Server, what we have come to call Unconferences form a key part. These developer meetings have traditionally been organised twice a year, and 2019 is no exception. After the North American Unconference in New York in February, Asia Pacific was in turn with Shanghai in November. And, no, we have not forgotten Europe; expect an EMEA Unconference next year.
Hosts and environment
Microsoft were our hosts, at their fabulous campus in the peaceful outskirts of Shanghai. “Where are all the Chinese?” was a common foreigner reaction;
…
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. …
Continue reading “MariaDB Server’s continuous integration & testing available to community”