Harjit Lakhan

367 Flips | 1 Magazine | 667 Followers | @harjitsingh63lg | I've been a DBA for (too) many years and mainly MySQL DBA since 2008. I love to keep up to date with the MySQL world and share useful articles here. You can join me on LinkedIn too - www.linkedin.com/in/HarjitLakhan and follow me on Twitter @HarjitLakhan. My blog is http://harjitlakhan.blogspot.co.uk .

The Night of the Living Files

Scary movies for teenagers and database administration tasks share some common traits. Usually, the movie starts with a group of teens making unwise …

How to use mysqlpump for faster MySQL logical backup ?

Simple shell script is bad idea

Internet is full of simple shell backup scripts. Every DBA and system administrators (including myself) has written one. Bash is a bad tool for this …

Flashback: Another Take on Point-In-Time Recovery (PITR) in MySQL/MariaDB/Percona Server

In this blog post, I’ll look at point-in-time recovery (PITR) options for MySQL, MariaDB and Percona Server for MySQL.It is a common good practice to …

Databases

Error Logging in MySQL 8

Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no …

Databases

Three Ways To Energize Your DBA Career In The Cloud

It’s no secret that data is the new black gold—a source of wealth creation on par with financial capital, say some. So it’s a little ironic that a group of people who understand better than anyone how to manage data are feeling increasingly left out of the party.<p>Database Administrators, or DBAs, …

Databases

MySQL Log Rotation

OverviewI find far too often that MySQL error and slow query logs are unaccounted for. Setting up log rotation helps make the logs manageable in the …

Databases

Writing a MySQL storage engine from scratch

Describes how to write a MySQL storage engine - a plugin which is responsible for persisting MySQL table data.

Databases

Windows Tools for MySQL DBAs: Basic Minidump Analysis

<i>"To a man with a hammer, everything looks like a nail."</i><p>Even though I had written many posts explaining the use of <b>gdb</b> for various MySQL-related tasks, …

How to safely upgrade to MySQL 8.0 ?

As for each previous version, to upgrade to MySQL 8.0 you must first read the upgrade section in the manual. It’s important to know that you should …

MySQL vs MariaDB vs Percona Server: Security Features Comparison

Security of data is critical for any organisation. It’s an important aspect that can heavily influence the design of the database environment. When …

Databases

Why We&#039;re Excited About MySQL 8.0

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents “Why We're Excited About MySQL 8.0” on Wednesday, January 10, 2018 at 11:00 am PST / …

Dear MySQLers, the Cloud Is Good, But the Fog Is the Next Big Thing

And here we go again: here is another term. We are still debating about the real meaning of Cloud and if a database fits in IaaS, PaaS, S...

Replication: Been Down So Long it Looks Like Up to Me (with Apologies to the Family of Richard Farina)

You as a MySQL administrator/developer are really excited about invisible indexes in Release Candidate Version 8.0 of MySQL. You know that your users …

Verify MySQL Backups With TwinDB Backup Tool - TwinDB

If you don’t verify backups you may safely assume you don’t have them.<p>It often happens that MySQL backups can be invalid or broken due to a software …

Where does my MySQL configuration variable value come from ?

As you may already know, there are many different places where a MySQL configuration variables can be initialized.<p>In MySQL 8.0, we added in …

ZFS from a MySQL perspective

Since the purpose of a database system is to store data, there is close relationship with the filesystem. As MySQL consultants, we always look at the …

Databases

MySQL 8.0: Preview @ PHPWorld

These are the slides for my MySQL 8.0 Preview: What is coming? At PHPWorld 2017.<p>Abstract:<p>Yes, you read it correctly, we are jumping from 5.7 to 8.0 …

Percona Monitoring and Management 1.3.1 Is Now Available

Percona announces the release of Percona Monitoring and Management 1.3.1. This release only contains bug fixes related to usability.For install and …

MongoDB

MySQL Partitioning [Quick Overview]

This Blog Post is an overview of MySQL Partitioning and its operations, Will explore following points for MySQL Partitioning,• About …

Databases

Histogram statistics in MySQL

As of MySQL 8.0.3, you now have the ability to create histogram statistics in order to provide more statistics to the optimizer. In this blog post, …

Databases

MySQL Router 8.0

MySQL Router 8.0 (8.0.11 GA, published on Thursday, 19 Apr 2018)

MySQL

Linux mysqldump command help and examples

Updated: by Computer Hope<p>About mysqldump<p><b>mysqldump</b> "dumps" a mysql database, or a collection of databases, for backup or transferral to another SQL …

Ignoring the lost+found Directory in your Datadir – Chris on MySQL

I still get asked about the lost+found directory enough, and so I wanted to provide a current update.<p>The lost+found directory is a filesystem …

Running XtraBackup on Windows using WSL

Backing up MySQL on Windows: options?<p>I had a recurring consultation this summer with a client who is running a stand-alone MySQL database with a ton …

Open Source Databases - The Real Cost of Free

As many wise men and women have said, “nothing in life is free.” While some could debate that fact in the eyes of philosophy, in the database market, …

Linkbench - in-memory, low-concurrency

After a few weeks of sysbench it is now time for more complex workloads and the first one is Linkbench with a cached database and low-concurrency. I …

MariaDB ColumnStore - LONDON MySQL Meetup

MariaDB

Defining Moments in Database History

The rise of the LAMP stack in the early- to mid-2000s created a shift in the technology landscape, as well as the impetus for contenders to emerge. …

Databases