Cannot find a resource for mysql_service_manager on amazon version 2016.09

Exceptions::NoSuchResourceType: Cannot find a resource for mysql_service_manager on amazon version 2016.09

Latest Amazon linux AMI do not have systemctl installed by default, so you need to change the service manager in your recipe as shown below.

mysql_service 'api-mysql' do
  port '3307'
  version '5.5'
  run_user 'mysql'
  data_dir '/vol/mysql'
  service_manager 'sysvinit'
  action [:create, :start]
end

You can also use systemd or upstart apart from sysvinit.