0

I have a demo site which is open for public access to login, view, and try out our website.

The data is editable for public so I am refreshing the database of this demo site every midnight local time. Refreshing here means dropping the entire database and then re-importing a template database. The database I'm running is MySQL 5.7.

The problem is that there is a 3-5 minutes downtime when my script is refreshing the database.

This is not an issue for the clients on my timezone as it's midnight here but on the other side of the world, customers are complaining as they think that the demo site is down for some reason.

How do you approach this issue? I believe a lot of sites provide demo sites and they should refresh their data on a constant basis too (daily in my case).

Thank you!

avn
  • 113
  • 1
  • 14
  • By “refresh data” do you mean wiping out all users’ edits and restoring an original known set of data? I suggest editing your Question to explain in more detail exactly what work must be done. And mention what database. – Basil Bourque Jun 04 '18 at 01:42
  • Thank you for your advise, I have edited my Question. – avn Jun 04 '18 at 03:17
  • What exactly is your technique for recreating the database? – Basil Bourque Jun 04 '18 at 05:13
  • It's actually just a simple shell script which will drop, re-create, then re-import the db from the template db. – avn Jun 04 '18 at 06:33

0 Answers0