locked
mySQL shows deleted data RRS feed

  • Question

  • We're running mySQL on Azure. We have three very small databases.

    The main DB is POI and it hold 11 static records. During the day a few records may be added and deleted again within 1-2 hours.

    We typically have 5-10 mobile users which polls the POI-DB for all 11-15 records every 60 seconds.

    Several times every day, we do get some corrupt data from our sql query. We often see two records which were deleted from the DB two months ago. What can make such a simple DB become unreliable?

    Kind regards

    Freddy

    • Server: eu-cdbr-azure-north-d.cloudapp.net via TCP/IP
    • Server type: MySQL
    • Server version: 5.5.45-log - MySQL Community Server (GPL)
    • Protocol version: 10
    • PHP extension: mysqli 
    • PHP version: 5.4.42

    Tuesday, November 10, 2015 11:30 PM

Answers