… June 26th 2013 from 10-11AM PDT. Topics will include: Backups from the cluster Avoiding SST Flow Control What and How…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… Linux side, we recently deployed a pair on servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers… the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL… 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: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the dirty tablespace and voila, you have a consistent binary backup at a point in time. When running Percona Server, you… database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup using the…[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different db names (i.e…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … systems, many people are using a single server with some backups configured, and then simply take the downtime when a restore…. As the application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability (which has some…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
….] The other two NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). In essence, you…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… an open source solution, XtraBackup drives down backup costs while providing unique features for MySQL backup. The new 2.1.1 GA version… and streamed backups in order to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…. The first “open core” plans are announced for MySQL Server – the online backup in MySQL 6.0, it’s to ship in commercial… MySQL 5.4 as next planned GA release. Percona releases GA version of Percona Xtrabackup – open source alternative to Innodb Hot backup. MySQL 5.1.46 is GA and MySQL 5.5.4 is not GA at…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… following: New Features: Percona XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0… that these versions are are recognized by XtraBackup, and that backup/restore works as long as no 5.6-specific features… use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: Fixed couple of warnings found in innobackupex…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… captured from our production systems. We restored a production database backup to our test database so that our test database was…
