Tag: Storage engine
-
DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.
An early look at the DuckDB storage engine for MariaDB — columnar, vectorized analytics that live right next to your transactional tables.
The problem
MariaDB’s InnoDB is excellent at what it was built for: transactions. Row-by-row inserts, updates, point lookups, strong consistency. But the moment you ask it to scan tens of millions of rows for a multi-way join with a few aggregations, a row store has to work hard.
The usual answer is to stand up a separate analytical […]
-
MariaDB Foundation assisting multiple vendors
I recently helped two of our sponsors simultaneously, DBS Bank and MariaDB Plc, with a recent issue they were experiencing. This actually helped us add support for an extra cloud vendor. But before I tell the story, I first need to give a bit of background.
S3 Engine History
Back in 2019, we added the S3 engine to MariaDB Server. “S3” stands for “Simple Storage Service”, it was developed by Amazon, and it is pretty much the standard for storing […]
-
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 […]
-
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 […]