… to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped. It can… can be built remotely through a KVM over IP and adequate remote power management, an on site intervention with physical access to the servers is the preferred way, especially for the most complex solutions. Proof of concept Migration to Production MySQL…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
…, 40 GB of data) the schema in sql format No remote access Their first question was “Is it possible to recover the… the tablespace At this point I should have access to the table but, although MySQL was not complaining, the data was not…/lib/mysql before the first run to make sure I could restart if needed, which of course, I did a few times…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… running with 2 nodes too. 2. Each Node is regular MySQL / Percona Server setup. The point is that you can convert your existing MySQL / Percona Server into Node and roll Cluster using it as… locally, no need for remote access. No central management. You can loose any node at any point of time, and the cluster will…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… available in MySQL 5.6… – Replication Event Checksums – Time Delayed Replication – Server… Reduced Overhead – - Simplified Configuration – - Table Access instrumentation – - Statements instrumentation – - Stages …/Export for Partitioned Tables – Remote Binlog Backup – Innodb Transportable…
Post: Living with backups
November 6, 2008 By 28 Comments
…and such access pattern may be preferred by the I/O scheduler over random I/O coming from MySQL, …kept there for a long time. Since memory access is way faster than any disk access, even with the fastest …is redirected through the pipe over SSH to a remote host where a script reads the standard input …
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…. So this is the access pattern which is often going to define your MySQL on DRBD Performance. Lets … the block over network, executing it on the remote node and responding with ACK, assuming the DRBD … requests. This means DRBD slow down things 3 times+ writes. There is nothing wrong with DRBD, it …
