… reflects our opinion) In my talk on MySQL Conference and Expo 2010 “An Overview of Flash Storage for Databases” I mentioned that…, but taken from vendor’s specification) As for power failures – flash modules also come with capacitors which guarantees data delivery to… highlight: I am impressed with architecture design with replaceable individual flash modules, I think it establishes new high-end standard for…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… two years already. It is also described in ACM article “Flash storage memory” by Adam Leventhal. So I am exciting to… Mohan Srinivasan from Facebook released Flashcache, which allows to use Flash as cache in front of regular hard drives. The implementation….google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… technology allowing to dramatically increase performance of complicated join queries. MySQL users are always hungry for better performance as you might… we can call it pretty proven used with MySQL. Nimbus Data also handles Flash storage but at different scale. If you prefer… which will offer tutorials and conference sessions from many experienced MySQL practitioners and project leaders, including keynote by Monty Widenius, founder…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
… Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2…-0 (18252) Driver : 1.1-5 (24702) Boot Flash : 5.2-0 (18252) ——————————————————– Controller ZMM Information ——————————————————– Status …
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least… use capacitor instead and bundle 512MB cache with 512MB of Flash so when power goes down the cache is stored on… done without server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase…
Post: L2 cache for MySQL
October 25, 2012 By 13 Comments
… InnoDB buffer pool. Fortunately, there is a project in progress Flash_Cache_For_InnoDB by David which implements this. David helped… Server 5.5.28 I think that naming this as Flash_Cache is confusing due similarity to Flashcache from Facebook, so… it as L2cache. There is a quick benchmark on tpcc-mysql 2500W (250GB), I used data on RAID data on SSD…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
… to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn drive, which offers consistent, low… great feeling to have an explicitly recommended reference architecture: buy flash storage first, shard as a last resort. From the summary… up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
Now that flash storage is becoming more popular, IO alignment question keeps popping … smallest amount of disk IO that systems can do. NAND flash on the other hand can have a page size of…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at… PCIe Flash Card Filesystem: ext4 Software OS: CentOS 6.3 MySQL Version: 5.6.7-RC Benchmark specification Benchmark name: tpcc-mysql Scale… change the result significantly, especially in intensive IO workloads. In MySQL 5.6 it is finally possible to achieve stable throughput…
Post: What attendees are saying about Percona Live NYC ?
September 19, 2012 By Leave a Comment
… and beyond simply a MySQL conference. I can always count on enjoying presentations on surrounding technologies including flash storage, hadoop, the cloud… event and hope to see you there!” Sean Hull, Senior MySQL EC2 & Scalability Lead have written while essay on the topic… foyer, I ran into all sorts of luminaries in the MySQL space. Percona folks like Peter Zaitsev & Vadim Tkachenko, plus other…
