Start MariaDB in K8s

This is the first in a series of blogs explaining how to use MariaDB in Kubernetes (K8s), as well as explaining some important concepts of K8s and of MariaDB.

This blog explains how to start MariaDB as a stateless application in K8s using the CLI and explores different commands you can run on your CLI.

The prerequisites are that you have installed kubectl (which will also install Docker runtime) and minikube (local K8s).

Let’s first start the minikube

$ minikube start && kubectl get nodes
NAME STATUS ROLES AGE VERSION
minikube Ready control-plane,master 104d v1.22.2

The Pod is a K8s resource and the smallest unit in K8s.

New Sponsor: Schaffhausen Institute of Technology

Good news from and for MariaDB Foundation: in Schaffhausen Institute of Technology (SIT), we have a new Platinum Sponsor. With the additional funds and with the insights provided by Serguei Beloussov, who will work with the MariaDB Foundation on the board level, we expect to improve our ability to further the MariaDB Foundation mission related to our values of Openness, Adoption, and Continuity.

Introducing SIT

This event marks a first in our work with sponsors, given that our top-level sponsor list has so far contained only names fairly familiar to industry players: DBS Bank, Visma, IBM, Microsoft, Alibaba, Tencent, and Service Now, not to mention the eponymous MariaDB Corporation.

We stand with Ukraine

This is a difficult blog entry to write. It involves war. But not a flame war. A real war where people are dying. Innocent people. You have all seen the pictures and videos, it is not my task to describe that.

MariaDB Foundation has been slow to react. This is because we have strong ties to both Ukrainian and Russian developers and we want to do the right thing, as individuals and as the Foundation. Let it be perfectly clear that MariaDB Foundation stands with Ukraine; that said, the rest of the blog is not written in first person plural.

Security: MariaDB Server MiniFest 30 March 2022 – CfP

Mark your calendars! On Wed 30 March 2022 Wed 6 April 2022, we will have the first MariaDB Server MiniFest of the year. The theme of the day is security, in all its shapes and forms – as long as it is relevant to the MariaDB Server user base.

Call for Papers

Submit your paper by 1 March 2022, if your work on security is of interest to the MariaDB ecosystem. We have ongoing discussions with a number of great presenters already, but submissions are welcome.

MariaDB 10.8.2 RC and MariaDB 10.7.3, 10.6.7, 10.5.15, 10.4.24, 10.3.34 and 10.2.43 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.2, a release candidate in the MariaDB 10.8 series, MariaDB 10.7.3, a Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.7, MariaDB 10.5.15, MariaDB 10.4.24, MariaDB 10.3.34 and MariaDB 10.2.43, the latest stable releases in their respective series.

These primarily fix a problem in last week’s releases when manually running mariadb-upgrade. See MDEV-27789, and the release notes and changelogs for details. …

MariaDB 10.8.1 RC and MariaDB 10.7.2, 10.6.6, 10.5.14, 10.4.23, 10.3.33 and 10.2.42 now available

2022 is off to a flying start and there are seven new MariaDB Server releases to kick things off. The MariaDB Foundation is pleased to announce the availability of MariaDB 10.8.1, the first release candidate in the MariaDB 10.8 series, MariaDB 10.7.2, the first Generally Available release in the MariaDB 10.7 series (maintained for one year), as well as MariaDB 10.6.6, MariaDB 10.5.14, MariaDB 10.4.23, MariaDB 10.3.33 and MariaDB 10.2.42, the latest stable releases in their respective series. …

FOSDEM22 MariaDB devroom talks

FOSDEM, one of the premier free and open source events on the calendar, is taking place this weekend, Saturday 5 February to Sunday 6 February. The MariaDB devroom will be taking place on the Saturday.

Thanks to the committee, consisting of

Sveta Smirnova (Percona)
Oli Sennhauser (FromDual)
Manuel Arostegui (Wikimedia Foundation)
Federico Razzoli (Vettabase)
Daniel Black (MariaDB Foundation)
Daniel Bartholomew (MariaDB Corporation)

for their valuable feedback.

The schedule is:

Take a look at the schedule on the FOSDEM site for any last-minute changes, as well as links to the videos and chatrooms.

Create a link to a remote server and access data using CONNECT SE

In this blog we are going to see how to create a link to a remote server and use it to access multiple tables at once.
In the previous blog we have seen how to establish a remote connection between Docker containers.
The way we did it was to specify the connection string to reference a single table only.
But what if we need more tables, what if need a whole database?

The solution is to link to a remote database with the CREATE SERVER statement.
A link obtained this way can be passed to the CREATE TABLE statement of a storage engine (SE) to make a connection where using the table discovery feature SE will find out about the table fields and create the table.