Editing My.cnf of Slave Server for Radico

[[category:Radico-Khaitan]]


== 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