Apple Removes MySQL From Lion Server

sfcrazy also noticed that Apple has officially removed MySQL from Lion Server, opting instead to include PostgreSQL, albeit in command line only form. The article speculates that the change is because MySQL is now Oracle property, and Apple is concerned about IP issues following all the legal issues surrounding Java.

Comments

Much better anyway

[Anrego]

I just wish it was a little more user friendly. That was the one thing MySQL had going for it.. dead simple to use and admin.. and I imagine Apple's frontend probably made it even more so. Postgres isn’t as bad as oracle (by a long shot) but it certainly requires a little background reading to use. MySQL you can pretty much throw on a box and start using right away. This made it insanely newbie friendly (and cheap webhost admin friendly) and is probably the reason it became so prevalent.

For the record I’m no fan of Apple and I think using apple as a server is insane but I actually agree with Apple on this one.

Re:Much better anyway

[Atzanteol]

"Use and admin" != "install."

Re:Much better anyway

[amorsen]

I keep hearing that Postgres is hard to admin. Yet Postgres integrates with the normal Unix user accounts so I don't have to worry about users and passwords, it uses sockets by default so I don't have to worry about networking (unless the SQL server is remote), it provides sane semantics without having to worry about table types...

I like SHOW CREATE TABLE from MySQL and the \-commands could use some aliases, but other than that Postgres is rather nice to admin and use.

Re:Much better anyway

[Anonymous Coward]

pgAdmin3 is the way to go, it works really well and pretty much has a "just give me a damn database" button.

I started with PostgreSQL and had to use MySQL for some projects later. I find MySQL and its tools to be cumbersome, but that's likely just due to my familiarity with PostgreSQL.

Re:Much better anyway

[fuzzytv]

Not true. Manual vacuuming is not needed since PostgreSQL 8.1, released 2005/11, that's almost 6 years ago. The functionality is called 'autovacuum" and it's fully automatic so you don't need to care about it anymore, and it was significantly improved in the following versions. In some cases you have to tune it a bit (to make it more aggresive for example), but in 99% it works fine out of the box.

Maybe your site was one of those 1% that needed a bit more tuning, or maybe changes at the application level (not everything that works on one database will work fine one another one). Otherwise it's a pure FUD. We're running a lot of applications (with a lot of write activity) on PostgreSQL, and it works perfectly.

Sure, nothing is perfect - for example the memory management is not perfect, you need a bit of experience when setting the memory limits. But I really don't think "leaking to disk" is the right term. You can set 'maintenance_work_mem' and if the process needs more, it has to put that on disk. But with reasonable limit and autovacuum that really does not happen.

MySQL can still be installed

[UnknowingFool]

To be clear, MySQL can be installed on Lion; it's just no longer installed by default.

Re:Samba has also been removed from server

[Henriok]

Apple stopped using SAMBA after SAMBA moved to GPL3 and Apple don't want to use such a license.

Re:Samba has also been removed from server

[pieterh]

Yes, the reason here seems to be GPL-related, and nothing to do with Oracle and Java. Postgresql uses an MIT/X11 style license. MySQL is GPL. This is a trend at Apple.

The reason, ironically, is probably the GPLv3's anti-patent clauses. My hypothesis is that Apple's lawyers have picked up on this and it's now company policy to avoid GPLv3 software in their stack, at any cost.

Installation of MySQL server on Mac OS X Lion

[psergiu]

http://www.djangoapp.com/blog/2011/07/24/installation-of-mysql-server-on-mac-os-x-lion/

1) Download the latest 64-Bit DMG Archive (Apple Disk Image) from MySQL Site (http://dev.mysql.com/downloads/mysql/). Current latest version is 5.5.14 which I’ll be using to install on my machine.
2) Mount the Disk Image (I mean open/double-click the DMG file) and install MySQL server by double-clicking the PKG file (in my case mysql-5.5.14-osx10.6-x86_64.pkg) and follow onscreen instructions. ( It will ask for Master password, as it installs MySQL server in /usr/local )
3) Add /usr/local/mysql/bin to your path by editing .profile file. (Optionally you can create alias to mysql and mysqladmin as mentioned in README File)
4) You can start MySQL server by running “/usr/local/mysql/bin/mysqld_safe &” from terminal but Disk image you downloaded also consists of Startup Package & Preferences Pane which allows you to start/stop MySQL server from System Preferences and even Automatically Start MySQL Server at Startup.

Re:Samba has also been removed from server

[CharlyFoxtrot]

It's not prebuilt but Macports has ports for samba 3.2.15 and samba 4.0.0tp5. Installing from Macports isn't difficult for anyone with a modicum of unix savvy.

Re:Samba has also been removed from server

[Sloppy]

The whole TIVO clause is nothing more than "I don't like what you're doing with my software I said was free, so I'm making it less free, and calling it more free".

More like "I don't like that you've taken software that I tried to make perpetually user-auditable and user-maintainable, and found a way to prevent users from having the capacity to audit or maintain it."

As soon as you look at the question in terms of "less free" or "more free" you will get it wrong. It's not about degrees of freedom; it's about whose freedom when there's a conflict. GPL3 looks at the situation where developers' and users' interests conflict, and like Tron, fights for the users.

This is dead simple to understand if you go back and look at the roots of all this stuff. RMS wasn't just a programmer; he was a guy who had a printer that he wanted to use. It is really cool that a lot of programmers have followed his ideals, but dudes, it's not for us. It's for them (the people who hire us) because we recognize that sometimes we're them. Unless you're totally building all your computers out of transistors from the ground up, you're always one of "them," to some degree.

Re:Samba has also been removed from server

[Jeremy Allison - Sam]

Creepy wrote:

"GPL3 is a (commercial) plague - anything that uses any GPL3 library MUST comply by GPL3 and any license that is not GPL3 becomes GPL3, so Apple had to abandon SAMBA - if they integrate a SAMBA interfacing gui into their OS (which they did under GPL2), they immediately are required to release the entire OS under the GPL."

Can I have some of your 'shrooms please, they must be *really* good :-).

This is so far from the truth it's easier just to point at this:

ftp://www.samba.org/pub/samba/slides/linuxcollab-why-samba-went-gplv3.pdf

and hope people read it than to try and rebut your ravings.

Jeremy.