RHEL 7 increase number of open files for given service

[tomboi]

How do I set limits for services such as mysqld (mariadb server) in RHEL 7 when systemd used?