Friday, July 13, 2007

Database Error and Repair

Friday, July 13, 2007, 2:05 AM Eastern (UTC-4 America/New York): Around 2:05 AM, the database stopped displaying new visitor counts -- but continued to record them -- due to a system error. We are currently working on this problem and will post an update when the repair is complete.

Friday, July 13, 2007, 9:19 PM Eastern (UTC-4 America/New York): We have repaired the database. The MySQL Slave databases that display stats reports on the stats.php page stopped working when the MySQL Master database submitted a duplicate entry error. (This is the first time that such an error has occurred since we launched the new system in May.) We purged the servers and synchronized the master/slave databases to make sure that all new users who signed up today are still in the system.

We also have added a variable to our system that will prevent this error from occurring in the future. For those interested, further reading on this issue is found at howforge.com.

If you like this article, then click on this link to "Digg It" and help promote BlogPatrol.com. Thanks!

No comments: