Tuning MariaDB on director node through hieradata in RHOSP16.2

Issue

• How to tune MariaDB on the director node for large deployment through hieradata when deploying undercloud in RHOSP16.2?
• Undercloud deploy with the below custom hiera parameters for MariaDB for large environment that are mentioned in this article failed in RHOSP16.2.

mysql_max_connections: 8192
tripleo::profile::base::database::mysql::mysql_server_options:
  'mysqld':
    innodb_buffer_pool_instances: 8
    innodb_buffer_pool_size: '2G'
    tmp_table_size: '128M'
    bind-address: "%{hiera('controller_host')}"
    innodb_file_per_table: 'ON'
    max_allowed_packet: '64M'
    connect_timeout: '60'