Databases
StackOverflow2013
Postsdbo
POReplicate tables from different database of same mysql server
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POReplicate tables from different database of same mysql server
    primarykey
    data
    text
    <p>I have one server with 2 databases, and i want to replicate several tables from one database to another. Purpose is that we uses same user's table that used in projects. </p> <p>As in anothers tables used InnoDB with foreign keys to users table i've chosen a replication way. </p> <p>For that I made the changes for my.cnf</p> <pre><code>master-user=root server-id = 2 replicate-rewrite-db = dou-&gt;jobs replicate-do-table = jobs.auth\_user replicate-wild-do-table = jobs.geo\_% replicate-do-table = jobs.user\_profile replicate-same-server-id = 1 report-host = master-is-slave binlog-do-db = dou log-bin </code></pre> <p>after syncing tables from <code>binlog-do-db</code> and starting slave error.log next lines appears:</p> <pre><code>111112 15:10:22 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='localhost', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='localhost', master_port='3306', master_log_file='mysql-bin.000074', master_log_pos='106'. 111112 15:10:36 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000074' at position 106, relay log '/var/log/mysql/dell-relay-bin.000001' position: 4 111112 15:10:36 [Note] Slave I/O thread: connected to master 'root@localhost:3306',replication started in log 'mysql-bin.000074' at position 106 </code></pre> <p>Seems that on this step everything is ok, and <code>show slave status</code> shows no errors.</p> <pre><code>mysql&gt; show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: localhost Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000074 Read_Master_Log_Pos: 814 Relay_Log_File: dell-relay-bin.000002 Relay_Log_Pos: 959 Relay_Master_Log_File: mysql-bin.000074 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: jobs.user\_profile,jobs.auth\_user Replicate_Ignore_Table: Replicate_Wild_Do_Table: jobs.geo\_% Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 814 Relay_Log_Space: 1113 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: 1 row in set (0.00 sec) ERROR: No query specified </code></pre> <p>The thing is that master changes does not affect slave but slave status changes.</p> <p>Thanks for any help in solve that problem.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USVitaly Volkov
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POReplicate tables from different database of same mysql server
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POReplicate tables from different database of same mysql server
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload