Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ?

share|improve this question
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 '13 at 0:39

1 Answer 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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