Planet MySQL

Displaying posts with tag: read-lock (reset)

May

2011

Posted by Ovais Tariq on Sat 14 May 2011 20:48 UTC
Tags:

Replication, Notes, locking, auto_increment, MVCC, row-level locking, mysql resources, innodb vs myisam, row-based, statement-based, read-lock, locking reads, shared locks, MySQL, auto_inc lock, concurrent inserts, exclusive locks, innodb locking, innodb_autoinc_lock_mode, lock priority, myisam locking, write locks

This is another article in a series of articles titled "A few notes ..." in which I will be posting some important information about locking concepts, different types of locks and what locks table engines support. Just like the previous article, the purpose of this article is to highlight important aspects that you should have in the back of your mind when developing applications.

Mar

2011

On Hot Backups and Restore using XtraBackup

Posted by Ovais Tariq on Sun 20 Mar 2011 10:48 UTC
Tags:

Backup, ubuntu, innodb, myisam, opensource, Backups, transactions, binlog, Percona, online backup, restore, incremental backup, Hot Backup, Xtrabackup, data consistency, cold backup, compressed backup, innobackupex, offline backup, point-in-time backup, prepare backup, read-lock, streaming backup, throttling, transaction log, MySQL

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 how to do backups and restores using XtraBackup.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links