Unknown storage engine 'S3'
I am pretty new to mariaDB, I try to use s3 storage engine and backup my tables. I got this messages, I have all id keys and bucket set up.
s3=ON s3-bucket=frank-ro0 s3-access-key=<key> s3-secret-key=<secret-key>
MariaDB [PRODUCTS]> ALTER TABLE products_tbl ENGINE=s3; ERROR 1286 (42000): Unknown storage engine 's3'
when I show engines, there is no s3 storage engine, how can enable or load s3 storage engine? MariaDB [PRODUCTS]> show engines; +--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
CSV | YES | Stores tables as CSV files | NO | NO | NO |
MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
Aria | YES | Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables | NO | NO | NO |
MyISAM | YES | Non-transactional engine with good performance and small data footprint | NO | NO | NO |
SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES |
InnoDB | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |
PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
+--------------------+---------+-------------------------------------------------------------------------------------------------+--------------+------+------------+
Answer Answered by Geoff Montee in this comment.
Hi,
The S3 storage engine is not currently provided in any of our MariaDB Server 10.5 binary packages. Please see the following task in MariaDB's Jira: MDEV-22606.