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?

  • review once programmersought.com/article/59505871392 Nov 12 '20 at 9:41
  • thank you for migrating my question. @ROHITKHURANA - i saw that article already. it is not supported - i understand that much. i need to know if there is a workaround to it. tables that are federated are hotspots and we need a way to make any kind of transition seamless while keeping the functionality for which Federated was used in the first place (heavy writes)
    – Storm
    Nov 12 '20 at 10:30
  • It may be that MariaDB's FEDERATEDx is better than Percona's. MariaDB has Galera cluster, which is the basis for PXC.
    – Rick James
    Nov 12 '20 at 20:46
  • is there an alternative for federated instead?
    – Storm
    Nov 24 '20 at 15:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.