…Percona XtraBackup can now save Galera replication information while performing a …a single table). Percona XtraBackup now supports streaming incremental backups. In …in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…overcome for specific use cases. I decided to write a series of blog posts on MySQL‘s … Do the replication in the application. I know of applications where they just don’t use built-in replication. … For example, mixtures of transactional and non-transactional tables are a nightmare. Here are a few …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables…tables do not support them. So in practice it is MyISAM related. expire_logs_days This is replication…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… you ever wondered what servers are in your MySQL replication hierarchy? We have, too. …replication hierarchy and specific things about it, such as replication filters, versions, whether replication …Replication Is a slave, has 0 slaves connected, is not read_only Filters replicate_wild_ignore_table…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication…in particular hurts log writes which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL…the time if Innodb or MyISAM tables are used. There is read-…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables…table in some scenarios. Bug Fixed:#798371 (Yasufumi Kinoshita). Other Changes Improvements and fixes on platform-specific…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…table cache is full. If the closed table was on the FEDERATED engine and a replication… in MySQL (Alexey Kopytov). Querying global_temporary_tables caused the server to crash in…table in some scenarios. Bug Fixed:#798371 (Yasufumi Kinoshita). Other Changes Improvements and fixes on platform-specific…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… when using disk based hash tables it would be a compelling … It does support replication which could make some rather interesting architectures in the future… is I started to hit bottlenecks in MySQL/Innodb when I had enough …a bit. Bottom line given a specific application and data pattern sometimes …
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… lot improved in 5.0.37 which I’d expect to show significant gains. This is not to mention specific tuning for… from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts, Query Cache, Merge Tables, Archive Tables, Simple Replication. Most…
