===================================================================== ATTACHMENT 1: /usr/bin/galera_new_cluster (DB host ss012226) ===================================================================== #!/bin/sh # This file is free software; you can redistribute it and/or modify it # under the terms of the GNU Lesser General Public License as published by # the Free Software Foundation; either version 2.1 of the License, or # (at your option) any later version. if [ "${1}" = "-h" ] || [ "${1}" = "--help" ]; then cat < "$new_cluster" && \ systemctl restart mariadb.service extcode=$? exit $extcode ===================================================================== ATTACHMENT 2a: systemctl cat mariadb@swat_int1 (DB host ss012226) comments and empty lines removed ===================================================================== [Unit] Description=MariaDB 10.6.28-24 database server Documentation=man:mariadbd(8) Documentation=https://mariadb.com/kb/en/library/systemd/ After=network.target [Install] WantedBy=multi-user.target [Service] Type=notify PrivateNetwork=false User=mysql Group=mysql AmbientCapabilities=CAP_IPC_LOCK PrivateDevices=false ProtectSystem=full ProtectHome=true EnvironmentFile=-/run/mariadb-wsrep-new-cluster ExecStart=/bin/sh -c "set -f; [ ! -e /usr/bin/galera_recovery ] && VAR= || \ VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] || exit 1; \ exec /usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $VAR" SyslogIdentifier=mariadbd KillSignal=SIGTERM SendSIGKILL=no Restart=on-abnormal RestartSec=5s UMask=007 PrivateTmp=false TimeoutStartSec=900 TimeoutStopSec=900 TasksMax=99% LimitNOFILE=32768 [Service] Environment='MYSQLD_OPTS=--defaults-file=/etc/my.cnf.d/mariadb-%I.cnf' PermissionsStartOnly=true ExecStartPre=/usr/bin/install -d /var/run/mariadb-%I -o mysql -g mysql LimitNOFILE=130127 TimeoutSec=0 ===================================================================== ATTACHMENT 2b: systemctl cat maxscale@swat_int1 (app host ss014395) comments and empty lines removed ===================================================================== [Unit] Description=MariaDB MaxScale Database Proxy After=network.target [Service] Type=forking Restart=on-abort RuntimeDirectory=maxscale PIDFile=/run/maxscale/maxscale.pid User=maxscale Group=maxscale ExecStart=/usr/bin/maxscale TimeoutStartSec=120 LimitNOFILE=65535 StartLimitBurst=0 WatchdogSec=60s NotifyAccess=all RestartForceExitStatus=75 [Install] WantedBy=multi-user.target [Service] ExecStartPre=/usr/bin/install -d /var/run/maxscale-%I -o maxscale -g maxscale PIDFile=/var/run/maxscale-%I/maxscale.pid ExecStart= ExecStart=/usr/bin/maxscale --config=/etc/maxscale.cnf.d/maxscale-%I.cnf systemctl status maxscale@swat_int1: Loaded: loaded (/usr/lib/systemd/system/maxscale@.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/maxscale@.service.d └─options.conf Active: failed (Result: exit-code) since Tue 2026-10-27 17:06:35 CET Process: 1034392 ExecStartPre=/usr/bin/install -d /var/run/maxscale-swat_int1 -o maxscale -g maxscale (code=exited, status=1/FAILURE) install[1034392]: /usr/bin/install: cannot change owner and permissions of '/var/run/maxscale-swat_int1': No such file or directory systemd[1]: maxscale@swat_int1.service: Control process exited, code=exited status=1 ===================================================================== ATTACHMENT 2c: /usr/lib/systemd/system/maxscale@.service BEFORE upgrade MaxScale 23.02.10, old app host ss015412 (worked) ===================================================================== [Unit] Description=MariaDB MaxScale Database Proxy After=network.target [Service] Type=forking Restart=on-abort # Make sure /var/run/maxscale exists PermissionsStartOnly=true ExecStartPre=/usr/bin/install -d /var/run/maxscale -o maxscale -g maxscale ExecStartPre=/usr/bin/install -d /var/lib/maxscale -o maxscale -g maxscale PIDFile=/var/run/maxscale/maxscale.pid # Use the default user and group User=maxscale Group=maxscale ExecStart=/usr/bin/maxscale TimeoutStartSec=120 LimitNOFILE=65535 StartLimitBurst=0 WatchdogSec=60s NotifyAccess=all # MaxScale should be restarted if it exits with 75 (BSD's EX_TEMPFAIL) RestartForceExitStatus=75 [Install] WantedBy=multi-user.target Drop-in /etc/systemd/system/maxscale@.service.d/options.conf on ss015412 is identical to the new host (see 2b). ===================================================================== ATTACHMENT 3: my_print_defaults --defaults-file=/etc/my.cnf.d/mariadb-swat_int1.cnf mysqld (DB host ss012226, wsrep_sst_auth masked) ===================================================================== --pid_file=/var/run/mariadb-swat_int1/mariadb.pid --port=33061 --server_id=1 --gtid_domain_id=101 --log_bin=/glide/mysql/binlog/swat_int1/mysql-binlog --datadir=/glide/mysql/data/swat_int1 --log_error=/glide/log/mariadb-swat_int1/mariadb.err --tmpdir=/glide/mysql/temp/swat_int1 --socket=/glide/mysql/socket/swat_int1/mysql.sock --slow_query_log_file=/glide/log/mariadb-swat_int1/mariadb-slow.log --log_warnings=2 --innodb_log_file_size=1G --user=mysql --plugin_maturity=beta --aria_pagecache_buffer_size=256M --sql_mode=NO_ENGINE_SUBSTITUTION --key_buffer_size=128M --max_allowed_packet=32M --tmp_table_size=64M --max_heap_table_size=64M --myisam_sort_buffer_size=256k --open_files_limit=32768 --net_write_timeout=900 --net_read_timeout=900 --lock_wait_timeout=14400 --wait_timeout=500 --transaction_isolation=REPEATABLE-READ --sync_binlog=0 --expire_logs_days=3 --log_slave_updates=ON --binlog_format=ROW --binlog_cache_size=1M --log_bin_trust_function_creators=ON --default_storage_engine=InnoDB --character_set_server=utf8 --query_cache_size=0 --query_cache_type=0 --use_stat_tables=NEVER --eq_range_index_dive_limit=0 --innodb_use_native_aio=ON --innodb_stats_persistent=ON --innodb_adaptive_flushing=ON --innodb_checksum_algorithm=crc32 --innodb_log_buffer_size=16M --innodb_flush_log_at_trx_commit=1 --innodb_stats_on_metadata=OFF --innodb_flush_method=O_DIRECT --innodb_lock_wait_timeout=50 --innodb_flush_neighbors=1 --innodb_max_dirty_pages_pct=75 --innodb_adaptive_hash_index=ON --innodb_io_capacity=5000 --innodb_io_capacity_max=10000 --innodb_open_files=8000 --innodb_sync_spin_loops=20 --innodb_read_io_threads=6 --innodb_write_io_threads=4 --innodb_purge_threads=4 --innodb_purge_batch_size=300 --innodb_max_purge_lag=5000000 --innodb_adaptive_hash_index_parts=17 --innodb_file_per_table=ON --innodb_print_all_deadlocks=ON --innodb_default_row_format=dynamic --innodb_strict_mode=OFF --innodb_data_file_path=ibdata1:12M:autoextend --table_open_cache=8000 --table_definition_cache=12000 --max_connections=2000 --performance_schema=ON --secure_auth=ON --sort_buffer_size=1M --local_infile=ON --bind_address=0.0.0.0 --symbolic_links=OFF --innodb_monitor_disable=ALL --long_query_time=1 --log_queries_not_using_indexes=0 --binlog_row_image=FULL --default_time_zone=+00:00 --gtid_strict_mode=OFF --interactive_timeout=900 --innodb_stats_transient_sample_pages=8 --log_slow_verbosity=innodb,query_plan --max_connect_errors=100 --optimizer_switch=materialization=off --session_track_system_variables=last_gtid --skip_name_resolve=ON --slow_query_log=ON --userstat=OFF --innodb_force_primary_key=OFF --innodb_autoinc_lock_mode=2 --innodb_buffer_pool_size=96G --wsrep_cluster_name=swat_int1 --wsrep_provider=/usr/lib64/galera/libgalera_enterprise_smm.so --wsrep_cluster_address=gcomm://171.25.105.135:45671,171.25.105.136:45671,171.25.105.134:45671 --wsrep_on=ON --wsrep_node_address=171.25.105.134:45671 --wsrep_sst_receive_address=171.25.105.134:44441 --wsrep_sst_method=mariabackup --wsrep_auto_increment_control=OFF --wsrep_replicate_myisam=ON --wsrep_provider_options=gcache.size=16G;gcache.recover=1;ist.recv_addr=171.25.105.134:45681 --wsrep_gtid_domain_id=1 --wsrep_gtid_mode=ON --wsrep_slave_threads=8 --wsrep_sst_donor=ss012228,ss012227,ss012226 --wsrep_sst_auth=****