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 remove all data from specific MongoDB collections

HI all, this document shows you how to remove all data from specific MongoDB collections. MongoDB is NoSQL database, MongoDB uses JSON-like documents with optional schemas. Sometimes there will be a requirement to delete all the data of specific MongoDB collection. Here we will provide the steps for that. Step 1: log in to mongo shell Step 2: Now choose your database, Step 3: now display your collections under scrapper database, Step 4: Now delete all the data from user collection.   Success, now you deleted all the data from…

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

Failed to set up listener: SocketException: Permission denied

Hi All, this document deals with how to fix Failed to set up listener: SocketException: Permission denied error. This issue is related to permission issues where MongoDB is not able to start the service. Check the permission of tmp location Change the permission and ownership of temp folder. chown root:root /tmp chmod 1777 /tmp Now start the MongoDB service. service mongod start © 2019, Techrunnr. All rights reserved.

Read More

how to reset the AWS RDS instance password

Hi All, this document shows how to reset the AWS RDS instance password. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security and compatibility they need. Configuration Step 1: log in to the AWS management console. Step 2: Select…

Read More

how to install firebird in centos7

Hi All, this document deals with how to install firebird in centos7 Firebird is an open-source SQL relational database management system that “runs on Linux, Microsoft Windows, macOS, and several Unix platforms”. The database forked from Borland’s open source edition of InterBase in 2000, but since Firebird 1.5 the code has been largely rewritten Installation Step 1: Install epel releases Step 2: Install firebird Step 3: chanage the permission to firebird user. Step 4: Now start and enable the service. © 2019, Techrunnr. All rights reserved.

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