Global Update(MySQL, Issues, Etc.)

[Nikolasr]

well corey is now upgrading the server and curectly we are on backup server then corey will format the server and re-install then move it back to stoli and sotli will go online

 

[azblue]

Hi Boys, I've been waiting for weeks to put online my final website.
I know it's free, but could you tell us when it will be ok. My site (the in construction one) disapears all the time.
Thanx AzazeBlue

 

[nyllo]

Well, I don't have the suspended screen anymore, I think it's nearly done, and cPanel is back, I just type my URL of my site in and get an index of data, so I think that the HDD are being re-formatted with our accounts, still can't login to the normal x10 thing though.

 

[wheener]

I have been away since december 17th and it looks like things have been a bit chaotic, when did this all start?

 

[Dutch]

PLEASE make the server news and updates thread a sticky!!! Just look at all the completely USELESS replies, 50 pages worth.

After reading 51 pages, I understand this next sentence will be very confusing to a lot of x10 members, but here goes. IF YOU DO NOT HAVE IMPORTANT INFORMATION ABOUT THE STATUS OF THE SERVER, DO NOT POST HERE! :nuts:

 

[jtrash]

My account on Absolut lost the MySQL database again... is this a new problem or Absolut is not finished yet?

 

[nyllo]

Well my page has turned into an Apache installation success page...good, or the fact I still can't login to x10.

 

[Dutch]

:nuts:


:gives:


:lockd:

 

[GG-Xtreme]

I don't think people get it:
DON'T POST IN THIS THREAD ANYMORE!! ASK FOR SUPPORT AFTER THE UPDATE IS DONE!!!

 

[gfinlay]

All getting just a little too emotional and, in my humble opinion, abusive. I respectfully suggest we can do with a bit less shouting, and crude "smileys", and a bit more "real" information from the important people doing the work.

Corey,
Please let us know exactly where we can go to find out latest status and progress. The first post in this thread has not been updated for quite a while now.

Thanks
Gordon

 

[bigjoe4]

Yeah!

 

[aneotoena]

Well let me tell ya where you can go!

No seriously let him work, he is working and posting updates just makes him waste time. You won't get your sites working based just on updates. Just wait.

I am sure I am not the only one visiting this thread 3 or 4 times a days just because we see there are "new posts" and we think it may be corey saying smthng, but it's just people asking for updates or for support.

 

[NeonWarrior]

man this sucks, how can it take so long >>... i mean yeah i know nohing of servers but...meh...im just stressed at my club nagging at me "why cant we acces the website?" and its like "dont get me started..." cuz they wouldnt understand

when stoli will be all better again so he can come to play? D:?

 

[gfinlay]

aneotoena,
Thank you, I just sympathise with those that are frustrated with the lack of news. Fortunately, I am not one, and you now have one poster less to lecture. Bye.

 

[joseph0829]

so what's up with Stoli?

 

[nbaulch]

Update, Please Read Entire Post

Summary(For those with short attention spans).
1.) MySQL is messed up, we are moving it back to local.
2.) We are replacing our secondary 250GB drives with SCSI drives solely for MySQL.
3.) We are taking this time to format the servers and set them up efficiently and correctly.
4.) I ordered another server solely for backups for this occasion.
5.) I will update the bottom of this post with the progress of our actions.
/End Summary
Our original goal was to move all databases from the free server to a single remote server to handle all MySQL processes. MySQL is the #1 resource hog on each server. By doing this we would eliminate the number one cause of lockups and stability issues. The implementation looked easy, the cost was only $250\mo, easy decision. Wrong. We started having issues from the start. We knocked them out slowly one by one. One issue took a whole week, going back between our Datacenter and cPanel. We were finally were told that it's a cPanel bug and may be fixed in the next 3 months. Obviously not a good answer, we investigated and came up with a work around.

This brings us to our very last and most recent issue, PHPMyAdmin. Since we are a free hosting company and on occasion stress software to it's breaking point with our highly unusual usage, it makes it very hard for us to get support from the developers of software. Specifically MySQL and PHPMyAdmin. We were told many different things, tried A LOT of different things, and in the end decided to open a paid support ticket with our Data Center to see if they could figure it out. This brings us to the past two days. The data center had a collapse of communication between their technicians and downgraded MySQL on our database server to 4.1(We were at 5.0). This caused huge issues, on top of that the tech did not make a backup of the databases before doing so.

