MySQL

Too much at once

I feel the need to ask for patience as this week we got bombarders by a lot of updates. Dovecot did a major upgrade to 2.1, Apache released a major upgrade to 2.4, postfix released 2.9.1 a small bugfix and MySQL released 5.5.21.

I need to compile, test and adjust everything where necessary and as you might understand with major upgrade there is more going on then just a compile, run and test. There are new configuration options to be evaluated and older ones deprecated that might need a new one or a workaround for lost functionality.

So I’m working on it but it take a bit longer then usual…

First documentation set for Lion

Alright here is the first result of adapting the instructions to Mac OS X 10.7 aka Lion. First some remarks, to get the quickest results I decided to first do everything in a virtual machine as I wanted to take the time to upgrade my desktop. It was remarkably easy to install Lion as a virtual OS using VMWare. First I tried with Virtualbox which works with Snow Leopard but that didn’t work for Lion. So I tried with the current beta of VMWare Fusion which I am currently testing and that one went without any problem. Just do a “Show Package Contents” of “Install Mac OS X Lion” and copy the file “InstallESD.dmg”. Create a new virtual machine and point it to this DMG file for installing and it will install like a regular Mac. If anyone has a regular version of VMWare Fusion 3.1.x can you verify that this works?

Next step was getting XCode on the machine for which I had to use the “App Store” but luckily XCode is again free! Everything installed I was ready to go. One of the things I noticed is that I can install everything in 64 bits without needing to explicitly specifying it which we had to do on Snow Leopard. Also note that there is no more 32 bits on Lion! This is why it won’t run on some of the older Intel Macs.

So if you’ve already upgraded your Mac to Lion or just have bought a new one and need to install MAMP, that part is no finished. Next step is me taking the time to upgrade my desktop and then attack the mail-server documentation.

http://diymacserver.com/lion/

Update: Just got this in my RSS reader, VMWare 3.1.3 does not support Lion as a guest. The current Beta does so I guess you have to wait till 3.1.4 or join the beta program!

Also found that PostgresSQL 9.0.4 is installed with OS X Lion! There is documentation in /Library/Webserver/Documents and the psql command is available. Let’s see what we can find out more…

Found this in the official Apple documentation What is new in Mac OS X 10.7

Beginning in Mac OS X v10.7, Mac OS X Server ships with PostgreSQL instead of MySQL as its database server. If you are using other software that requires MySQL, you must install it yourself.

MySQL released 5.5.13

Somehow due to the speed of the internet and my recent vacation I got sidetracked and completely missed some MySQL updates. MySQL has released a new version of the 5.5.x branch which is already usuable in our setup when you read this blogpost. It works perfectly on my test machine. It includes several high-impact changes to address scalability and performance issues in MySQL Server. Read the release notes for all the details.

Luckily the problem with the unlinked libraries that caused problems during compilation with 5.5.10 has gone.

Read this documentation on how to ugrade this version using the package installer of MySQL.

MySQL released 5.1.57

For the people who haven’t upgraded to a 5.5.x release MySQL has released version 5.1.57, this is a bug fix release and it is up to you if you want to upgrade. Check all the fixes and changes that are listed on the release notes to see what issues are resolved and if you are affected. I’ve compiled it and did some tests on my servers and it worked without any problems.

Read the documentation on how to ugrade this version of MySQL.

MySQL released 5.5.10

MySQL released a new version of the 5.5.x branch which is already usuable in our setup when you read this blogpost. It works perfectly on my test machine. It includes several high-impact changes to address scalability and performance issues in MySQL Server. Please note that MySQL 5.5.10 does also have an incompatible change besides the enhancements and bugfixes. Read the release notes for more details.

Please note that because the library is incompatible you might need to recompile all your library depended apps like PHP, Postfix and Dovecot. Please also the change in the library reference that is still an issue. (it’s now 18 instead of 16)

sudo install_name_tool -id /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/local/mysql/lib/libmysqlclient.dylib

Also I would like to mention an interview with Tomas Ulin, Vice President, MySQL Engineering, who answers questions about the GA release of MySQL 5.5.

Read this documentation on how to ugrade this version using the package installer of MySQL.

Next Page »