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 ?

Improve this question
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)?
    – Michael - sqlbot
    Oct 8, 2013 at 0:39

1 Answer 1

Reset to default
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.

Improve this answer

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.