(e-mailing ports@ since my previous private reply seems to have been ignored)
On Fri, 22 Mar 2013 at 21:55:07 -0400, Brad Smith wrote: > Here is the port and a diff to adjust the tree to move over to > MariaDB. The only port I haven't touched is xmysql as it doesn't > build with newer MariaDB or MySQL. It's old unmaintained cruft > and I'm planning on removing it. > > http://comstyle.com/ports/mariadb/ > > If you're a MySQL user or have expressed interest in MariaDB > please test and provide any feedback regarding testing and/or > the port. I'm running with this on amd64 as a drop-in replacement for a previous mysqld installation with a few databases. One issue with the port is that its MASTER_SITES is only one host in .ie. You should probably add at least the one US mirror: MASTER_SITES= http://ftp.osuosl.org/pub/mariadb/${DISTNAME}/kvm-tarbake-jaunty-x86/ \ http://ftp.heanet.ie/mirrors/mariadb/${DISTNAME}/kvm-tarbake-jaunty-x86/ As far as a drop-in replacement for the old MySQL goes, I uninstalled mysql-server-5.1.68 and installed mariadb-server. It started up fine, but in the logs it complained that I needed to run mysql_upgrade, which I did and seemed to go fine. That should probably be in an INSTALL message for those migrating. Next, mysqld only listened on IPv6, with the default my.cnf installed from mariadb: $> netstat -an | grep 3306 tcp6 0 0 *.3306 *.* LISTEN That seems broken. My stuff is configured to connect to 127.0.0.1:3306 which was reachable on the previous default for mysql-server: $> netstat -an | grep 3306 tcp 0 0 *.3306 *.* LISTEN If I manually specify "bind-address = 127.0.0.1" in my.cnf, it works, but the default should probably be inet, if not both inet and inet6.