Author - Daniel Kowalewski

Webinar Tuesday April 17, 2018: Which Amazon Cloud Technology Should You Chose? RDS? Aurora? Roll Your Own?

Amazon Cloud Technology

Please join Percona’s Senior Technical Operations Engineer, Daniel Kowalewski as he presents Which Amazon Cloud Technology Should You Chose? RDS? Aurora? Roll Your Own? on Tuesday, April 17, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).
Are you running on Amazon, or planning to migrate there? In this talk, we are going […]

Read more

Migrate to Amazon RDS Using Percona Xtrabackup

Migrate to Amazon RDS

In this blog post, we’ll look at how to migrate to Amazon RDS using Percona XtraBackup.
Until recently, there was only one way to migrate your data from an existing MySQL instance into a new RDS MySQL instance: take and restore a logical backup with mysqldump or mydumper. This can be slow and error-prone. When […]

Read more

Using the loose_ option prefix in my.cnf

MySQL Grants and Users

In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL.
mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file.
For example:

2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknown variable ‘bogus_option=1’

1

2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknown variable ‘bogus_option=1’

The MySQL manual has a solution: use the loose_ prefix […]

Read more