MySQL doesn't work with multiple instances on systemd

[Kevin Pattison]

Hey,

I'm following the documentation here (https://dev.mysql.com/doc/refman/5.7/en/server-management-using-systemd.html#systemd-multiple-mysql-instances) on Ubuntu Server 16.04.1 but the service will not start as documented. Here is what I see:

$ my_print_defaults --defaults-file=/etc/mysql/my.cnf mysqld@mysqld10
--user=root
--pid-file=/var/run/mysqld10.pid
--socket=/var/run/mysqld10.sock
--port=3306
--basedir=/usr
--datadir=/var/lib/mysql10
--tmpdir=/tmp
--lc-messages-dir=/usr/share/mysql
--skip-external-locking
--key_buffer=16M
--max_allowed_packet=16M
--thread_stack=192K
--thread_cache_size=8
--myisam-recover=BACKUP
--query_cache_limit=1M
--query_cache_size=16M
--log_error=/var/log/mysql10/error.log
--server-id=22
--expire_logs_days=10
--max_binlog_size=100M

$ my_print_defaults --defaults-file=/etc/mysql/my.cnf mysqld@mysqld20
--user=root
--pid-file=/var/run/mysqld20.pid
--socket=/var/run/mysqld20.sock
--port=3307
--basedir=/usr
--datadir=/var/lib/mysql20
--tmpdir=/tmp
--lc-messages-dir=/usr/share/mysql
--skip-external-locking
--key_buffer=16M
--max_allowed_packet=16M
--thread_stack=192K
--thread_cache_size=8
--myisam-recover=BACKUP
--query_cache_limit=1M
--query_cache_size=16M
--log_error=/var/log/mysql20/error.log
--server-id=22
--expire_logs_days=10
--max_binlog_size=100M

$ sudo systemctl start mysqld@mysqld10
Failed to start [e-mail]: Unit [e-mail] not found.

$ sudo systemctl start mysqld@mysqld20
Failed to start [e-mail]: Unit [e-mail] not found.