I'm a bit new to MySQL specific settings and I can't find any hint/insight to this question. I have several Federated tables that work great for their current purpose, the rest of the database is in InnoDB. There is a plan to replace Federate in future, but that will not happen soon. In the meantime we're setting up a cluster for Mysql Percona server. The cluster will probably be multi-master with ProxySQL. The issue is Federate - will it work and are there things that we can do to ensure it's functionality?
Edit: Is there an alternative to Federate? Is splitting federated tables to a different db on the same server a good idea? Like a temp bucket table that just does batches of inserts?