The MySQL database does not enable the federated module by default. You need to modify the my.cnf configuration. If you are using the Docker version, you can handle the extension situation through volumes:
mysql:
image: mysql:8.1.0
volumes:
- ./storage/mysql-conf:/etc/mysql/conf.d
environment:
MYSQL_DATABASE: APES
MYSQL_USER: APES
MYSQL_PASSWORD: APES
MYSQL_ROOT_PASSWORD: APES
restart: always
networks:
- APES
Create a new ./storage/mysql-conf/federated.cnf file
[mysqld]
federated
Restart MySQL
docker compose up -d mysql
Check if federated is activated
show engines
