How to install the federated engine in MariaDB

Check the installed engine to MariaDB

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        |

Install the Federated dll with the following command:

install plugin federated soname 'ha_federatedx.dll'

To uninstall, use the following command:

uninstall soname 'ha_federatedx'