lundi 2 mars 2015

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!





Aucun commentaire:

Enregistrer un commentaire