locked
Web Server Replication RRS feed

  • Question

  • Hi,

    I am looking for a solution to replicate between two Mysql servers.
    The goal would be to have:
    - A local web server
    - A Cloud Web Server
    We would like to start programming locally then maybe, all migrate to the cloud.
    Is there a solution to synchronize (MySQL and Files) to an azure server and vice versa.
    Would there be an alternative? which would not take a azure windows appservice price expensive?

    Tuesday, September 24, 2019 7:42 PM

Answers

  • Hi Livio

    I am not sure by "Not possible" The Data-in replication is possible with one server on premise and other server in cloud. This is the only direction it works in. The second article given you in detail the steps to set it up.

    The Data - in replication will not work if the source is on cloud and destination on premises. 

    Hope this helps.

    Thanks
    Navtej S

    Wednesday, September 25, 2019 6:25 PM

All replies

  • Hi 

    Azure DB for MySQL does support the replication from a local or on premises server. Please go through following documents for more details and get back to us if any questions.

    https://docs.microsoft.com/en-us/azure/mysql/concepts-data-in-replication

    https://docs.microsoft.com/en-us/azure/mysql/howto-data-in-replication

    Hope this helps.

    Thanks
    Navtej S


    Tuesday, September 24, 2019 8:28 PM
  • Hi,

    If this is not possible,

    what it explains in the second article you just sent ?

    Does the Workbench Software have to be used and there is no possibility of writing from the cloud?
    Sorry, I try to understand well to know where I'm going!

    Thanks

    Livio B

    Tuesday, September 24, 2019 9:35 PM
  • Hi Livio

    I am not sure by "Not possible" The Data-in replication is possible with one server on premise and other server in cloud. This is the only direction it works in. The second article given you in detail the steps to set it up.

    The Data - in replication will not work if the source is on cloud and destination on premises. 

    Hope this helps.

    Thanks
    Navtej S

    Wednesday, September 25, 2019 6:25 PM
  • Hi

    The last reply has been proposed as an answer. Please mark it as an answer if this has helped you or get back to us with more questions.

    Thanks
    Navtej S

    Thursday, September 26, 2019 4:10 PM