… MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect…back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL is up… MySQL and OS-level status variables that you might want to keep an eye on to prevent a problem…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…the same problem for s0 (which will be late when it comes back) and…s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave;… will have to promote the most up-to-date slave and reconfigure…using GTIDs is usually straightforward: just connect the slave to the correct …
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
…MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back…up. [caption id="" align="alignright" width="336"] Registration signs from the 2003 MySQL…, people who I previously only connected with online. I enjoy …who is aware of the problem and is able to answer…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… strong suit) with some roll-up aggregation, which should produce updates …concerning, and it might be a problem for some users. Now, I… = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors…= 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… to recover changes that happend after taking a backup. The problem with this approach was that you had to do periodic… the interval you back them up. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman…
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…back online. If the backup did take the node offline, IST would be leveraged to catch it back up…this). If that becomes a problem for you, you can …cluster. Q: Are adding/updating mysql user accounts replicated? Yes, …configurations, and the application must connect to the appropriate one, depending…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…connected or Threads_running. That’s a good place to start for finding a symptom that can trigger the problem… on Linux that we end up scripting mostly Linux-centric things,… line every 30 seconds. Come back later and see what it …that can cause a stall in MySQL, and they usually begin microscopically …
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
…connection. I’ll explain the math below. Second – is MySQL parameter back…problem and do some Math. First lets look into how MySQL accepts connection. There is single main thread which is accepting connections…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… bug fixes each of these releases contain. Using xtrabackup to back up older MySQL or Percona Server releases is still supported. This release… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking… –slave-save-info. This bug fix simplifies the connection code so that such problems are harder to create in the future along…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… to ensure your backup is consistent. Backing up database which was already corrupted is very nasty problem you want to avoid. Let’s… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… you want to let MySQL Server to continue, which is done by running UNLOCK TABLES or simply closing connection. 5) Mount backup…
