We have a 5.5.28-29.3-log mysql master that has the percona UDFs installed including murmur_hash.
We installed mysql on new host but I can't seem to find where to get the UDFs from. This doc suggests that they should come build into mysql 5.5.8-20.0 (and above?):
http://www.percona.com/doc/percona-server/5.5/management/udf_percona_toolkit.html
5.5.8-20.0: Began distributing libfnv1a_udf, libfnv_udf, and libmurmur_udf.
But they're definitely not in /usr/lib/mysql/plugin:
/usr/lib/mysql/plugin$ ls lib*
libdaemon_example.so
On the master:
mysql> select murmur_hash('12345');
+----------------------+
| murmur_hash('12345') |
+----------------------+
| -8902960671973102832 |
+----------------------+
1 row in set (0.00 sec)
On the slave:
mysql> select murmur_hash('adsf');
ERROR 1305 (42000): FUNCTION murmur_hash does not exist
I sense I'm missing something obvious.
DISTRIB_DESCRIPTION="Ubuntu 10.04.4 LTS"