How to synchronize order IDs of two shops on different hosts and databases?

Question

MySQL

How can you beautifully synchronize order numbers for two shops, on different hosts and engines? Both databases have local databases, and both have the order number - this is the auto-increment number of the order table.

Answer 1

Only by creating a joining table of orders with additional. field: real_shop_order_ID.
Order IDs for the new table can be sorted by timestamp (for further convenience of working with the table).