1

As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or application, it does get replicated as it should be.

Is it some security feature ? Or something wrong ? I use MySQL 5.5.28 with CentOS 6 mostly.

Any ideas why ?

1
  • 1
    It's not a security feature... more likely a case of misconfigured replication. Are you trying to replicate the entire server's data set (the standard configuration), or did you try to limit it to specific schemas or tables (because that's almost always what causes replication to not behave as expected)? Oct 8, 2013 at 0:39

1 Answer 1

1

I do not use phpMyAdmin so maybe i'm out but take a look on a potential autocommit option in the UI... Maybe your PMA's session isn't in autocommit (test with : SHOW VARIABLES LIKE "autocommit").

Other thing, do you have filtered replication ? (do-replicate, do-ignore...)

Max.

Best regards.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.