… before the backup completes. The pmp-check-lvm-snapshots plugin will alert when a snapshot is failed or overly full. Too many deadlocks…-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give the system administrator time to…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_… on many things including how fast do you need to be able to recover from backups…on the time it takes to warmup too (there are different things you can…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…throw at databases Many people assume their …get this information, too. The last …_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0…as monitoring, alerting, backups, caching, reverse proxies, …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…too) is to really understand what you’re trying to scale and analyze things appropriately. I’ve seen in so many… any “Cluster” having SAN you can always “connect” the storage to another node – if server … allowing to take a backups conveniently. Also if you keep last uncompressed backup on SAN (or …
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…of undo space per second of backup. Now say my backup takes 1 hour which is … Instance. This is good idea for many reason and control over snapshot size … be not to try to save too much on it. Hard drive space …replication for large database with little no – connect USB hard drive place LVM snapshot …
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… not cold Online schema changes Low impact backups Automatic failover with replication I already mentioned …, upon failure, try to kill all the connections to the failing server and transfer the …too much, its read VIP will be moved to another server. As a conclusion, replication can be used in many…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many… be blocked too, which among other tools used by mysql client, so you might get a feel you can’t connect to… TABLES WITH READ LOCK and fail backup or kill long running SELECT queries to let backup to proceed, but resolving server gridlock…
Post: How reliable RAID really is
June 30, 2006 By 13 Comments
… but I guess it should be interested to many MySQL DBAs and other people involved running MySQL… The next interesting thing is – there is not too much advice which could be found in …synchronized to network as backup. If quick recovery is needed snapshot could be connected via network and operations …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…mode) is popular pattern used by many companies using MySQL for scale out… read-only user for slave connection but what if your application … a backup with number of methods supported including compressed backup or incremental backups with…is still in sync) – I see too often this switch happens “dirty”…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…internally because there are many documents about that: …| +—————+——————————————+ Now we take a backup with mysqldump from the master: #…log: ‘The slave is connecting using CHANGE MASTER TO MASTER_…problem again so same solution too: slave1> reset master; slave1> …
