One table for two databases

Question

MySQL

Is it possible to have exactly the same tables in MySQL in multiple databases? Create a table in one database and somehow link it to other databases, or automatically update records in other tables, something like that?

Answer 1

dev.mysql.com/doc/refman/5.0/en/federated-use.html

Answer 2

What's stopping you from doing this
SELECT * FROM scheme1.table1 JOIN scheme2.table2 USING (id) :

Answer 3

If within the same server, you can, for example, put triggers on tables in each database for synchronization with other databases. Above you were told that you can make queries to different schemas.
But you have to manually maintain everything in case of adding or removing a database. That is, create, edit triggers ...
Or a federated table (also see the hint above).
If you synchronize copies on different servers, it is more difficult and impractical. I heard that in the latest versions of MySQL, you can run an external script on a trigger (which, in a particular case, will carry out the transfer of changes to other servers). But it will be necessary to keep the list of copies up-to-date, check for availability, take into account changes when a server crashes and synchronize after raising ... In general, not an option.
In any case, the structure of tables will have to be maintained completely manually.