I have an active MASTER/SLAVE replication (Mariadb 10.2) with a single database (see scenario 1)
I decided to add in IMPORT database to populate the MASTER database as described in scenario 2. However, the SLAVE instance go OFF and “Unknown database import” error is traced back.
However, the created database (slave import) was without tables (in purpose) so to be sure that data is inserted in the slave I tested by creating a test table in the MASTER database and I did insert data from the Master's import database.
As a result, data was obviously available in the slave database even if the slave's import database has no tables.
So basically, we need just the same db name in slave section to get worked without the need of tables.
Could you please explain to me how it works ?and why we need the same db in slave if its a row-based format ?