[MDEV-31706] Add support for catalogs to Federatedx Created: 2023-07-15  Updated: 2024-01-12  Resolved: 2023-11-20

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Federated
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-31542 Add multi-tenancy catalogs to MariaDB Stalled
Relates
relates to MDEV-31917 Add support for catalogs to connect e... Closed
relates to MDEV-33228 Fix Federated pre-upgrade for Catalogs In Review

 Description   

The servers table table is already stored per catalog.

  • Test that "servers" table works per catalog.
  • Ensure that we create the 'servers' table in each catalog mysql's datadir.
  • Ensure one can connect to from a server compiled with and without catalogs:
    (Same requirement as with catalogs and the connect engine)
  • A table in another catalog.
  • A table in a non catalog server.
  • Add 'catalog' name to mysql.servers
  • Remember to fix this in mysql_fix_privileges

Things to look at:
sql_servers.cc
bool servers_init(bool dont_read_servers_table)

 Comments   
Comment by Andrew Hutchings [ 2023-08-22 ]

Done:

  • Added test for cat.db connections cross-catalog in the same server (works)

TODO:

  • Support for mysql.servers table per catalog - not working, everything seems to use def.
  • Connect test from non-catalogs server to catalogs server
  • Support catalogs keyword in `CREATE SERVER s FOREIGN DATA WRAPPER`
Comment by Andrew Hutchings [ 2023-09-12 ]

Done:

  • Add mysql.servers table per catalog
  • Fixed bugs blocking FedX to work in Catalogs

TODO:

  • Test connect from non-catalogs to catalogs server
  • Add support for catalogs separate from db.catalog format (extra column needed?)
  • If we add extra column, the mysql_fix_privileges addition
Comment by Andrew Hutchings [ 2023-10-31 ]

Everything done apart from non-catalogs to catalogs server test. I can't see an obvious way of setting up a non-catalog and catalog server at the same time in mtr at the moment.

All in linuxjedi-fedx branch on Hasky.

Comment by Michael Widenius [ 2023-11-20 ]

Reviewed and merged to catalog tree.

Generated at Thu Feb 08 10:25:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.