Can mariaDB contain indices only with data coming from remote tables? I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B).

All queries to the database (A) can be answered from indices only. Indices are read-only that is re-indexing is triggered from the remote-server (B) at certain intervalls (once per day).

I'm far from a specialist in database things, so when searching around and finding mariadb CONNECT I was wondering:

Question:
Is it at all possible to have a mariaDB database (A) containing "indices only" and the underlying tables being kept on remote locations (B)? If it was, is it feasable?

Thanks for some ideas!
No: local instance can't know when remote tables are updated.

Also, I suggest you use SPIDER instead of CONNECT.