Wondering what’s been happening with the offline problems and loss of some posts? Here’s DU’s sys admin, Marc Perkel, to explain it all.

And for those who keep popping off in the comments to posts about Windows or Mac, tell us again why Linux is the future and we’re all idiots for not seeing the light?

Here’s what’s happening.

In order to spread the load and increase capacity I was trying to move the MySQL server to another computer with the main server handling the web and the second server running the MySQL database. Even though I have 8 gigs of ram in the main server every now and then for some reason I can’t explain memory usage soars the the server quits working due to high load.

Most all applications talk to MySQL through “localhost” that resolves to IP address 127.0.0.1 port 3306. Normally moving this service is trivial. I just shut down the database on the main server, move the database to another server, start it up there. Then I set up an SSH tunnel that pipes requests from the main server to the new server by intercepting requests and transporting them over TCP. Generally this just works.

However…

The morons at MySQL decided to redefine the meaning of “localhost” and when an application uses “localhost” the client libraries force it to be redirected to talk to the Unix socket /var/lib/mysql/mysql.sock instead of the TCP port. Why they did this is crazy beyond belief but there’s no way to override it short of downloading the source code and fixing it and recompiling MySQL which is the standard answer that you get whenever you complain too much about Open Source.

I however don’t give up so easily. I found a Linux utility called “socat” (socket concatenate ?) that allowed me to create a fake Unix socket and pipe it to a TCP port. And it worked – for a while. But it wasn’t reliable. As long as I was awake and in front of the computer it worked fine. But as soon as I went to sleep it shut down. So I wake up to a mailbox full of “my web site is down”.

So – I put it back on the main server till I find a real solution.

But – this is yet another example of why open source will never fully replace paid for software. If you have a commercial product people can call up the vendor and scream at them to fix bugs. When I sold commercial software and someone called me needing something fixed or added I usually had it the same day. However in the open source world you have a lot of people who have a highly inflated sense of importance who think their software is the greatest thing that was ever written and it’s crap!

What it comes down to as far as I can tell is the VI editor that comes with Unix causes brain damage. I’m totally serious about this. The VI editor absolutely sucks. It’s years behind editors I got with DOS 20 years ago and is an example of how to make an interface that totally sucks. I have refused to learn this editor because I find it offensive. I do most all my editing with a Windows editor, Textpad, and I run Samba on the Linux boxes so that I can mount them from Windows. That’s because there are no good editors in the Linux world. Other than that I use Pico which is a great little Unix editor for quick and dirty but still isn’t up to the kind of power I had in DOS or even CP/M (Wordstar) which is a better editor than any text mode editor in the Unix world.

I’m still waiting for Linux to catch up to CP/M!!!

My theory is that when people use VI it lowers their standards as to what good software should look like and causes their minds to physically alter in a way that leads to VI syndrome leading to delusions that their little piece of shit software is the greatest program in the world and that they are just so superior to microsoft that it’s just a matter of days before Microsoft collapses and everyone accepts Linux as God.

But what the open source world doesn’t get is that Windows programs actually WORK! If you want to install a windows application you download it, click NEXT, AGREE, NEXT, NEXT, NEXT, FINISH and the program is running. In the Linux world this almost never happens and when it does you’re almost sure that something has to be wrong. In Linux you have to edit cryptic config files with poor documentation. Then you try to run the application, get an error, Google the error, and go back and edit again. After many hours you might have it working or you might have to give up.

Out here in the real world localhost = 127.0.0.1 everywhere EXCEPT in MySQL. Not only did they hard code the bizarre behavior but have no way to override it. In fact they do the opposite. Whatever you set the configuration to they override it and force you to use the Unix socket. So doing something that should be simple becomes a nightmare. And you can’t talk to them because they have VI syndrome.



  1. YES says:

    Yeah, it’s about time someone has the you know what to say what everyone is thinking. Open source is NOT always the best choice.

  2. oroboro says:

    You’re absolutely right. Open-source is always garbage.

    Sure, Windows apparently has loads of security holes and is incredibly unstable. Somehow though, in the last 5 years of using XP on my personal desktop, I NEVER once had a BSoD and was never attacked.

    Just take a look at the bug reports and feature requests. OpenOffice has had a request for dashed borders since 2001, but the f*cking stuck up developers have refused to do a thing. I’ve used open-source libraries and every single one so far has had some bug or limitation that has required me to go into the source code and fix or add.

    Open-source bugs get fixed fast my ass. It’s right there in front of your faces – major bugs that haven’t been fixed for nearly a DECADE. Firefox STILL has the text search bug and crashes even faster than before.

    Ever wonder why not everyone uses shitty open-source software? Because it sucks and is unstable and open-source is ALWAYS filled with bugs. The only Linux programs I haven’t experienced bugs with after BASIC usage are the ones that have been out for decades and command-line tools.

    If you run the program yourself and experience bugs with it within the first 5-10 hours of using it, why the f*ck would you release it unless under beta? Maybe, it’s because you’re a stuck up f*ck who thinks he’s the best.

  3. Ronaldo says:

    The difference if MySQL was closed software is that you will never learn that they are using unix sockets for local addresses and would never have the freedom to change it.

  4. Bill says:

    As a developer who has worked with both linux/java and NT/C# as a sysadmin and web developer, I gotta say that the price paid for microsoft software more than makes up for the time saved not having to read documentation, hunt down prerequisites, etc. when setting up a server. Also, development in C# and ASP.NET is far more rapid and painless than any open source solution I’ve seen. And to those who bitch about having to pay MS for support, I’ve only had to call their support once, but once they realized it was a problem with their software they refunded me the $50 support cost. Again, even paying the $50 for immediate support is worth it since its less than I get paid per hour. All I ever hear about from linux people is that their software is free, but time is money and the time and productivity I’ve lost trying many OSS solutions isnt worth the savings in software costs. Just my opinion.

  5. Oh man you are so right about this. Linux sometimes sucks so hardly.. It is better to transfer all the business to Windows and live with the smile on your face. I had never had any problems with microsoft products in my life. Btw thanks for keeping your website up!

  6. john says:

    God I’m glad you geeks have no sway or voice in this world squabbling about the absolute pointless to bolster egos attached to Linux and Open Source lol. It’s pathetic.

  7. From your side you are absolutely right regarding Linux is the future but you think other site, many peoples necessary is Windows or Mac. By the way thank you! I found this very useful for me. Contributions like this help to develop a good understanding about the subject and gain a detailed insight of it. Further Novices like me get to bud themselves to advance and stay upfront in the cold & competitive industry.

  8. Marty says:

    I disagree! Openness doesn’t mean insecurity or anything like that. It means opportunity for further developments.


0

Bad Behavior has blocked 5306 access attempts in the last 7 days.