Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline

Hi All, this document deals with how to fix ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. These messages indicate that the table’s definition allows rows that the table’s InnoDB row format can’t actually store. The Below configuration fixed my issue.   Restart MySQL or MariaDB restart or   © 2020, Techrunnr. All rights reserved.

Read More

how backup and restore mysql database using ansible

Hi All, This document shows you how backup and restore MySQL database using ansible. Ansible is a Provisioning and configuration management tool which can be used for both Linux and windows platform. Ansible has reached the best place under the best DevOps tools because it is very is easy and simple. Ansible playbook is written in YAML file which is human readable and understandable which makes ansible popular. Step 1: Create a YAML file vi backup-restore.yml Paste the below contents, explanations are given below. First task perform DB backup to…

Read More

how to install MariaDB 10.4 in Centos 7

Hi All, this document shows you how to install MariaDB 10.4 in Centos 7. MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system, intended to remain free and open-source software under the GNU General Public License. Let’s go to the installation Part. Step 0: Update the system This will help you to keep update the system to the latest version. Once you update the system reboot the server as some packages need a reboot to updates to take effect. Step 1: Add the MariaDB 10.4…

Read More

how to get database structure

Hi All, this document deals with how to get database structure. MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language How to perform   The above command creates a .sql file with database and table structure without data. -d means no data or else you can use the below command,   © 2020, Techrunnr. All rights reserved.

Read More

how to set up database clusters in the digital ocean

Hi All, this document shows you how to set up database clusters in the digital ocean. DigitalOcean, Inc. is an American cloud infrastructure provider headquartered in New York City with data centers worldwide. DigitalOcean provides developers with cloud services that help to deploy and scale applications that run simultaneously on multiple computers. Prerequisites DigitalOcean account Setup Step 1: Log in to digital ocean account, https://cloud.digitalocean.com/ Step 2: Go to Manage and select databases from the main dashboard. Step 3: Click on create database cluster. Step 4: From the database cluster…

Read More

how to change the keycloak database to MySQL from h2

In this document, we will check how to change the keycloak database to MySQL from h2. Keycloak comes with its own embedded Java-based relational database called H2. This is the default database that Keycloak will use to persist data and really only exists so that you can run the authentication server out of the box. It’s fine for development purposes, but for the production, it is recommended to replace it with a more production-ready external database. Prerequisites * Keycloak server, if not check this link * Running MySQL server, if…

Read More

how to check the size of the individual database in MySQL or MariaDB

Hi all, this document deals with how to check the size of the individual database in MySQL or MariaDB. Sometimes as a database administrator it’s required to check the size of the individual databases in database servers. So here is the command to check the sizes. Step 1: log in to Database server ( Mysql/MariaDB) Step 2: Execute the following command to get the individual size of all the schemas. In GB IN MB Here is the command to see the Size of the table.   © 2019, Techrunnr. All…

Read More

You do not have the SUPER Privilege and Binary Logging is Enabled

You do not have the SUPER Privilege and Binary Logging is Enabled The error arises when you try to import the function or trigger containing dangerous statements that make changes in the database. OPTION 1 Step 1: Login to MYSQL server. Stepm 2: Set the log_bin_trust_function_creators value to 1 Perform OPTION 1, if you are not using any services like AWS RDS, otherwise follow OPTION 2. OPTION 2 Step 1: Login to AWS Account Step 2: Select your RDS database and select the parameter group attached to it. Step 3:…

Read More

how to disable password policy in MYSQL

Hi All, this document deals with how to disable password policy in MYSQL. Latest Mysql releases come with a password validate plugin which ensures that users passwords are complex which provides more security. You may observe the following error while entering weak passwords. Your password does not satisfy the current policy requirements So here I will tell you how to disable the password validate plugin. Step 1: log in to Mysql step 2: remove the plugin That’s it, now have successfully remove password validate plugin from MySQL. NOTE: Never ever…

Read More

log user activities in MYSQL

Hi All, this document deals with how to log user activities in MYSQL. It is always required to log all the user activities happening in MySQL when a server is used by multiple persons or application. So here are the steps to achieve it. configuration Step 1: Login to the Mysql server. Step 2: Create a General log file. Step 3: Enable the general log Add the following to /etc/my.cnf Step 4: If you also want the text version of the general log, add this: Step 5: Restart MySQL ©…

Read More