Tag: Docker
-
Migration with Docker Official Images
In this blog we will explore how to setup a docker compose file in order to migrate from MySQL 5.7 to the latest MariaDB.
In the next blog we will explain how to setup a docker compose file to migrate from MySQL 8.0 to MariaDB.
The steps to migrate from MySQL 5.7 to MariaDB are:
Let’s explore each step.
1. Start MySQL
The MySQL container is started using the following docker-compose file.
2. Use MySQL data directory and start MariaDB […]
-
MariaDB Server Docker Official Images Healthcheck without mysqladmin
MariaDB Server 11.0 was recently released and its Docker Official Image didn’t include mysqladmin which broke the healthcheck in a few usage scenarios. This surprised some people in the change of behaviour. We have observed a number uses of the mysql names in containers, custom healthchecks and some /docker-entrypoint-initdb.d scripts. To help use these correctly, lets talk about what is available in the containers to help perform healthcheck and initialization functions.
On healthchecks, HEALTHCHECK isn’t there in Docker Official Images […]
-
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 […]
-
Tricky Problems? MariaDB debug container
MariaDB does have bugs. Users see them sometimes. Sometimes developers look for a long time at bug reports and code and still cannot see how the situation occurred. Developers during their analysis ask questions like:
- I wonder if this was already fixed in {not released version}? But how can I ask a user to test that?
- Can I get the user to get good stack trace that would help understand this better? But users sometimes find this hard.
- What exact hardware and kernel configuration is this bug occurring on? And how would I reproduce this?
- I’d like to have a copy of this data to attempt some potentially damaging operation to understand this better? But user data isn’t always sharable, or easily copy-able.
- A rr record of this way that MariaDB got into this state would help me understand this better?
- I know what debugger information I’d get if I was to attack this problem locally, can I ask the user to do it?
-
Using CONNECT SE to access remote JSON data with demo examples in Docker
CONNECT is a storage engine (SE) plugin used to access external, local or remote data. In this blog we are going to show how to install the CONNECT storage engine in a Docker container and how to share JSON data between containers.
Enabling CONNECT SE plugin in Docker
CONNECT SE needs to be installed within the container in order to use it. To see how to do that please check Installing plugins in the MariaDB Docker Library Container.
Create JSON […]
-
Installing plugins in the MariaDB Docker Library Container
MariaDB plugins are software components that may be added to the core software without the need to rebuild the MariaDB Server. Plugins can be storage engines, additional security requirements, special log information about the server and others. MariaDB has a large number of built-in plugins which are permanently installed (listed in SHOW PLUGINS query). Plugins can be loaded at start-up, during initialization, or loaded dynamically when the server is running.
In this blog we are going to see how to […]
-
Purge of End of Life versions from Mirrors
OSU Open Source Labs have supported MariaDB for many years in hosting the mirror from which we distribute our releases for which we are most grateful. We were asked if we could reduce the size as our mirror usage had grown to 1TB, rather high compared to other projects.
To accommodate this request we removed all of the end of life releases, 5.5, 10.0 and 10.1 from the mirrors halving the used space.
It turns out there were some continuous […]
-
Developer tip: test MariaDB install/upgrade quickly with Docker
Here is a quick tip for any developer who might want to test if the latest development version of MariaDB installs/upgrades. Traditionally, developers seem to have a bunch of virtual machines lying around which they use to test MariaDB installation and upgrade related things. Snapshotting virtual images, keeping them up-to-date, starting, stopping etc. takes a lot of time and does not feel very convenient.
A much faster option would be to use pristine Docker images for every test. Docker images […]