Related Articles
How to gracefully reboot MariaDB Galera Cluster servers?
Cluster Configuration In this example configuration of two nodes, we assume that the servers are connected over private network. This allows direct connections without requiring SSH tunnels. The most important parts is to enable listening on IP protocol and to configure addresses and names of the cluster nodes. The config files are similar for each […]
Setup SCTP In Red Hat / CentOS Linux 8
1. Install kernel-modules-extra and SCTP for the currently installed kernel; yum install kernel-modules-extra-`uname -r` yum install -y lksctp-tools lksctp-tools-devel lksctp-tools-doc 2. Add sctp to /etc/modules-load.d/* to load sctp before systemd-sysctl.service during boot. Loading sctp before systemd-sysctl.service allows the sctp sysctl.conf settings to be effective; # cat /etc/modules-load.d/sctp.conf sctp 3. sctp is blacklisted by default on […]
How To Create a New User and Grant Permissions in MySQL
How to Create a New User Let’s start by making a new user within the MySQL shell: CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’; Sadly, at this point newuser has no permissions to do anything with the databases. In fact, if newuser even tries to login (with the password, password), they will not be able to […]