Odamex Message Boards
Community Discussion => Devoblog => Topic started by: Manc on November 10, 2006, 08:17:02
-
So yeah you probably came here earlier and noticed strangeness with accessing most features. There's still some funky mysql server stuff going on that I THOUGHT I curbed but it's not really doing much better than before. The process to fix it is going to be a bit daunting as I personally don't care for messing around with the server software, but I guess I have little choice. I hope maybe some time this weekend will come my way.
-
Thanks for fixing it Manc!
Good job.
-
Quicker than any of us, that's why your in charge.
-
mysql gets me too sometimes, I use php-nuke so the problems are similar. Was it the php or the bugzilla module you guys use so heavily?
-
mysql gets me too sometimes, I use php-nuke so the problems are similar. Was it the php or the bugzilla module you guys use so heavily?
While it might be php related in some fashion MAYBE, what happens is the innodb indexes go foobar and it tries to restart itself. Ususally if you attempt to visit the site and there's a bit of a delay that's due to the mysql server restarting. When it can't restart itself, it goes boom.
-
did someone say something about the site being down?
-
While it might be php related in some fashion MAYBE, what happens is the innodb indexes go foobar and it tries to restart itself. Ususally if you attempt to visit the site and there's a bit of a delay that's due to the mysql server restarting. When it can't restart itself, it goes boom.
Yeah, PHP/MySQL will do that sometimes.
Do as follows for your next scheduled maintanance:
Check that you have the latest versions, and then make a local mirror on your LAN.
Make a re-installed mirror on the same LAN,
transfer the information after checking for any "nastys" ranging from errors to malconfigurations to trojens and worms,
than mirror an image of that overhauled system back up to your main server on your next scheduled maintainance.
Much better than the simple "live patch" solution everyone recomends, as you only have to shutdown long enough to switch the active image from the old one to the new one, which is a quick reboot of the virtual server or real server, whichever you currently use.
-
While I appreciate your rather direct "advice", I have my own plan of attack. I have a script that backs up the databases, then I'll just pull mysql down and put up a new version from source. I don't have a LAN setup currently and quite frankly something like that is a bit more complicated than what the actual situation calls for. I do regular backups of everything that's important.
I would however appreciate in the future if you didn't simply tell me what I should do. If you want to offer your own brand of advice, I won't stop you (unless it goes against the rules), but know that I'm not just going to do what you say because you tell me to.
EDIT: Also, live patch? I'm not sure what you mean by that...
-
At least you caught it before it turned into a huge problem! Go Mancse!
-
I would however appreciate in the future if you didn't simply tell me what I should do. If you want to offer your own brand of advice, I won't stop you (unless it goes against the rules), but know that I'm not just going to do what you say because you tell me to.
EDIT: Also, live patch? I'm not sure what you mean by that...
Oh, I don't expect you to take my feedback as raw advice, just listen to it. I look at things from a much different angle. It sometimes can be useful to get my perspective, as often you need to combine both for a complete solution.
BTW, you are taking my advice like a textbook, a test lan can be a couple of old computers, or even a few VMs on your main desktop.
Be interpretive with advice. Stuborness is an inevitable human trait that every person here has including myself and we each also have our own viewpoint. However, if each one of us uses 1% of the logic possible to be gained from reading each other person's viewpoint, we all would become far better at everything.
When I give what you call advice, it may be phrased as such, but it is more a proposed theory, than advice. Maybe it's a little old-school to think that way, but sometime's it helps to compair theoretical notes. Maybe I need to scale back a bit on the frequency of reporting such notes, and we can meet somewhere in the middle.
-
Manc, good job.
-
gj gj...
i like any bugfixing