… need to restart all the servers at the same time? Downtime is something we like to avoid! Is it necessary to… and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why… can be tricky if your application does not easily tolerate downtime or read-only mode, especially if you have a lot…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… to degraded application performance, and sometimes even short moments of downtime. As usual with these cases, we set up pt-stalk…’s aggregation job on that. Granted, this means there is no run time data available, but at least you get a…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… of generating md5 digest over tuples in a table with no primary key was not deterministic which could lead to a… surviving node to loose the primary component and cause subsequent downtime. Bug fixed #1108165 (Alex Yurchenko). In some cases non-uniform…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… can be very handy to do the changes with virtually no downtime. Couple of days ago I worked with one of our… the schema changes synchronously and with only couple seconds of “downtime” was really trivial. I’d like to share my experience… longer is the downtime. Our customer built his application so it automatically detects the new schema and so no changes had to…
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… claims that issues in a single Availability Zone should have no impact on other zones in the same region, empirical evidence… recoverable once the downed region recovers) compared with hours of downtime is probably a decent tradeoff. You can also combine this… this are inevitable and will likely cause at least some downtime or degraded service (unless you run active/active, but that…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… you modify same block again there is almost no overhead, and there is no space requirements. Another issue with LVM snapshot it… would like to setup replication for large database with little no – connect USB hard drive place LVM snapshot on it and…” to migrate to the server with proper LVM configuration with no downtime as it is too fragile for every day use. If…
Comment: An argument for not using mysqldump
November 8, 2010 By 26 Comments
… (myisam I’m looking at you), then there really is no way to get a “hot” consistent dump. You can issue… read lock is just that, a lock, and that means no delta transactions as long as the backup is in flight… queries to complete. That means its impossible to guarantee a “no downtime backup” via this method. You’re locked up for flush…
Comment: High availability for MySQL on Amazon EC2 - Part 1 - Intro
June 19, 2010 By 8 Comments
… to work in a lot of other cases where true “no downtime” availability is required. IMHO the Amazon offering is a bit… loss (asynch replication) B) Some production impact, low failover latency, no data loss (synchronous replication) Amazon has an unusual offering (to… they’re offering: C) Some production impact, some failover latency, no data loss Usually if I’m on an app that…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… creative with their system often did that because they had no choice. Of course when they came to the bunch of… applications having no downtime running for years on single MySQL server (which just does not crash) as well as complex no single point…
Comment: Site was down today, support and web hosting.
September 3, 2007 By 27 Comments
… (no load, real awesome live backups), and it’s been very exciting. I myself used it to set up replication with no downtime… offer you the colo space and bandwidth you need (at no cost). I’ll check with a higher to make sure…
