I’ve an energetic MASTER/SLAVE replication (Mariadb 10.2) with a single database (see state of affairs 1)
I made a decision so as to add in IMPORT database to populate the MASTER database as described in state of affairs 2. Nevertheless, the SLAVE occasion go OFF and “Unknown database” error is traced again.
To beat this, I created then a database with similar title in SLAVE server (import) and the error is gone (see state of affairs 3).
Nevertheless, the created database (slave import) was with out tables so to make certain that knowledge is inserted within the slave I examined by making a take a look at desk within the MASTER database and I did insert knowledge from the Grasp’s import database.
Consequently, knowledge was clearly obtainable within the slave database even when the slave’s import database has no tables.
So mainly, we’d like simply the identical db title in slave part to get labored with out the necessity of tables.
May you please clarify to me the way it works ?and why we’d like the identical db in slave if its a row-based format ?