In this blog we will create MySQL backup and then restore single table from Percona Xtrabackup without doing full restore. This post is basically a work-log in response to a feedback on my previous blog about MySQL Interview with ChatGPT. Here is a video recording of the steps described below for restoring single table from xtrabackup. Create a compressed MySQL backup using Xtrabackup xtrabackup --backup --compress --compress-threads=8 --target-dir=/root/backupdir Output in backup directory [root@ip-172-31-83-17 ~]# ls -lhtr /root/backupdirtotal 3.1M-rw-r-----. 1 root root 164K Dec 14 17:11 ibdata1.qpdrwxr-x---. 2 root root 31 Dec 14 17:11 sysdrwxr-x---. 2 root root 23 Dec 14...

The post Restore single MySQL table from Xtrabackup (video demo) first appeared on ..::CHANGE …

Given the recent surge of interest in ChatGPT and the AI capabilities it offers, I decided to conduct an interview with it to assess its suitability for a MySQL Consultant position. This blog post is a result of that interview, during which I asked ChatGPT a range of questions related to MySQL and other relevant topics. As I expected, the interview candidate performed well on the theoretical questions, but some of their answers to the practical questions were incorrect and could potentially cause significant damage to a database. This blog post only includes a portion of the full interview conversation....

The post MySQL Interview – ChatGPT is not your DBA first appeared on ..::CHANGE is INEVITABLE::...

This ProxySQL post is sourced from an error I faced recently handler___status_CONNECTING_CLIENT___STATE_SERVER_HANDSHAKE(): [ERROR] ProxySQL Error: Access denied for user ProxySQL has become one of the popular choice as the “proxy” for MySQL databases. This post is tipping you off for debugging connectivity issue and fixtures around it for a specific use-case. ProxySQL Connectivity Ofcourse while to connect ProxySQL we have two choices for what we want to do: Admin Interface and MySQL. Admin interface allows us to configure and manage the ProxySQL. MySQL interface is basically the “proxy” connectivity to MySQL databases configured in ProxySQL. Connecting ProxySQL Admin Interface mysql...

The post Can not connect to ProxySQL: reasons and fixtures first appeared on …

In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday. This blog post is my attempt to share the proofs of existence of a “Friday”. Using MySQL datetime function: dayname Running system command from MySQL prompt Using ntpd service with shell script and cowsay...

The post Providing Friday Proofs to MySQL Consultants first appeared on ..::CHANGE is INEVITABLE::...

Two or more dots in your relay log or binary log names can break replication; but worry not, it will only do it once. If you request to start again, it will work. That’s it, that’s the blog. Should you choose to spend some more time, go ahead. A new MySQL 5.7 GTID replication chain was being constructed and fail-overs were being tested while an oddity of MySQL replication revealed itself. The Orchestrator graceful fail-over was not able to attach the replica and reporting an error. Every possibility was investigated: “the master’s binary log is corrupted”: No, master binary logs...

The post 2 many dots can break your replication only once first appeared on ..::CHANGE is INEVITABLE::...

This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps for Xtrabackup configuration. Though this post is for Ubuntu Linux with holland + mysqldump while we already have an old post to set-up Holland with Xtrabackup on Redhat / CentOS. Let’s begin the execution. Installations for Holland Backup Framework on Ubuntu root@nitty-witty:~# . /etc/os-release root@nitty-witty:~#...

The post MySQL Backup setup, automation using Holland, mysqldump on Ubuntu first appeared on ..::CHANGE is INEVITABLE::... …

Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check failed to verify a MySQL master’s binary log coordinates. My colleague working from the other side of the globe observed the following: mysql> show master status; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary logging Interestingly, the...

The post Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR? first appeared on ..::CHANGE is …

This post covers Proxysql start up process, Layers and configuration file.

The post ProxySQL Configuration File & Startup Process Explained first appeared on ..::CHANGE is INEVITABLE::...

This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the backup to specified offsite location. – Upon detecting failure in any of the above step, it will send out failure email. – Upon overall success, it will sendout success email with execution time and present backups list. You might be looking for setting up physical...

The post mysql database backup shell script with status email first appeared on ..::CHANGE is INEVITABLE::...

This blog post gives an introduction to resource groups in MySQL 8 and dynamical allocation to threads, as well as a related bug report.

The post MySQL 8 Resource Group – introduction and dynamic allocation first appeared on ..::CHANGE is INEVITABLE::...