Hi,
I'm using mariadb-10.5.18-1.fc37.x86_64 on fedora37 set up as a master server. There are currently two or three slaves configured and operating properly. I'm trying to add another slave, and for some reason when I try to flush tables with read lock, then dump the databases to be transferred to the new slave, mysqldump just prints:
-- Connecting to localhost...
At first I didn't realize it, but soon the database stopped responding to all clients until I released the lock with "unlock tables".
I'm following these directions:
What could I be doing wrong? Here are the my.cnf options that I believe could be related to my issue. Any ideas greatly appreciated.
The server has 128GB of RAM.
[mysqld]
sql_mode=ONLY_FULL_GROUP_BY
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
max_connections=1000
replicate_do_db='repdb'
replicate_do_db='sbclient'
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 512M
join_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
query_cache_size = 400000000
query_cache_type = 1
query_cache_strip_comments = 1
relay_log_space_limit = 500M
relay_log_purge = 1
log-slave-updates = 1
local_infile = OFF
binlog_format = ROW
max_heap_table_size = 2048M
tmp_table_size = 2048M
relay-log=myserver-relay-bin
log_bin = /var/log/mariadb/mysql-bin.log
log_warnings = 1
expire_logs_days = 2
max_binlog_size = 500M
plugin_load=server_audit=server_audit.so
plugin_load_add = query_response_time
server_audit_events=connect,query
server_audit_file_path = /var/log/mariadb/server_audit.log
server_audit_file_rotate_size = 1G
server_audit_file_rotations = 1
slow-query-log = 1
slow-query-log-file = /var/log/mariadb/mariadb-slow.log
long_query_time = 1
log_error = /var/log/mariadb/mariadb-error.log
skip-networking=0
binlog_format=mixed
server-id = 590