I exchanged some words with one of the managers yesterday who assured me he would take care of it and everything would be fixed. At this point I just wanted the databases back online, the PHPMyAdmin issue could wait. Well, another catastrophic miscommunication occurred. They made some stupid decisions and delayed the process of fixing things for hours. I got a call from Bryon last night while I was out to dinner for a friend's birthday(I have a life sometimes) informing me of the ticket updates. I then spent 45 minutes on the phone outside going over everything with a tech. They finally got the database server back up this morning. There are of course issues with some databases because of the downgrading and upgrading. We have about 15 backups from the past week that are floating around, we will get everyone databases back up and running when we resolve this.

Where we are at now? Without a definitive answer for PHPMyAdmin in sight I have made the decision to move MySQL back locally, but replace the secondary 250GB HDDs we have with 73GB 15K SCSI drives at an extra cost and have MySQL run solely off these drives easing the burden on the I\O of the main drives. I have also decided that it would be best to format each server one by one and start fresh with all updated software. We've had so many updates, patches, fixes, etc(Apache 1.3->Apache2.2;ASP.NET Support, MySQL 4.1->5.0) over the past few months that these servers are not running anywhere close to efficient. By doing this each server will be 100% optimized and should be good to go for a long time to come.

Implementation. I have just purchased a server solely for backups. We are going to do this one server at a time by migrating all accounts to the backup server, formatting the current server, optimizing and securing then moving the accounts back. I'm hoping we can finish all this in the next two days for all servers. This is obviously not what I really want to do as it is going to cause downtime. But I feel that the overall improvement that we will get out of this will be worth it

So, please be patient, I am working as hard as I can on this. For those of you who have been with us a while, you know we will work as hard as possible until we solve these issues. We have a great team of staff members, and lots of drinks with caffeine, we will be around to answer questions until we are done. I will also try to keep everyone updated on our progress as much as possible. Thank you for sticking with us, we'll be back to 100% soon.

-Corey
You will not lose your data\accounts, this does not affect paid members, please excuse typos.

Progress:
Waiting for backup server to come online, ETA 2 hours.
Backup server is online, recompiling Apache, setting up MySQL, and updating cPanel to prepare for the account moves.
Server setup complete, copying accounts from Absolut over to backup server.
Final backup of whole hard drive before format
Format and reinstall in progress.
Copying Absolut backup accounts back to Absolut.
Absolut back online.
Stoli in the process of being backed up to the backup server.
2,500 Accounts copied, 1,100 to go. 10:30PM EST 11/16

NOTE:
New account creations are currently off until Stoli is finished. All accounts are being put into a queue to be created after.





Upgrade Optimization Order:
Absolut
Stoli
Cossacks

F.A.Q.
Q: Will this move everything back to localhost?
A: Yes, all config files and such will have to be changed back to localhost

Q: Will I lose anything?
A: You should not lose anything, we have multiple backups of everything. Worst case you might lose a few hours of updates from MySQL while your account was being copied between servers.

Q: How will I know when it is done?
A: I will update this post as we complete stages.

Q: Does this affect paid services?
A: No, these move and updates are only going on for free servers.

Do not post support requests here, I will not answer them. Legitimate questions are okay to ask.

QFT

 

[joseph0829]

QFT

ITS BEEN 4 DAYS NOW AND STILL THE STATUS FOR STOLI IS THAT??? HUH?

 

[kamcraft]

Stoli in the process of being backed up to the backup server.
2,500 Accounts copied, 1,100 to go. 10:30PM EST 11/16

Any news since then?

 

[Adam01]

Yeah, how is the stoli server coming along?

 

[nbaulch]

ITS BEEN 4 DAYS NOW AND STILL THE STATUS FOR STOLI IS THAT??? HUH?

and i'm sure if the time was available then there would be an update.. as quoted from coreys' earlier post "So, please be patient, I am working as hard as I can on this."

also as stated many times in here your service is free and if you don't like it leave, if you read closely alot of effort is going into getting everything up and running and there has been setbacks but ffs these ppl do have other things to do ie: shower, eat, sleep etc.....

Also as stated "Legitimate questions are okay to ask." Many ppl are checking this thread 1-2 times a day... and statements like yours (and now mine) are making it harder for them to find coreys actual posts. Surely you can't think that your statement is such a stand out to actually get a response?
Take a chill pill, check back now and then and you'll get your answer

:rant2: :thefinger