Deleted 0 #1 June 1, 2001 Heya boys and girls,Well is this just a royal screw-up or what!! Bwhahahahaaa! So, have not been getting much sleep - it seems like the mySQL deamon (never trust them deamons!) which is supposed to keep the database that runs these forums, and a lot else on the site, sane has mucked up!I have no idea how to fix all the BAD except for to make the site take a few steps back. So, in the next day I will probably restore the entire site to where we were on Monday night...nothing like a bit of time traveling! At the same time I have started to set up a new environment on a dedicated server. It's going to cost and arm and a leg but I'll take the hit and then actively try to find a few advertisers to help me off-set the cost. The good is.. once the new site is up...it should fly!So...1) Step back to Monday on the current server2) Hope the mySQL deamon holds for the weekend3) Migrate to the new server in the next weekExpect a bit of a bumpy ride...but hang in there with me! Safe swoopsSangiro Quote Share this post Link to post Share on other sites
Deleted 0 #2 June 1, 2001 HH - let us know of any of the dz.com tech-heads can do anything to help. Also, would you like some of us to try to sell some ads for you? I would be willing to coordinate inventory and trafficking and make a few calls if you would like.Carl Quote Share this post Link to post Share on other sites
Deleted 0 #3 June 1, 2001 Sometimes restoring from backups is about the best you can do. Thank God for 'em though huh?Being one of the tech contingent, my natural curiosity is piqued. Did the main server get overloaded during the chat and crash?I noticed you have a paypal link. If we send you some cash will that help you get a better server?Best of luck & keep up the good work!---------Zennie Quote Share this post Link to post Share on other sites
Deleted 0 #4 June 1, 2001 Also out of curiosity, could you use postgresql instead of mySQL? It's been a while since I've worked on the *NIX side of things, but I remember postgresql being pretty popular. Dunno if you can wire it into your board software or not.'Course there's always Oracle, but that may be overkill. ;)---------Zennie Quote Share this post Link to post Share on other sites
Deleted 0 #5 June 1, 2001 Hey Zennie,The muck-up started before the chat session on Wednesday - I'm not really sure what caused it but I started doing some research on the web and found quite a few cases where other folks, using the same Host as I had problems with the mySQL deamons on their servers. So, my guess is that my data has simply reached a volume where it needs to be re-indexed and something small got it out of sync. From there it's easy to see the gradual decline in data integrity... like the foums now not recognizing anyone, a problem I didn't have last night.I'm going to stick with mySQL for a variety of reasons, no the least being that as litle as I know about databases, this is the one I know the most about. Also, it is the prefered database to run with PHP - which is probably where I'll start moving the site to over the next couple of months. The mySQL/PHP combination is very powerful and there's a large open-source community out there developing scripts for that combo - that helps with finding support and answers as well.As for the PayPal account - anythig would help! The setup cost on the new server would be around $300 and then about $500 per month afterwards! Don't fret about the money too much though! Safe swoopsSangiro Quote Share this post Link to post Share on other sites
Deleted 0 #6 June 1, 2001 I may be able to secure soem advertising income for ya if you would like to email me $$$ detals and the like when ya get a chance. Quote Share this post Link to post Share on other sites
Deleted 0 #7 June 1, 2001 duh-anonymous cyber above - webmaster@sunraydesigns.com Quote Share this post Link to post Share on other sites
Deleted 0 #8 June 1, 2001 Hey Sangiro !I know I speak for everyone when I tell you how appreciative we are for everything you do, and all the headaches you must endure, to keep "OUR" site up and open for business. Just from reading posts today, and a few e-mails back and forth from some of the regulars here, I keep hearing the words "work is boring" and "I felt lost without my forums" and "I got a lot done today since I wasn't jumping on the site every half-hour" -- it made me stop for a moment and think of how many snippets of time in a day I check ya'll out, even if it's only for 5 minutes between meetings or something of the like.I wish I was a cyber-genius like so many of ya'll seem to be, but all I know is to hit the POWER button, then start typing -- if you get me out of our internal system here at work, I'm lost. If I lived closer to you, I'd offer to come over and mow your grass, or wash your car, or at least do SOMETHING helpful -- maybe you could use me as a gofer, or a guinea pig ( as in "Hey, Don, hold these two bare wires while I hook this up, then touch them together when I say OKAY !).Your efforts are mucho apprecianado by us all......The PLF King Quote Share this post Link to post Share on other sites
Deleted 0 #9 June 1, 2001 Hey Sang. I've been a lead PHP + MySQL programmer for about 3 years now so let me know if you need any help when you make the code switch.Never had any probs with MySQL over the last few years, but then I'm not doing many inserts or updates, just selects.-MarkM Quote Share this post Link to post Share on other sites
Deleted 0 #10 June 1, 2001 Quotekeep hearing the words "work is boring" and "I felt lost without my forums" and "I got a lot done today since I wasn't jumping on the site every half-hour"I dunno, I was able to waste most of my time at work today even without the forums. Could be because today was my last day, and I'm headed to the DZ to buy a rig tomorrow though... QuoteI know I speak for everyone when I tell you how appreciative we are for everything you do, and all the headaches you must endure, to keep "OUR" site up and open for business. I second that. On the eighth day, Sangiro created Dropzone.com, and there was much rejoicing throughout the land. Blues, squares,Anonymous*Insert anonymous sig here* Quote Share this post Link to post Share on other sites
Deleted 0 #11 June 2, 2001 Ya, what Kingy said -- me too!Thanks, Bossman!Frank Quote Share this post Link to post Share on other sites
Deleted 0 #12 June 2, 2001 HH,Did you perhaps hit the 2GB table limit on MySQL? The newer versions of MySQL have the ability to store a table across multiple files to prevent this from happening. Sounds like you might want a couple indices on some tables too.The Dutchboy Quote Share this post Link to post Share on other sites
Deleted 0 #13 June 2, 2001 My God, there are 2G tables on dz.com?The forum has about 20k postings, each of which is well under 1k, but if they were that big, it would still only add up to 20M! We just passed 3000 users, which to get to 2G would mean that each row was over 6.6M!By the way, Linux, Apache, mySQL rocks! Had to be said.Quote% telnet dropzone.com 80Trying 216.122.89.120...Connected to dropzone.com (216.122.89.120).Escape character is '^]'.GET / HTTP/1.0HTTP/1.1 200 OKDate: Sat, 02 Jun 2001 12:01:59 GMTServer: Apache/1.3.1.1 SSL/1.15 PHP/4.0b2Connection: closeContent-Type: text/htmlDropzone.comDude, you are too cool. Quote Share this post Link to post Share on other sites
sangiro 26 #14 June 2, 2001 Ok - Steps 1 and 2 completed! Safe swoopsSangiro Quote Share this post Link to post Share on other sites
skreamer 1 #15 June 3, 2001 Quotemy data has simply reached a volume where it needs to be re-indexed and something small got it out of sync. From there it's easy to see the gradual decline in data integrity...PHWOARRRRRR!!!! That ranks right up there with Sis talking dirty in the Pub!/s Quote Share this post Link to post Share on other sites
