MySQL DBA - Tips and Techniques

By Harjit Lakhan | Practical Tips and Techniques for DBAs.

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

Databases

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 …

Replication

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 …

Python Programming

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 …

Linux

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 …

Linux

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 …

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 …

Databases

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

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

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

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

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 …

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 …

Databases

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

Everyone's Capable of a Performance Mindset

Solving performance problems isn't rocket science, it's not a dark art, it's not the exclusive domain of an exceptional few. It's something we all …

Science

Continuous MySQL backup validation: Restoring backups

Facebook's MySQL databases are spread across our global data centers, and we need to be able to recover from an outage in any of these locations, at …

Cloud Computing

MySQL Downgrade Caveats

In this blog, we’ll discuss things to watch out for during a MySQL downgrade.<p>Previously, I wrote the blog MySQL upgrade best practices. Besides …

Databases

Encrypt your –defaults-file

Encrypt your credentials using GPGThis blog post will look how to use encryption to secure your database credentials.In the recent blog post Use …

Linux

Online Schema Change for MySQL

This Facebook post is no longer available. It may have been removed or the privacy settings of the post may have changed.;

MySQL Database Security Best Practices

The MySQL database has become the world’s most popular open source database because of its consistent level of fast performance, high reliability and …

Linux

Oracle Cloud Learning Subscriptions

Oracle

Understanding mysql_config_editor’s security aspects

The recent release of 5.6.6 includes a new utility, mysql_config_editor, which makes it easier to interact with MySQL clients securely. At the same …

Linux