Countdown Timer
Partners
The Latest
Blog Navigation
Posted on: August 2nd, 2010 by Famous Phil
This topic plagues me to death every time I need to do some administrative function MySQL simply because I don’t do it every day. I have 3 servers that I manage entirely via the command line now and all 3 require me to know at least some MySQL. Unfortunately, I always end up going to several sources to get all the information I need. So instead of doing that in the future, I’m writing this blog as a centralized reference for everything I need. Hopefully you can use this blog as much as I will!
Note: You will need to click the “show code” icon in the top right corner to view the code entirely for some of the blocks that are longer than the code box.
Tags: administration, cheat, command line, interpreter, mysql
Posted in Hosting / Server Administration, Programming
|| 4 Comments »
Posted on: June 20th, 2009 by Famous Phil
First I guess I should apologize for not posting anything in the past week here! I really hate it when I have to ignore my own blog for more important admin business elsewhere. The good thing is, I always manage to learn a lot of new stuff that I can easily share
Over the past week, I got a new server to host Microsoft Exchange which is a powerful email server from Microsoft. Before you go all crazy on Microsoft (I know I typically do), Exchange is one of the few excellent products they make. I am actually very hard pressed to find anything that compares to it that is open source and can easily run on Linux which 99% of my hosting business up until now has ran off from. Man, I never thought that I would say that
Tags: 1and1, 3dgwebhosting, active directory, Admin Reference, administration, Elite data hosting, email, exchange, exchange 2003, Exchange 2007, fsckvps, mailxchange, Microsoft, Microsoft Exchange, mobile, outlook, outlook web access, owa, server 2003, vaserv, vps, windows
Posted in Hosting / Server Administration, Mobile Technology, My Site
|| 3 Comments »
Posted on: April 28th, 2009 by Famous Phil
A good place to introduce this topic is by stating that I consider myself a “good” system administrator. I consider myself above average when it comes to Windows Server administration, and “average” when it comes to Linux server administration. Normally, regardless of platform (Linux or Windows), I usually know enough not to get myself into trouble, yet rectify the problem that is presented to me.
Prior to last October (2008), I have solved a wide array of problems consisting of Apache malfunctions and complete Server Hard Drive failures requiring data recovery, to simply having to unblock a person’s ip address from the firewall because they tried to login to the server incorrectly too many times. I never really messed a server up so badly that I couldn’t undo what I attempted to fix in the first place.
Tags: administration, blunder, delete, disk space, hosting, Linux, mysql, var, var/lib/mysql, windows
Posted in Hosting / Server Administration, Personal
|| 2 Comments »
Posted on: January 31st, 2009 by Famous Phil
As expected, I completed moving all of the websites hosted on the former mthsweb1 (Matthouse Web Server 1) server over to the new mthsweb4 server. I haven’t heard any complaints so far about the new server so far and don’t expect to hear of any problems. Tonight I will be doing some testing on the old matthouse web 1 server before it expires later in February. I hope to learn some new knowledge from my testing later tonight regarding apache optimization.
Earlier today, I helped a friend in the hosting business move a massive website (http://clevelandleader.com) from his server to a virtual server that will just host that website. This website is ranked ~76,000 on the alexa scale which means that it gets an insane amount of traffic. My best guess would be 300 to 1500 loads per second. The site itself has a huge mysql database that is over 2GB and the sql move alone almost crashed a dedicated server with a quadcore processor (it did have a lot of other websites on it though). Regardless, after the move, my friend didn’t realize that a default whm (cpanel, inc) installation doesn’t optimize the server nearly enough for a large website like this. Heck, I don’t even know if whm was made for such a large website. I did optimize the server and compile apache correctly just to handle the needs of clevelandleader.com. I also did a lot to prevent apache from crashing with the high load.
Traditionally, with such a large website such as cleveland leader, the web server hosting the site would only run a web server, no overhead like cpanel. I feel that cpanel has made the hosting process much easier, but I just don’t think it was made to handle such a large website. Also, the fact that cpanel uses the root password directly means that if there is a security vulnerability and the user obtains that root password through hacking or whatever, the server could be compromised not only from cpanel’s whm but also from the terminal through ssh (or a rare occasion of console access, meaning sitting in front of the server physically). This could present a major problem. Most smart hosting companies use cpanel’s wheel group to give su access to certain cpanel uesrs that can then login to the terminal via ssh and then su root with the root password to gain root. This provides a 2 password layer and adds an additional layer of security to the server.
Another pitfall that large websites face is the need for a dedicated mysql server, that is if mysql can even handle the load. Mysql was made for small to medium sites and it was made for maybe 100 to 200 queries per second, but much more than that and it undergoes a massive strain. Many large websites find themselves moving to more powerful database servers such as Microsoft SQL or Oracle which are much more powerful solutions that were made for high loads.
So why am I even talking about this! I felt that this would be the best way to introduce a new idea that I’m going to begin working on within the next couple of weeks. I have purchased the domain (http://adminreference.com) and will begin a forum where users can share their administration experience and knowledge to the world. I am a seasoned Windows administrator and a somewhat experienced Linux admin. I find myself knowledgable about both server operating systems and I post tutorials on multiple websites that don’t really aim for administration concepts. I also hope that some day this can help me when I am stuck on a massive problem.
I encourage you to stay informed as I begin this new journey. I will likely be ready to release the site sometime in the next couple of weeks. I am not sure how to market such a website, however I’m sure as people begin coming, someone will have knowledge about that as well.
Tags: admin, administration, facebook, help, hosting, Linux, Microsoft, Personal, reference, server, Server Hosting
Posted in Hosting / Server Administration
|| 6 Comments »