How to increase limit for open processes and files using ansible

Question

I am setting up a MySQL server, and I was told to increase the ulimit for the number of open processes.

I ran

- name: "increase limit for the number of open files"
  shell: "ulimit -n 64000"
- name: "increase limit for the number of open processes"
  shell: "ulimit -u 64000"

on the ansible-playbook, but not only does it throw error "Illegal option -u", but also open files limit (-n) doesn't seem to get modified. (I ran ulimit -n on the server but it stays the same)

What is the recommended way of increasing these limits, and how should I do it in Ansible?

I saw pam_limits module. Should I use this module to modify nproc and nofile? If so, which domain?

Thank you.

Answer 1

Since Ansible 2.0.0, a new official module supports configuring PAM.

# Add or modify nofile soft limit for the user joe
- pam_limits:
    domain: joe
    limit_type: soft
    limit_item: nofile
    value: 64000