Blog for Database and System Administrators

This blog is a collection of articles on analyzing and troubleshooting for all system and database administrators. These guides come from my experience, I hope they can help everyone.

MENU
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • ClickHouse
  • Oracle Linux Virtualization Manager
Skip to content
  • Oracle
  • MariaDB
  • Linux
  • MongoDB
  • Mysql
  • ClickHouse
  • Oracle Linux Virtualization Manager
MariaDB logo

Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND

Last_SQL_Error: Could not execute _rows event on table .; Can’t find record in ‘’, Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event’s master log , end_log_pos. This is one of the… Read more »

MariaDB, Mysql    Error_code: 1032, GTID, HA_ERR_KEY_NOT_FOUND, MariaDB, mysql, Replica
Linux Logo

What are transparent hugepages?

“Transparent Hugepages” is a Linux kernel feature intended to improve performance by making more efficient use of your processor’s memory-mapping hardware. It is enabled (“enabled=always”) by default in most Linux… Read more »

Linux    Centos, Debian, Hugepages, Kernel, Linux, Performance Linux, Red Hat, Transparent Huge Pages, Ubuntu
Linux Logo

Debian 10: How to disable transparent hugepages

“Transparent Hugepages” is a Linux kernel feature intended to improve performance by making more efficient use of your processor’s memory-mapping hardware. It is enabled (“enabled=always”) by default in most Linux… Read more »

Linux    Debian, Hugepages, Memory Leak, performance, Transparent Huge Pages, Ubuntu
MariaDB logo

ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

I needed to change the hostname on mysql database logins because the application server name was changed. I ran the following command: Starting with the MariaDB-10.4+ the mysql.user is a… Read more »

MariaDB, Mysql    change user, ERROR 1356, mysql.user, rename user, scripts mariadb, scripts mysql
Linux Logo

How to enable https on wildfly and tls 1.2

In this post we will describe step by step how to enable the https protocol on wildfly and enable the desired security protocols. To activate SSL communication in Wildfly, perform… Read more »

Linux    Application Server, https, security, TLS1.0, TLS1.1, TLS1.2, Wildfly
MongoDB Logo

MongoDB 4.4 New Features

This version has been released to augment the database’s ability to operate at a convenient and dependable scale, therefore developed under the “user-driven engineering” principle to enable it deliver numerous… Read more »

MongoDB    mongodb, MongoDB 4.4, New Fea, Replica set, security, Sharding
Clickhouse Logo

ClickHouse compression test

ClickHouse supports different kinds of compressions, namely two LZ4 and ZSTD. But in short, LZ4 is fast but provides smaller compression ratio comparing to ZSTD. While ZSTD is slower than… Read more »

ClickHouse    Big Data, Clickhouse, Compression, Compression lz4, compression zstd, performance, Tuning
Clickhouse Logo

How to backup and restore your Clickhouse Database

ClickHouse is known as a data analytics processing engine. ClickHouse is one of the open-source column-oriented database-oriented management systems capable of real-time generation of analytical data reports using SQL queries…. Read more »

ClickHouse    Backup, Clickhouse, Clickhouse-backup, Clickhouse-client, Restore
ZooKeeper Logo

How To Install and Configure an Apache ZooKeeper Single/Cluster on Ubuntu 20.04

Introduction Apache ZooKeeper is open-source software that enables resilient and highly reliable distributed coordination. It is commonly used in distributed systems to manage configuration information, naming services, distributed synchronization, quorum,… Read more »

ZooKeeper    Cluster, Multi-Node, ubuntu 20.04, ZooKeeper
Clickhouse Logo

How to configure Clickhouse in sharding and replication cluster

Introduction Clickhouse is a column store database developed by Yandex used for data analytics. In this article I will talk about setting up a distributed fault tolerant Clickhouse cluster. If… Read more »

ClickHouse    Clickhouse, Cluster, dbsysupgrade.com, High Availability, Replication, Sharding

Posts navigation

1 2 3 … 9 Next »

Recent Posts

  • Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND February 16, 2021
  • What are transparent hugepages? January 8, 2021
  • Debian 10: How to disable transparent hugepages January 8, 2021
  • ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them January 4, 2021
  • How to enable https on wildfly and tls 1.2 December 30, 2020
  • MongoDB 4.4 New Features December 21, 2020
  • ClickHouse compression test December 4, 2020
  • How to backup and restore your Clickhouse Database November 20, 2020
  • How To Install and Configure an Apache ZooKeeper Single/Cluster on Ubuntu 20.04 October 21, 2020
  • How to configure Clickhouse in sharding and replication cluster October 18, 2020
Copyright 2020
dbsysupgrade.com
Ribosome by GalussoThemes.com
Powered by WordPress
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT
Social Media Auto Publish Powered By : XYZScripts.com