MySQL DBA - Tips and Techniques

By Harjit Lakhan | Practical Tips and Techniques for DBAs.

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 …

Project Management

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

Databases

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 …

Databases

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

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

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 …

How MariaDB ColumnStore Handles Big Data Workloads – Storage Architecture

How MariaDB ColumnStore Handles Big Data Workloads – Storage Architecture david_thompson_g Mon, 12/12/2016 - 18:32Storage Overview In this blog post, …

Big Data

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

Changing the Tablespace Directory with pt-online-schema-change

In this blog, we’ll discuss changing the tablespace directory using pt-online-schema-change.One of the most annoying situations in the life of a DBA …

Linux

Testing and verifying your MySQL backup strategy presentation

From the IAOUG Gold Coast OTN Day, Ronald Bradford gave a presentation on “Testing and Verifying your MySQL Backup Strategy”. Details in this …

MySQL

Stopping a Runaway Rollback due to Failing Mass Import or ALTER TABLE – Chris on MySQL

I ran into this the other day, and while the solution is documented in the manual, it was kind of buried, so I thought I’d mention it here (and …

MySQL 5.7 and administration

MySQL 5.7 improved as compare to previous releases in terms of transnational capabilities, performance with high load, high Availability, Security …

Linux

MySQL Architecture and Components

This blog post is all about new MySQL 5.7 physical, logical architecture and it’s components.In this blog post, I will try to explain things in flow …

MySQL Server bootstrapping and dictionary initialization

In MySQL 8.0, we are making large changes to the way the MySQL server stores meta data with the introduction of our native data dictionary. As part …

Linux

Critical MySQL Vulnerabilities Can Lead to Server Compromise

Critical vulnerabilities in MySQL and database servers MariaDB and PerconaDB can lead to arbitrary code execution, root privilege escalation, and …

Information Security