git: 1bc699507cae - main - databases/mysql80-server: Update my.cnf.sample

The branch main has been updated by joneum:

URL: https://cgit.FreeBSD.org/ports/commit/?id=1bc699507caeb6807ec13443074567da4c847596

commit 1bc699507caeb6807ec13443074567da4c847596
Author:     Jochen Neumeister <joneum@FreeBSD.org>
AuthorDate: 2022-10-29 15:07:07 +0000
Commit:     Jochen Neumeister <joneum@FreeBSD.org>
CommitDate: 2022-10-29 15:08:22 +0000

    databases/mysql80-server: Update my.cnf.sample
    
    Update deprecated configs in my.cnf.sample
    
    Some configs in my.cnf.sample are now deprecated. These should be replaced with their replacement, or removed if there is no replacement.
    
    - Replace deprecated slave-load-tmpdir with replica-load-tmpdir
    - Remove deprecated master-info-repository (it was set to the default)
    - Remove deprecated relay-log-info-repository (it was set to the default)
    - Replace deprecated expire_logs_days with binlog_expire_logs_seconds (multiply 30 days by 24 * 60 * 60)
    - Replace deprecated innodb_log_file_size with innodb_redo_log_capacity (preserving the same configured capacity, which was set to 256M * 2 log files)
    - Remove deprecated skip-symbolic-links (it is the default)
    
    PR:     266511
    Sponsored by:   Netzkommune GmbH
---
 databases/mysql80-server/files/my.cnf.sample.in | 9 +++------
 1 file changed, 3 insertions(+), 6 deletions(-)

diff --git a/databases/mysql80-server/files/my.cnf.sample.in b/databases/mysql80-server/files/my.cnf.sample.in
index 7fa72451dec3..3d1264c1bd61 100644
--- a/databases/mysql80-server/files/my.cnf.sample.in
+++ b/databases/mysql80-server/files/my.cnf.sample.in
@@ -14,19 +14,17 @@ bind-address                    = 127.0.0.1
 basedir                         = %%PREFIX%%
 datadir                         = %%MY_DBDIR%%
 tmpdir                          = %%MY_TMPDIR%%
-slave-load-tmpdir               = %%MY_TMPDIR%%
+replica-load-tmpdir             = %%MY_TMPDIR%%
 secure-file-priv                = %%MY_SECDIR%%
 log-bin                         = mysql-bin
 log-output                      = TABLE
-master-info-repository          = TABLE
-relay-log-info-repository       = TABLE
 relay-log-recovery              = 1
 slow-query-log                  = 1
 server-id                       = 1
 sync_binlog                     = 1
 sync_relay_log                  = 1
 binlog_cache_size               = 16M
-expire_logs_days                = 30
+binlog_expire_logs_seconds      = 2592000
 default_password_lifetime       = 0
 enforce-gtid-consistency        = 1
 gtid-mode                       = ON
@@ -47,12 +45,11 @@ innodb_log_group_home_dir       = %%MY_DBDIR%%
 innodb_data_file_path           = ibdata1:128M:autoextend
 innodb_temp_data_file_path      = ibtmp1:128M:autoextend
 innodb_flush_method             = O_DIRECT
-innodb_log_file_size            = 256M
+innodb_redo_log_capacity        = 512M
 innodb_log_buffer_size          = 16M
 innodb_write_io_threads         = 8
 innodb_read_io_threads          = 8
 innodb_autoinc_lock_mode        = 2
-skip-symbolic-links
 
 [mysqldump]
 max_allowed_packet              = 256M