Category: Using MariaDB
-
Deploying MariaDB and WordPress on Kamatera
When deploying MariaDB in the cloud, controlling the infrastructure can be as important as controlling the database itself.
Plenty of cloud providers offer their own approaches to virtual machines, networking, storage, and managed services. One of them is Kamatera, a global cloud infrastructure provider that recently joined the MariaDB Foundation as a Silver Sponsor.
Kamatera (see in ecohub) offers customizable cloud servers across more than 20 data center locations worldwide. Instead of choosing from a limited set of predefined VM […]
-
MariaDB Connector/C Compatibility: An Update on CONC-821
As a DBA, there are some surprises I enjoy. Discovering a useful feature is one of them. Discovering that an application behaves differently after a maintenance update is considerably further down the list.
Maintenance updates should provide security and bug fixes while also helping people keep their applications running smoothly. Updates should not change behavior, especially not during maintenance releases. Should that happen for some reason, users and maintainers need a clear explanation and a practical way forward.
That’s not […]
-
MariaDB 13.1 Feature in Focus: DENY / Negative Grants
MariaDB 13.1 Preview is full of nice things.
Some are immediately visible to developers, like the new JSON operators. Some are very useful to DBAs, such as configuration validation. And some are about making security and access control easier to manage.
Today, let’s look at one of those: DENY, also known as negative grants.
Yes, negative grants.
It sounds a bit strange the first time you hear it, but the idea is very simple:
Sometimes it is easier to say […]
-
MariaDB Hidden Gem: Create Aggregate Function
Have you ever written a query where the GROUP BY was easy, but the aggregate was the problem?
You know how to group the rows.You know what result you want for each group.But none of the built-in aggregate functions really match your logic.
So you end up with a long expression using SUM(), CASE, IF(), GROUP_CONCAT(), JSON functions, or application-side code. It works, but it is not beautiful. And if you need the same logic in several places, it becomes […]
-
Unleashing Innovation Through Plugins
One of the corner stones in MariaDB Foundation’s mission is:
We strive to increase adoption by users and across use cases, platforms and means of deployment. https://mariadb.org/about/
MariaDB Server plugins are definitely a prime “means of deployment” for server features. But a relatively neglected one so far. They have been around for many years. But, somehow, they have escaped the user’s focus. Why that happened is a very interesting topic. And one that I’d definitely like to hear your opinion […]
-
Database Trends: What is changing in the database world (besides AI)
Earlier this month, I had a half-hour chat with Kellyn Gorman, a Database and AI Advocate and Engineer at Redgate. The UK software company is known for database DevOps and database management tools most databases – and since 2024 as the owner of DB-Engines popularity Ranking of database management systems.
The chat was an intellectual pleasure, to say the least. Kellyn is outstandingly well informed on databases, with a background starting in Oracle, spanning most databases as a DBA and […]
-
Improving MariaDB Observability with OpenSearch and Grafana
When dealing with queries in MariaDB, there are several approaches, such as the general query log, the slow query log, and the performance_schema.
The general query log is not recommended as it doesn’t contain much valuable information and can use a lot of resources when writing to the file on busy systems.
The slow query log is a much better option, as it contains many metrics and can be tuned. But if you want to collect everything, writing to the […]
-
DB Fiddle – SQL Database Playground – now has MariaDB
When choosing a database, many times you want to play and see what it can do to see if it’s relevant. Containers are easy, but a web page is even easier. DB Fiddle (https://www.db-fiddle.com/) has added MariaDB to its collection of databases that can be tested.
One of DB Fiddle’s strengths is its Text to DDL function, that can take a text format of a table, and create a database structure from it. I took the following paragraph of a […]