… it’s currently up and available for viewing over at percona.com. My apologies … NIC ports should be bonded with active-backup or LACP (depending on your switching infrastructure). … file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially… Unlike views which use the complete refresh method, incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored… from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer…
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 6 Comments
XtraBackup works great for backing MySQL up to an NFS volume, but there is a gotcha … that volume to prepare the backup (apply the logs), that other server might not have a consistent view of the data. That… they are completely ready to use. (You should test your backups even more than that — we’ve blogged before about that…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …Com_assign_to_keycacheblogpercona.commanual Com_backup_tableblogpercona.commanual Com_beginblogpercona.commanual ….commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona.commanual …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…:20:17 [Note] WSREP: New cluster view: global state: 77c9da88-b965-11e1-0800-ea53b7b12451:97, view# 18: Primary, number of nodes: 3… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp… acting as backup nodes. If you are using HaProxy for MySQL you can break the privilege system’s host part, because MySQL will…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… XtraBackup for MySQL for binary backups mydumper for logical backups mysqlbinlog 5.6 Amazon S3 monitoring for all the above Philosophy on backups It… on mydumper to dump schema’s. It does not handle views/triggers/procedures etc. Run with –no-schemas, instead use mysqldump… for MySQL backup systems for future posts Detailed strategies for different types of restores Strategies on retention dailies weeklies, long term backups Decompressing…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… the big “Selling Points” of MySQL is support for Multiple Storage engines, and from the glance view it is indeed great to… we’re up for a lot of surprises. Backup Cross storage engine backup is a pain because they are so different. Some…). Finally backup can be done in truly hot way without nasty “FLUSH TABLE WITH READLOCK” and hoping nobody is touching “mysql” database…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL/OS upgrades and Schema changes. Backups… to that backup – no data copy will be required which can be significant concern to 1TB+ databases. My Take: I view SAN as solution for niche circumstances when it comes to MySQL. It may be you need…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… in MySQL. The binary log is necessary not only for replication, but for point-in-time recovery, too. Given a backup and… server internals fully enough to have a 50-thousand-foot view of it all. The binary logging and replication code, and… transaction logs, so there’s even precedent for this among MySQL storage engines. And there is Galera’s multi-master synchronization…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all… because this makes it very easy to use LVM for backups while assuming you have BBU on the raid volume impact… optimize swap performance. I also fully support Matt in his views of black boxes. If you want to be able to…
