Replicate my local database (Mysql) to remote database( phpmyadmin)

Question

My MySQL database (local server) is connected to a weather station. The data are updated continuously on my local server. My idea is to develop a web application that allows me to access this data. My local database (MySQL) has to be replicated on a remote server (phpmyadmin) The architecture is as follows:

My questions are: 1- How I do the connection ? I know that I can import my cvs file manually but I don't want to do this. 2- Can I update the datas automatically in my remote server ?

NOTE: I only want to queries on my remote server (phpmyadmin), I will not create or modify new datas. Thanks you for your help.

Answer 1

As i understood, you want to make a copy of your local mysql data on a remote server.

first of all phpmyadmin is a tool or webapp to access mysql , it is not a server itself.

and second

there are two type of replication approach

• Master-slave (read from slave , write to master, that will sync to slave) How to do it
• Master- Master (whatever operation are on master that will also replicate on other master) How to do it (Master-Master replication is deprecated. See Group Replication as a replacement)

You can choose the approach as per your requirement

Master-master vs master-slave database architecture?

How to achieve replication

http://dev.mysql.com/doc/refman/5.7/en/replication-howto.html