December 24, 2005
Great management tool
I should have discovered this fantastic browser management tool for MySQL ages ago.
For an honest-to-goodness open source utility things cannot be better than this.
Posted at 5:16 PM | Permalink | Comments (0) | TrackBack
December 23, 2005
Don't try this at home
For awhile now, I have been wondering how difficult it would be to setup my very own MySQL Cluster on my home network? As it turns out, this morning when I woke up, I immediately sat upright in my bed and knew for sure what I had to do.
You see, the only way to really find out would be to try it myself. Roll up the old sleeves and immerse oneself in the technology so to say.
Downstairs I've got a couple spare FreeBSD machines lying around with memory to spare. Although I just have a plain-vanilla standard 100 Mbps Ethernet network (which is the minimum requirement according to the documentation though probably too slow), it should do the trick. Hopefully, that is.
For the management node, I can just use my laptop which once the cluster is up and running alright I can switch off and use for other things as required.
For those of you interested, I will chronicle my challenging endeavor as it unfolds, hopefully captivating my audience and even attracting droves of new curious readers. If in the long run I have been able to convert even one soul out there to the wonderful world called MySQL, then I will have been successful in more ways than one.
Here are some references for those wanting to know more:
Posted at 12:00 PM | Permalink | Comments (1) | TrackBack
December 16, 2005
Conflicts with installed packages
Was hoping that this weekend I could upgrade to MySQL 5.0 without a hitch, as I am eager to investigate all of the new possibilities in this wonderful database product upgrade.
Unfortunately, at first my FreeBSD development environment choked and didn't seem to allow a port install when an older version is still present. Think, think...
First of all, mysql-server would not install because of the wrong version of mysql-client which was present, and then when I tried to upgrade the client it shouted back to me that it: conflicts with installed packages. Think, think...
But wait a minute. By simply 'forcing' a deinstall with pkg_delete -f mysql-client-4.1.15 and then pkg_delete -f mysql-server-4.1.15 and then doing a make install clean for the client and then the server all over again, it worked!
Well, almost. In order to allow other applications to run correctly, it is necessary to do a make install clean for the MySQL 5.0 driver for the Perl DBI Database Interface: p5-DBD-mysql50-3.0002.
And then again, I later realized that my PHP4 and phpMyAdmin stuff were broken also. Drats. Deinstall and reinstall seemed to fix things alright. Maybe a bit of an overkill, but in the long term it probably would have taken me much much longer to figure out the better more elagant solution than just throw everything overboard and begin anew.
Rumor has it that with the new NDB storage engine that introduces a quantum leap in mulitcluster partitioning, e.g. built-in clustering and automatic failover capabilities, MySQL has grown-up to become a leading competitor in the cut-throat world of high-performance databases.
Will have to continue this further at another time.
Actually right now, I still have to do my Christmas shopping which one would imagine is much more important than fiddling around with my FreeBSD server farm with state-of-the-art database capabilities. Not.
Posted at 3:33 PM | Permalink | Comments (0) | TrackBack
