0

I cannot find the best solution for my problem.

I made a C++ application which runs on a Kiosk under Ubuntu that needs to store and retrieve data from a MySQL database and these same data need to be accessed from a remote web application.

These are the requirements:

  • The kiosk is connected to Internet, but we cannot assume that internet is always available
  • The kiosk need to always access to database because the users can access the kiosk services only after the login (user data are stored in the database)
  • the remote web application needs to insert or modify data stored in the database

At the moment, I'm using a local MySQL database installed in the Kiosk with PhpMyAdmin and the application directly access the local data. Then, I used cron to upload the database once a day, then I import the database on my server in order to be accessed by the remote web application.

This is really a bad solution, so I would like to find another one. What do you suggest?

I would like to have a database on my server and let the remote web application directly use it and receive updates from the Kiosk.

6
  • 3
    2 MySQL servers. Master-master replication. – Akina Nov 24 '19 at 18:55
  • Is it possible to implement this by using phpmyadmin or is it a more complex procedure? On the remote database I can only use phpmyadmin and i have no chances to send commands from terminal. I have full access to my local machine. – Marcus Barnet Nov 24 '19 at 19:03
  • Remote (DB, server, app, etc.) heeds in your data? Well, let them give you something - normal access to DB, at least. – Akina Nov 24 '19 at 19:24
  • I have normal access to the database, I can use everything available in phpmyadmin but I cannot execute shell commands. – Marcus Barnet Nov 24 '19 at 19:55
  • I have normal access to the database Access via PHPMyAdmin is NOT normal access. – Akina Nov 24 '19 at 20:00
0

Remote access can be had if you provide suitable GRANTs for hosts other than "localhost".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.