Tag: percona

Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL

In High Availability, MySQLTags cluster, data consistency, high availability, mysql, ndb, node fencing, partitioning, percona, replica, xtradbOctober 31, 20134 Comments

ovais.tariq

Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server. I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post. So here I will be …

Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

In Innodb, MySQL, PerformanceTags 228, ICP, index condition pushdown, indexes, mariadb, mysql, optimizer, percona, PLMCEMarch 13, 20121 Comment

ovais.tariq

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5

Moving on to Percona

In MiscellaneousTags blog, career, engineers, express news, interesting, moving, new job, percona, posts, skills, smart, team, technical support engineerJuly 10, 20112 Comments

ovais.tariq

Yesterday was my last day at Express News. I have been working here for more than a year now and it has been a pretty good time. I had the opportunity to work with some great engineers and I am lucky that I have them as my friends.

On Hot Backups and Restore using XtraBackup

In Backups, MySQLTags backup, binlog, cold backup, compressed backup, data consistency, hot backup, incremental backup, innobackupex, innodb, myisam, mysql, offline backup, online backup, opensource, percona, point-in-time backup, prepare backup, read-lock, restore, streaming backup, throttling, transaction log, transactions, ubuntu, xtrabackupMarch 20, 201121 Comments

ovais.tariq

Backups are an integral and very important part of any system. Backups allow you to recover your data and be up and running again, in the advent of problems such as system crashes, hardware failures or users deleting data by mistake. I had been evaluating backup solution for a while but to be honest I really wasn't satisfied with the solutions available until I came across XtraBackup and I am loving it since. In this post I intend on showing …