… backup infrastructure as it gives you the possibility for point in time recovery. After restoring a database from backup you have the option to… loss depending on the interval you back them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports… in “dry-run” mode. Please note MySQL 5.6 is not yet released as GA but you can use mysqlbinlog to backup MySQL…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…backup to restore a single table). Percona XtraBackup now supports streaming incremental backups. In previous … in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL …- 16:20 @ Ballroom D Extending Xtrabackup – A Point-In-Time System, Wednesday 11th April 16:30 – 17…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… binary logs (for example point in time recovery from backup) …catch up or when restoring from backup, the …mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_TIME…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is … that are hard to maintain, back up, and restore. And the partitioning functionality is not done … how much time do you have? And the gains are simply limited by some of MySQL‘s weaknesses in …
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… load balancer did not restore proper response time, so it wasn’t load. It was probably crossing a tipping point in the data size… a server having micro-freezes, and capturing diagnostic data just-in-time, is a poor man’s way to identify what’s… — and that’s where improvements to the MySQL source code are necessary. But in many cases something can be done, such as…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…. But if you later restore enforcement, MySQL does not immediately scan all…in a strange state where RI constraints are active, but we cannot assume that all our data satisfies RI. At some point… at any time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1….
Post: Small things are better
October 8, 2006 By 15 Comments
… page writes but still they can get corrupted because of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes… to have backups for. Backups however take time to restore, especially if you do point in time recovery using binary log to get to actual… allow per table backup and recovery to happen faster. With MySQL and blocking ALTER TABLE there is yet another reason to…
Comment: Why you don't want to shard.
August 14, 2009 By 34 Comments
…causes operational concerns – databases in TB range are often not fun in MySQL due to challenges …restored backup from yesterday and it will be consistent (even though not up to date) – in sharded envinronment backups will correspond to different point in time and so would not…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… both incremental and full restores The ability to …up to point of the commit. At that point …mysql> select * from autoinc; +—+——-+ | i | j | +—+——-+ | 1 | node2 | | 4 | node2 | | 7 | node2 | +—+——-+ 3 rows in set (0.00 sec) node1 mysql… single node in the cluster (at a time)– all …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… matches state of the volume at the time storage is created. In LVM it is implementeed as copy … to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL Server … just in case, or you can assume in case of recovery from the backup you will need to restore …
