hi. the process you describe is the "politest" way to shutdown a db. here are the implications of those steps: 1)killing the game server prevents additional input from new clients for your application. 2) killing tomcat forces it to close all it's open connections to the database (provided it's a proper shutdown, of course) and 3)killing mysql would flush it's tables to disk and bring it down.
theoretically, you only need 3, BUT with mysql flush tables command executed before the shutdown just to be sure. this would make all subsequent calls to your game server fail on db requests however and it's up to you if you want that seen by your clients. pag maganda db-error handling mo siguro it doesnt matter. --vince David B. Reyes wrote: > 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 > <http://rd.yahoo.com/welcome/*http://fifaworldcup.yahoo.com/fc/en/spl> > of 2002 FIFA World Cup _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
