S
S
spoki2015-12-30 19:46:08
MySQL
spoki, 2015-12-30 19:46:08

Replication in MySql?

The following situation: the DBMS has two schemas db1, db2.
Replication is configured on db1
In the code, the connection is configured jdbc:mysql://localhost/db1
But through this connection requests for changes are executed and db2 example: insert into db2.table1
(name) values ​​('Mike')
to leave on a remark requests for change db2?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
T
Tyranron, 2015-12-30
@Tyranron

Depends on replication settings.
What is specified in master's my.cnf under replicate-do-db will be replicated.
Read more here and in the official doc .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question