mysql missing?
Is it just me or is mysql missing from 10.7 server?
Mac mini, Mac OS X (10.7)
Is it just me or is mysql missing from 10.7 server?
Mac mini, Mac OS X (10.7)
It looks like it is: http://www.theregister.co.uk/2011/08/02/apple_dumps_mysql_from_mac_os_x_server/ .
An incredibly difficult Google search uncovered this...
http://www.apple.com/macosx/server/specs.html
notice the lack of MySQL inclusion?
Wow, people. Grow up and be admins. Long before OS X I was installing NetBSD on PPC macs and running them as internet servers. Imagine my joy when Apple built OS X on top of BSD. OS X IS a server platform at its heart. The consumer version strips much of that away.
Apple's Server Admin GUI was always crap but the underlying technology is rock solid. I had to turn off my web and mail servers in the GUI because my configurations broke the GUI but they ran great!
You want a GUI to run your server? Install Webmin.
It's UNIX people. Learn to use bash or csh or stay out of the terminal.
The only thing I can see the server version adding that I really need for a server is a kernel tuned for server performance instead of desktop use. The rest is fluff.
So Apple dumped MySQL in favor of PostgresSQL... And?
Why is everyone crying so foul and saying it's a deal breaker? Just go here and download the MySQL .dmg archive for 10.6 and install it on your server.
Pros:
1) You get the latest version of MySQL and can update to the latest MySQL whenever you feel like it.
2) Download the MySQL Workbench GUI and you can have a workflow tool 1 gazillion times better than anything Apple EVER came out with for the entire management of MySQL - including server management.
3) It comes straight from the MySQL Development group - not an included binary version from Apple.
4) Install the MySQL System Preferences pane and - manage it from the system preferences on your Mac.
Cons:
1) You're gonna have to actually do some reading on the MySQL Dev site to tweak a few setup configuration details such as setting the root password. Big deal.
OK everyone, take a deep breath. It's not the end of the world! MySQL is fully supported on Lion Server as it is running on my production server and I have yet to encounter a problem. Did it take a few extra steps or a little extra time to get it running? Yes. Was it worth it? Yes - by a long shot. My dev team has now started developing for the PostgresSQL database. Whoopee so we now have two DB options when developing data solutions.
These discussions have a search feature- take the time to look them over and see if you can find an answer. There are some pretty smart people in here.
You have impressed us all with your knowledge and manliness Robert. Yes we should all grow up, beat our chests and take a step back into the world of CLI. Thank you for slapping us into shape.
Just to add that before 10.7 I always used CLI to run MySQL. Easy, fast and reliable! This is one of the easiest thing to add MySQL
My admin upgraded not knowing this. The MySQL binaries and my database were preserved, but not mysqldump. How am I supposed to backup my database? I could upgrade to MySQL 5.1, but I would really like to do a mysqldump backup before attempting anything like that. Any ideas?
Your finding has been reported.
In the meantime, you can copy mysqldump from an existing Snow Leopard Server system.
Apple has also removed SNMP from 10.7.1 Server
mysql missing?