Author Archives: marceloaltmann

MySQL Online Backup with xtrabackup

My last post about backups was a while ago. Although it is still valid, it’s not advisable to use it as daily backup. For that we can use XtraBackup. With XtraBackup, you can take online backups without interrupt the server … Continue reading


Liked? Help and Share!
Posted in backup, MySQL | Leave a comment

MySQL 8.0 – SET PERSIST command

Hi guys. MySQL 8 DMR was released today and it has some cool new features. One of those is the ability to persist dynamic changed variables/configurations across restarts. It’s very usefull if you change variables dynamically. It’s saves you the … Continue reading


Liked? Help and Share!
Posted in MySQL | 1 Comment

MySQL 5.7 using vagrant

Hi there. Today I will write a quick post to show how to easily configure a brand new mysql 5.7 machine using vagrant. Vagrant is a command line utility that provides tools to manage virtual machines for different virtualization technologies, … Continue reading


Liked? Help and Share!
Posted in MySQL | Leave a comment

Invalid datetime when converting to timestamp

Hi there. Today I faced an issue that from first looking at it I was almost sure I`ve found a bug, but putting a bit more research on it, it makes totally sense. I had a table, that I`ll call … Continue reading


Liked? Help and Share!
Posted in MySQL | 1 Comment

Forcing deadlock rollback victim transaction

If you use a storage engine that supports transactions, you probably have faced or heard of deadlock’s. From MySQL Documentation: “Always be prepared to re-issue a transaction if it fails due to deadlock. Deadlocks are not dangerous. Just try again.” … Continue reading


Liked? Help and Share!
Posted in InnoDB, MySQL | 4 Comments

MySQL 5.7 auto-generated root password

Hi There. You may have noticed something different when you install a fresh copy of MySQL 5.7 either via yum or using binary source. The root password is auto-generated. Ok and where can I find it ? Centos cat /var/log/mysqld.log … Continue reading


Liked? Help and Share!
Posted in install, MySQL, password, Security | 11 Comments

Adding your own collation to MySQL

I’m the kind of DBA that prefers to keep everything simple, BUT, sometimes it’s not possible. Few days ago I’ve faced an issue where none of the collations shipped by default with MySQL would guarantee integrity of my database, and … Continue reading


Liked? Help and Share!
Posted in Charset, Collation, MySQL | Leave a comment

MySQL & NoSQL – Memcached Plugin

Many of you have already heard about NoSQL databases and one of the the most used tool is Memcached, where you add a cache layer between the application and database. Since MySQL version 5.6, a new plugin is available to … Continue reading


Liked? Help and Share!
Posted in InnoDB, install, MySQL, optimize, performance | Leave a comment

MySQL Backup Strategy – Slides

Hi there, it’s been a few months since Percona Live London has finished, but I managed just now to get sometime to post the slides from my presentation about backups. Please, take a look and feel free to comment. Pdf … Continue reading


Liked? Help and Share!
Posted in backup, MySQL, Security | Leave a comment

MySQL Fabric – Part 1 – Installing

MySQL Fabric is a tool included on MySQL Utilities that helps you to manage your MySQL instances. It works by basically adding a new layer between your application and MySQL instances, which can provide an easy way to use sharding … Continue reading


Liked? Help and Share!
Posted in install, MySQL, performance, replication | 3 Comments