8

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.

Isaac Bennetch
  • 11,830
  • 2
  • 32
  • 43
tipiwiny
  • 399
  • 1
  • 3
  • 18

1 Answers1

13

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

yunzen
  • 32,854
  • 11
  • 73
  • 106
developerCK
  • 4,418
  • 3
  • 16
  • 35
  • After reading your link has emerged a new problema.I cant to configure my slave server because I have no access to the mysql shell from my control panel . Thank your for your help. – tipiwiny Jan 20 '16 at 18:50
  • @developerCK while the master-slave replication between 2 servers, can some user connect and read data from the database in the slave server? Thanks – Enrique Jan 29 '19 at 16:27
  • 1
    yes @Enrique, Slave is just a read replica of master. so , all read queries should hit th slave – developerCK Feb 23 '19 at 08:48