Global Update(MySQL, Issues, Etc.)

[bigjoe4]

cool it looks like your almost finnished

 

[easyfreezone]

Hello,
my website easyfreezone.com on the absolut server is up but easyfreezone.com the wordpress blog about 40-50 posts is missing and many of my links and pages.

Also my easyfreezone.com/forum smf forum a lot of posts and all my members are missing.

I think it went backtrackked or my mysql database had a problem or something. Can you fix this?

Or is the server still fixing or restoring.

Again my website is on the absolut server

Thanks, but my site been up for 2 days

 

[kumar]

i am still having issue with cpanel, ftp server, and the site it self....I'm on the adfree.
pvchat.x10hosting.com
HELP!!
Thanks for me so reliable
kumar

 

[XainFaith]

Well I can log in VIA home page of X10hosting but thats it i do not have a site or a cpanel login that works properly. My cpanel login username is XainFait

Site is HexDollSoftware.x10hosting.com

Thanks for your replys Regards XainFaith

 

[kamcraft]

It still says "Stoli in the process of being backed up to the backup server." are you guys still backing that up or have you started working on it?

 

[deadimp]

Read the Main Announcements, and please take into consideration what they're doing.

 

[longley]

oooh. Back to what this thread was originally about, Mysql is back up on cossacks. I can work on my forum.

EDIT: I said it too quickly, Now the server is completely down..haha This makes me laugh for some reason. I am just happy to know that they are atleast trying and are a hard working crew.

 

[mbf222]

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 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.

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.

Please i need this page what can i do to ????
Edit:
Please i need this page is too important for the band

 

[longley]

Please i need this page what can i do to ????
Edit:
Please i need this page is too important for the band

If your asking what you can do to get your account working, right now nothing if you not on the absolut server.

If really needed, you could upgrade to a paid server and not have any problems, just know there is nothing you can do.

 

[kamcraft]

First post hasn't been edited in 2 days can we get an update?

 

[Sohail]

I'm on Absolut and the MySQL databases show up in the cPanel, but if you go to a part of my website like http://sohailtech.com/joomla/ which uses a database then it doesn't seem to work. Do you know how to fix this??

 

[adamkrem]

LOOK PEOPLE.

LEAVE THE ADMINS ALONE AND USE THIS TOPIC FOR WHAT IT WAS MADE FOR.

GOSH. NOW YOU GOT ME YELLING.

ugh.

Now quit posting things that you were told don't go here and post them where the belong.

 

[Sanchises]

How long will my site be offline (sanchises.x10hosting.com)? couple of hours when my account is copied or the entire update time for all accounts?

 

[spaceforce]

Joomla won't work and I don't know why. All I found was that in phpMyAdmin it says "Your PHP MySQL library version 4.1.22 differs from your MySQL server version 5.0.45. This may cause unpredictable behavior."
Can you help?

 

[hyperforce]

I just read trough the last few pages of this thread (and the first one offcourse) but though many people can actually access they're accounts I can't even log in, this is what I get:

"An Error Has Occurred
Although you've logged in successfully, there was an error retrieving your account's hosting type from the backend system.

Please post on our forums to seek support on this issue."

and so I do.

 

[DizzyTechnology]

Any updates? And will the server IP change?

 

[kamcraft]

Any updates? And will the server IP change?

No, and No I believe.

 

[taekwondokid42]

I'm kinda ticked at some of you...


There are other threads for many of your posts. Becuase you are posting it here we run into two problems.


1. I have to scroll through pages just to see if my question got answered.

2. The admins may not even bother reading all of the posts because so many are off topic



Question: How far along are you guys (the admins) on the project as a whole? 50%? 40%?



I'm in cossacks, when do you think that I can expect to have my account working at full speed again?

 

[longley]

I'm in cossacks, when do you think that I can expect to have my account working at full speed again?

I am in cossacks too and it keeps being up and down, yes something like an update would be nice but don't push it.

 

[manson]

My database is still not restored and i'm freaking out!