Skip to main content
added 245 characters in body
Source Link
Bill Karwin
  • 16k
  • 2
  • 31
  • 42

It appears that you have a successful connection from the slave to the master, and the SQL thread is running. But I notice this:

  Replicate_Wild_Do_Table: zo_dev_matrix.*

This indicates you have configured a replication filter. It means that even though the relay logs contain all changes, only changes applying to tables in the zo_dev_matrix database will be executed on the slave. If your changes are in other databases, for example the test database, it won't show up on the slave.


Update:

If you refer to the documentation for replicate-wild-do-table, the wildcard it uses is %, not *.

Oh, never mind, I see Rolando already answered that. :-)

It appears that you have a successful connection from the slave to the master, and the SQL thread is running. But I notice this:

  Replicate_Wild_Do_Table: zo_dev_matrix.*

This indicates you have configured a replication filter. It means that even though the relay logs contain all changes, only changes applying to tables in the zo_dev_matrix database will be executed on the slave. If your changes are in other databases, for example the test database, it won't show up on the slave.

It appears that you have a successful connection from the slave to the master, and the SQL thread is running. But I notice this:

  Replicate_Wild_Do_Table: zo_dev_matrix.*

This indicates you have configured a replication filter. It means that even though the relay logs contain all changes, only changes applying to tables in the zo_dev_matrix database will be executed on the slave. If your changes are in other databases, for example the test database, it won't show up on the slave.


Update:

If you refer to the documentation for replicate-wild-do-table, the wildcard it uses is %, not *.

Oh, never mind, I see Rolando already answered that. :-)

Source Link
Bill Karwin
  • 16k
  • 2
  • 31
  • 42

It appears that you have a successful connection from the slave to the master, and the SQL thread is running. But I notice this:

  Replicate_Wild_Do_Table: zo_dev_matrix.*

This indicates you have configured a replication filter. It means that even though the relay logs contain all changes, only changes applying to tables in the zo_dev_matrix database will be executed on the slave. If your changes are in other databases, for example the test database, it won't show up on the slave.