I Really Like MySQL
I really like MySQL. I definitely would recommend
it for any enterprise database beginner with the only caveat being that you
should configure your /etc/my.cnf paying attention to using innodb as the
default table engine.....
Now I cannot say I recommend it over some other
vendors because I really have not extensively used any of the other brands of
enterprise SQL databases for production. I've fiddled with them on my dev
machine, but that's about it. Still, I feel compelled to write about MySQL
because it has served me so well for years with practically zero problems,
maintenance or support.
Now some may say that under certain conditions it does not work so well ..... I don't know. Here is the current view of our main mysql server just a few minutes ago using the free MySQL Administrator app.
The numbers above are per second. The biggest peak I have seen when monitoring traffic was about 1900 per second.... but, hey that's just our situation and this is probably peanuts compared to bigger companies. We run Gigabit networking between our servers since it is so cheap nowadays.
Our main mysql server is a Dual G5 "Cluster Node" XServe running Mac OS X Tiger *Client* edition (I did not see the point in spending $500 on OS X Server when that machine just runs MySQL) The XServe was bought on eBay for $995 in 2006. We run MySQL version 4.1.X. Another of the 4 XServes in house (a G4 XServe) hosts a couple of low traffic in-house WebObjects apps, shares files over ftp, samba and AppleShare to a half-dozen people and also acts as a MySQL replication slave. Offsite we have a remote MySQL server on a dedicated Mac Mini (!) replicating continuously over SSL. I *really* like that fact that replication is so simple to setup with MySQL and so reliable.
The connections count is low as you can see and these are a mix of WebObjects instances, a few back-office applications and some command line maintenance apps that run periodically. We use Connector/J 3.0.XX driver for all our apps.
The nice thing about MySQL is that it is easy to install and setup on your local development desktop Mac or portable Mac. It even has binary dmg installers for each Mac processor type. I compile the one on my dev machine, the in-house replication slave and the remote replication slave form source so that I can include SSL capability.
We have 5 databases on our MySQL server. The biggest table is just shy of 70 million records (it is a geography table with lat/lng data used for geographical radius selection of direct mail campaign mailing lists.). A few other tables are in the millions.
For me, MySQL stays out of my face and just works. I mostly, almost always, use the command line for interaction with it..... once familiar with it, it is not a big deal. There is even built-in command line help (type HELP; or HELP FUNCTIONS; etc.) I rarely, but occasionally use CocoaMySQL .... and I like the traffic monitor graph provided by the MySQL Administrator app.
What can I say........... except thanks to the MySQL developers for a great open source product and ........... I really like MySQL!
Now some may say that under certain conditions it does not work so well ..... I don't know. Here is the current view of our main mysql server just a few minutes ago using the free MySQL Administrator app.
The numbers above are per second. The biggest peak I have seen when monitoring traffic was about 1900 per second.... but, hey that's just our situation and this is probably peanuts compared to bigger companies. We run Gigabit networking between our servers since it is so cheap nowadays.
Our main mysql server is a Dual G5 "Cluster Node" XServe running Mac OS X Tiger *Client* edition (I did not see the point in spending $500 on OS X Server when that machine just runs MySQL) The XServe was bought on eBay for $995 in 2006. We run MySQL version 4.1.X. Another of the 4 XServes in house (a G4 XServe) hosts a couple of low traffic in-house WebObjects apps, shares files over ftp, samba and AppleShare to a half-dozen people and also acts as a MySQL replication slave. Offsite we have a remote MySQL server on a dedicated Mac Mini (!) replicating continuously over SSL. I *really* like that fact that replication is so simple to setup with MySQL and so reliable.
The connections count is low as you can see and these are a mix of WebObjects instances, a few back-office applications and some command line maintenance apps that run periodically. We use Connector/J 3.0.XX driver for all our apps.
The nice thing about MySQL is that it is easy to install and setup on your local development desktop Mac or portable Mac. It even has binary dmg installers for each Mac processor type. I compile the one on my dev machine, the in-house replication slave and the remote replication slave form source so that I can include SSL capability.
We have 5 databases on our MySQL server. The biggest table is just shy of 70 million records (it is a geography table with lat/lng data used for geographical radius selection of direct mail campaign mailing lists.). A few other tables are in the millions.
For me, MySQL stays out of my face and just works. I mostly, almost always, use the command line for interaction with it..... once familiar with it, it is not a big deal. There is even built-in command line help (type HELP; or HELP FUNCTIONS; etc.) I rarely, but occasionally use CocoaMySQL .... and I like the traffic monitor graph provided by the MySQL Administrator app.
What can I say........... except thanks to the MySQL developers for a great open source product and ........... I really like MySQL!
Posted: Monday - March 12, 2007 at 01:19 PM
Quick Links
Statistics
Total entries in this blog:
Total entries in this category:
Published On: Dec 29, 2008 02:27 PM
Total entries in this category:
Published On: Dec 29, 2008 02:27 PM