… uses transactional model, metadata checksums may be sufficient. With full data checksums there are going to be penalties – with both time…. Imagine running InnoDB over XFS, you will end with two sets of checksums – one that of InnoDB and other of XFS…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-second intervals. All tests were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool… case where a deployment has a massive data set size in relation to both the working set and the cache device size, the…_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…, here is the basic approach: data = fetchCache(key) if (data) { return data } data = callExpensiveFunction(params) storeCache(data, key) return data Memcached is a very popular (and… common design consideration when using a cache layer is that “data in cache may go away at any point”, this can… ms range per/cmd Keep in mind that the entire data set fits into the buffer pool, so there are no reads…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… replicated data. Setting this up is actually quite easy to do and probably will look familiar to a lot of people. Setting up… it enabled. Other SSL options It is also possible to set the following options (though they seem to have sane defaults… default Other questions Will IST be encrypted if I set the above settings? Yes, according to Codership, IST transfers use the same…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… see the benefits and unless you get to the large data sets you will not see large benefits. The Cloud might change…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… mean you can’t modify data on multiple cluster nodes simultaneously. You can. It does NOT set an lower bound on performance…. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is fine as long… (100, 1, NOW()); Conclusion Choosing a system to replicate your data to a distributed system requires tradeoffs. Most of us are…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… database. It would have an 80×24 text UI for entering data and a separate UI for generating reports. This evolved into… more than one 80×24 screen to enter in all the data! You could also have things like NEXT_NUMBER fields (what… MySQL 5.6, it’s replaced by the following set of defines #define DATA_N_SYS_COLS 3 /* data0type.h */ /* from rem0types…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… from the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as… available binary log, which is very likely to corrupt your data by reexecuting some queries. Here’s a trick to make…_File: Slave_IO_Running: No Slave_SQL_Running: No [...] Connection settings are automatically restored, which makes disconnecting the replica impossible. And…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers make… tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO…_id` SMALLINT UNSIGNED NOT NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8′ COLLATE ‘utf8_general_ci’ NOT NULL, `last_name` VARCHAR…
