i have a master slave setup on different ec2 instance and they are perfectly replicating i just wanna know how to check the changes made by the other instances to the database we replicate

  • What are you asking about? The integrity of replication? Which Replica is ahead of the others? Whether some node has crashed? And what version of MySQL are you referring to?
    – Rick James
    Aug 5 at 0:37
  • no like i wanna know which user performed what operations like(select update)on the database Aug 5 at 6:47
  • SELECTs are not replicated. To monitor SELECTs, see the "general log".
    – Rick James
    Aug 5 at 22:32
  • ya exactly i used server_logs to see the changes Aug 9 at 13:48


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.