… the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL… drops to 33% after the first snapshot so keeping a large number of snapshots running is simply not an option. With… solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and the backups are…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…two NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). …occurs. For example, if you see a large number of long-running queries in the… file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-…large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a production database backup…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large data sets and mission-critical… an open source solution, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, unlike anything you find in standard async MySQL replication. It is my belief that the … node, or perhaps the effect of some large transaction briefly stalling an applier thread. However, … or some other maintenance operation (like a backup) doesn’t inadvertently cause flow control on your…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… based MySQL backups are great ? There are number of reasons: Almost Hot backup In most cases you can perform this type of backup while… to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES… backup process – I’ve specified 16GB in this case. If your undo size is not large enough snapshot will get invalidated and backup…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… 1MB were extended to 1MB on the backup prepare operation. This led to a large increase in disk usage in cases when… the bug #711166 introduced a regression that caused individual partition backups to fail when used with –include option in innobackupex or… for temporary files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error reporting for unrecognized server…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…Enterprise managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication …MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable…assign_to_keycacheblogpercona.commanual Com_backup_tableblogpercona.commanual Com_beginblogpercona.commanual…languageblogpercona.commanual large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large_pagesblogpercona….
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as… medium and large size databases – for databases below 100GB in size compression performance is usually not the problem (though backup impact on… we used MySQL binary log file which often contains plenty of similar events, which could be the reason for so large size…
