MySQL DBA - Tips and Techniques

By Harjit Lakhan | Practical Tips and Techniques for DBAs.

Why We'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 / …

MySQL

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 happens often 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 …

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.3 dmr, published on Friday, 29 Sep 2017)

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, …

Cloud Computing

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

Defining Moments in Database History · Baron Schwartz's Blog

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. …

MySQL Replication Defaults After 5.7

The default or “out of the box” experience is simply <i>the</i> experience for most people, so it’s critically important for us to ensure that the default …

Databases

MySQL Sharding Models for SaaS Applications

In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one of the most popular database …

Cloud Computing

Testing performance of MySQL Group Replication

MySQL Group Replication is a hot topic in MySQL ecosystem.<br>We have been evaluating it in , and it is now time to evaluate its performance, especially …

Duplicate Indexes in MySQL

Why do we sometimes want to keep duplicate indexes?I’ve done dutiful DBA work in the past to identify and remove what are commonly called duplicate …

Databases

Checking disk activity using iostat

Dec 28, 2016<p>I often use a monitoring system to look at disk activity, but sometimes it’s nice to have a CLI tool to get stats in a different format. …

Stop using FLUSH PRIVILEGES – I used to be a MySQL DBA for Hire

I see suggesting the usage of FLUSH PRIVILEGES every time someone writes a tutorial or a solution to a problem regarding creating a new account or …

Three Ways to Raise Your Cloud Comfort Level

For companies born in the last few years, using the cloud to store data and host applications is more or less second nature. Many pre-cloud IT …

Disaster Recovery

MySQL script automation and security

After MySQL installation, If you don’t have any enterprise level / any GUI interface for monitoring, backup then one of the option is, write your own …

Linux

The Hanging Query

You are a DBA working hard to keep all the databases running so your staff can enter key data. Okay, if truth be known, maybe at the same time you …

Storage Architecture

Storage Overview<p>In this blog post, I will outline MariaDB ColumnStore's architecture, which has the capacity to handle large datasets and scale out …

Using Vault with MySQL

Using Vault with MySQLIn my previous post I discussed using GPG to secure your database credentials. This relies on a local copy of your MySQL client …

Linux