CODEWITHSUNDEEP
mysql
tipiwiny
tipiwiny

Reputation: 409

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

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: Arquitecture

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.

Upvotes: 8

Views: 11333

Answers (1)

developerCK
developerCK

Reputation: 4506

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

Upvotes: 13

Related Questions