real-time copy of MYSQL



  • I don't know if this is at all possible, but I need to somehow copy in real-time to a slave MYSQL that I can access for stats, instead of risking the MYSQL database that is being used LIVE for our client.

    The slave MYSQL will be linked to our website and will only be used to do functions like count and other stuff that does not need to modify the data.

    The reason we don't want to give outside IP access to our internal MYSQL so instead by using a remote MYSQL server I am hoping to be able to watch a table and if modified then update the slave server with the changes.



  • Summary of the comments above:

    MySQL does support automatic replication. Here are some resources:

    • https://dev.mysql.com/doc/refman/8.0/en/replication.html
    • https://rads.stackoverflow.com/amzn/click/com/0071791868
    • https://www.digitalocean.com/community/tutorials/how-to-set-up-replication-in-mysql

    If you go through the documentation and try it and get stuck, feel free to come back here to dba.stackexchange.com. Tell us what you tried, where you got stuck (include any error messages), and we'll try to help.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2