[ERROR] mariadbd: Out of sort memory

Scenario: Got below error from application end. SQL state [HY001]; error code [1038]; (conn=15945) Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: (conn=15945) Out of sort memory, consider increasing server sort buffer size at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) Investigation: Detailed dig down on the MariaDB error log found the below error. [ERROR]…

Detected table cache mutex contention at instance 1: 60% waits. Additional table cache instance activated. Number of instances after activation: 2.

Scenario: All the three nodes of Galera cluster uses 98 percent of memory and swapping heavily, no DML could be performed. Investigation: From the error log on the node 3 the below error has been notified: Detected table cache mutex contention at instance 1: 60% waits. Additional table cache instance activated. Number of instances after…

MySQL Replication on CentOs 7: Configure binary log file position based replication (Fresh server with no data)

Prerequisites: Two virtual machine each of 2GB RAM, 10 GB HDD and Two vCPU with CentOS 7 installed on these. Workaround: Configure the networking between two nodes: Step1: Change the host name of the master node to master-node and make entries to the /etc/hosts file. # hostnamectl set-hostname master-node # echo ‘192.168.56.103 master-node’ >> /etc/hosts…

ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled

MariaDB Error: ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_routine_creators variable) Cause: The user who is executing the create function doesn’t have the required SUPER privilege. Solution: AS for security concern the user couldn’t be given the SUPER privilege…

Install and configure MariaDB Galera 4 cluster on Centos 7 in VirtualBox

Background: Clustering is used to achieve High Aaailability(HA) in many forms and is widely used in database technologies to meet the service uptime and to load balance clients requests. We will see how to configure a Opensource Galera cluster on MariaDB database. This documents assume that you are familiar with virtualization technologies especially VirtualBox, you…

Migrating Bitnami WordPress website from AWS EC2 to VPS Bitnami NGINX

Steps to perform during migration: Install VPS with CentOS 7 without any LAMP stack. configure the x11 window and forwarding make a directory named as /bitnami to be used as installed directory Download the WordPress NGINX stack installer from bitnami. Login as root user, installation should be done as root user to avoid later complexities.…