… details later. How does online backup work in PBXT, and is incremental backup possible? A recent version of PBXT (1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… with many nice features: Works with MySQL 5.1 and MariaDB 5….we have Semi-synchronous slaves. How it works on slaves: slaves just … and its incremental backup features, it is possible to have incremental node provisioning. …2011): It was my misunderstanding: Galera does work with InnoDB-plugin also. …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… popular pattern used by many companies using MySQL for scale out. Most of the …Open Source friendly. So what does this tool do and how it works ? Currently it is implemented…to create a backup with number of methods supported including compressed backup or incremental backups with rdiff. Finally…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup…not supported. You can work around many … incrementally refreshable version does not take long to refresh: mysql…helps you understand how Flexviews can…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non-blocking backups…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…incremental…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…series. Also note the “Auto Increment Issue” is finally solved in…backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql… specifically around mutexes and contention? How does this fit into the development process…find fixes for them. The work continues. I believe improving …
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 18 Comments
…convert your existing MySQL / Percona Server …duplicates This basically defines how Percona XtraDB …work, you can continue to run queries on working…Transfer (SST) and Incremental State Transfer (IST…does not require READ LOCK for full time, only for syncing .frm files (the same as with regular backup…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…worked for me, it may work for you too, but always have a backup…mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062 (23000): Duplicate entry ’0′ for key 1 Unfortunately, adding auto_increment does not work…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… which may do very little work and formating, so > database… > 2. Not using auto_increment functionality This is right. With … different with MySQL. Good design will help dictate how many … much easier to do backup > and restore if …normalize your data however it > does not always bring good performance…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… that running statistics on your backup database does not need to hurt production … results). Let’s see how it works. I have one table with…_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And…–tables=art.link* –datadir=/mnt/data/mysql/ which will show something like this…
