Archive for the ‘mysql’ category

Open Source Acquisitions

March 28, 2008

If the likes of MySQL can be “bought” by the likes of Sun. What keeps an Apache or any other really popular open source movement from being similarly snapped up? In the end I think this is a really healthy trend. I’m more interested in the mechanics of the deal.

And, who does that check get written to? Who are the beneficiaries/stakeholders in an open source acquisition? The managers of the OS initiative? The developers? A little bit of both? Something else entirely?

For instance, let’s say WebKit gets bought out. How does a business deal like that work!? Or, how about Apache… Hmm? Before you say “That couldn’t happen.” I’ll give you that you may be right. But, also keep in mind, MySQL wasn’t for sale… Until it was.

Makes me wonder if the whole LAMP stack might one day be pwnd.

Sun Buys MySQL

January 16, 2008

What a kick in the pants THAT is. $1 Billion for an open-source platform. Who the hell do they write the check to?

Here’s the Money article.

Here’s Dr. Schwartz’ article.

Jesus Marimba that’s a big pill to swallow. Wonder who owns Postgres and what their prospects look like?

GCC4.0 Problem Solved

August 18, 2007

I’m in the process of installing Ruby, Rails, Subversion, Mongrel and MySQL on the MacBook Pro. Problems reared up fairly early into the new and improved process I originally followed from HiveLogic (which, btw, I highly recommend).

So, here’s what I was running up against while installing readline via the terminal:

C compiler cannot create executables

There’s nothing readily available via Google. So, it dawned on me… My default compiler was showing GCC3.3. Well, that’s obviously out of date. So, I peformed this

sudo gcc_select 4.0

And, now, my readline has configured and completed its make just fine. And, 25 minutes later still I’m full tilt gonzo. Awesome!

Scaling Ruby On Rails

June 26, 2007

There are a few really good slide shows over at SlideShare on the topic of scaling Ruby on Rails. I’m also interested in scaling MySQL and large scale architecture if you have any particularly crisp presentations in your sights out there.

I had hoped to go to Google last week and participate in their Scalable Computing workshop/presentation. Other arrangements fell through. Ah well, Dare Obasanjo has some really good notes

YourSQL – Superb MacOS X MySQL Tool

June 1, 2006

Earlier a friend turned me onto an uber db management tool called DbVisualizer that I just never quite got working. So, I wratcheted my appetite down a bit and found YourSQL this morning. This darned thing JUST WORKS! I’m in and munging around the db’s and tables and the data like no one’s business. I didn’t mind tinkering at the cli… But, c’mon. Time is money! And I highly recommend YourSQL!

Couple this with the cli, Mr. Zawodny’s book on MySQL and I think I’m gonna geek out for a while this summer.

Currently listening to “Guns On The Roof” by The Clash

MySQL, Tiger Server 10.4.5 and mysqlManager.plist

March 2, 2006

A bit more technical than my usual posting and most definitely over my own head. But, there will be those of you out there (if not now, soon) who will face this very problem:

I just upgraded all three of my Tiger Server boxes to 10.4.5 from 10.4.3.

All but one of them made the transition beautifully. The problem child has JBoss and MySQL driving a vertical search site pushing over 800,000 documents. Well, after reving to 10.4.5 this server decided to no longer respond as before. So, for those of of you out there who have yet to bite the bullet and go to 10.4.5 (or for those who are researching what has gone wrong after your upgrade) here’s what got me out of the weeds. A VERY SPECIAL THANKS TO MY MIRACLE WORKER – FRED TOTH! Who loves ya baby!?

Ok, so after your upgrade, jboss was reporting

“can’t connect…”, and “connection refused” when it tried to
talk to mysql.

mysql command line connections worked fine.

The java connection information (within the jboss config) looks like
this:

jdbc:mysql://localhost:3306/aapg

Note that this specfies a TCP/IP connection to localhost, port 3306. Manually
testing that port also yielded “connection refused”.

However, on the dev system, I can connect to port 3306 with no problem.

I noticed in the process table that mysqld was running with “–skip-networking”.
That didn’t sound right! Documentation says “don’t listen to network ports at all”.
Again, the dev server did not have “–skip networking”.

So somehow the upgrade changed the mysqld startup options.

Finally, and partly by luck, I found the file “/etc/mysqlManager.plist”. It was timestamped
today and contained:

allowNetwork
no

Changing the “no” to “yes” and rebooting (because I don’t know how to start/stop
mysqld) cured the problem.

Thanks,

Fred

This indeed, fixed the problem and all is well in my world again. And, I sincerely hope it serves to help some poor schmo out there wondering how he’s going to fare when his boss invariably delivers the evil eye. Never fear. Solution is here!


Follow

Get every new post delivered to your Inbox.