MySQL / MariaDB DBA

MariaDB Minor Patch Upgrade [ 10.4.10 to 10.4.21 ] with HA Topology  x This blog will be explain about ,  how to apply the Minor patch of MariaDB Version  [ For eg : from 10.4.10 to 10.4.21 ] with HA Topology. [ If it is Tarball Installation ] Let us assume ,  We have Environment like this , 2 MariaDB Servers with GTID Replication running [ Main and Replica ] along with MaxScale 2 Servers  [ Active and Passive MaxScale Servers ] and keepalived is enabled . High level steps Details Explanation with commands for above steps Rollback steps From 10.4.21 to 10.4.10   High level steps Patch Upgrade of MariaDB servers Step - 1 :- Check the status of " maxctrl list servers " command in Both Active and Passive MaxScale servers [ Maintenance mode ] Step - 2 :- In this step all Application are connected to Main server Step - 3 :- Perform the MariaDB version 10.4.10 to 10.4.21 in Current Replica Server of MariaDB Step - 4 :- Now clear the maintenance mode for replica [ Server 2 ] from Ac

In this blog , i am going to explain how to connect RDS MySQL With SSL Connections from MySQL Workbench and MySQL / MariaDB client utility by using command line  --> Make sure RDS MySQL / MariaDB instance is ready for usage. Connection Established from MySQL / MariaDB client by using cmd line C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u admin -p -h ssl-test-server.cz8z9jo4bowe.us-east-1.rds.amazonaws.com Enter password: ************* Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 25.Server version: 8.0.23 Source distribution.Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like '%ssl%'; +-------------------------------------+----------------