SELECT * FROM information_schema.engines
WHERE ENGINE = 'FEDERATED';
ENGINE FEDERATED
SUPPORT YES
COMMENT Federated MySQL storage engine
TRANSACTIONS NO
XA NO
SAVEPOINTS NO