TileDB integrates with MariaDB through a pluggable storage engine called MyTile, which can be found in the TileDB-MariaDB repo. MyTile is written to take advantage of query predicate pushdown to TileDB. MyTile allows a user to dynamically access any TileDB array, whether it is local to the machine, on S3 or on TileDB Cloud. This provides a powerful C++ based SQL engine for TileDB arrays.

A docker image is provided to allow for quick testing of the MyTile storage engine. The docker image starts a MariaDB server and connects to it from the shell for you.

# Run MariaDB
docker run -it tiledb/tiledb-mariadb

# Run MariaDB adding your S3 access keys as env variables
docker run -e AWS_ACCESS_KEY_ID="<key>" -e AWS_SECRET_ACCESS_KEY="<secret>" -it tiledb/tiledb-mariadb

# Run MariaDB by mounting an existing local array
docker run -it --rm -v /local/array/path:/data/local_array tiledb/tiledb-mariadb

Last updated