My.cnf of Slave Server for Radico

[mysqld]

Remove leading # and set to the amount of RAM for the most important data
cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
innodb_buffer_pool_size = 128M
Remove the leading "# " to disable binary logging
Binary logging captures changes between backups and is enabled by
default. It's default setting is log_bin=binlog
disable_log_bin
Remove leading # to set options mainly useful for reporting servers.
The server defaults are faster for transactions and fast SELECTs.
Adjust sizes as needed, experiment to find the optimal values.
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
Remove leading # to revert to previous value for default_authentication_plugin,
this will increase compatibility with older clients. For background, see:
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin

default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

innodb-flush-method = O_DIRECT
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table = 1

innodb-buffer-pool-size = 50G default-storage-engine = InnoDB

CACHES AND LIMITS #

tmp-table-size = 4092M max-heap-table-size = 32M max-connections = 500 thread-cache-size = 500 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 2048

server-id=101 event_scheduler=off lower_case_table_names = 1 sql_mode = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION