Today, we are going to look into monitoring Auto Increment columns in MySQL Instance. Basically as a Database Administrator we should alw...

       There are many ways of data encryption in MySQL. We always want to protect sensitive columns like Email, Phone number, Passcode, Cred...

             In this blog post, we are going to see steps for migrating MySQL database from any character set to any other character set. M...

DevOps Stage ⇒ is one of the biggest conferences on Cloud Architecture and DevOps in Eastern Europe. 1 DAY, 3 STREAMS, 16 SPEAKERS, 1500+ PARTICIPANTS

  Hello Folks, Hope you are doing well. To begin with, you mostly have come across replication errors (few examples are given below), wher...

MySQL 8.0.27 introduced a new variable to control the maximum of parallel threads InnoDB can use for creating (sorting and building) secondary indexes: innodb_ddl_threads. This new variable is coupled with another new variable: innodb_ddl_buffer_size. If…

Xpand is distributed by design and adds plenty of cool new features to MariaDB, like linear write scaling, built-in HA, data rebalancing etc. MariaDB Corporation's Max Mether goes through some of the details behind Xpand and shows how this is achieved.

*…

Outline High Availability (HA) Basics What is HA and why do we need it? Data Centers (DC) Downtime Causes and Consequences High Availability Levels How to Achieve Necessary Level of HA MySQL Replication as High Availability Solution Major Oracle MySQL HA…

In this session we will look into ways to analyze the instances' performance and share our best practices.

A one-day open source tools and process conference for developers | technologists | students | decision-makers

This post explores Git commit history as a database where ‘git log’ is the query language. Learn about Git’s custom query index – the commit-graph file – and how to make sure it's enabled in your repositories.