[plug] mysql database corruption

[David B. Reyes]

Hello to the PLUG community, How does a database become corrupted? For example, if you host an online game site that plays bingo(http://www.bingocanada.net), and run a tomcat server with MySQL as database. You monitor continuously if the game server process is up, as well as the tomcat web application server. But what if the monitor program, say it's written in java, doesn't inform you that the game server is down. The game produces errors... so that it doesn't function properly. You type tail -f nohup.out to check for errors. Isn't it correct to say, that if you suspect that the database is the problem, before killing the mysql process via (bin/mysqladmin -uroot -p shutdown)... ,don't you have to kill the other processes that rely on the database, like the game server (bingocanada.net), then kill the web(tomcat server)second, before finally killing the mysql process and restarting it? Just asking. Thanks. David Reyes

---

Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup