…investigation and would require different client libraries and benchmark methodology.
My goal here was to compare a transparent switch (in terms of code) and experiment with the memcache plugin. Even the use of HandlerSocket would require coding changes (which is why it was also left out of the discussion).
The post MySQL 5.6 - InnoDB Memcached Plugin as a caching layer appeared first on MySQL Performance Blog .
- Oleksiy Kovyrin: Quick (and dirty) Patch for Ruby Enterprise Edition 2011.03 to Prevent Hash Collision Attacks
- coderrr: How to force Flash or any program to use a SOCKS proxy using Transocks and iptables in Linux
- Tender Lovemaking: Profiling Rails startup with DTrace
- Rowan Hick: Textmate favourite features
- Litany Against Fear: Pimping the Windows Command Line
- Videos related to 'Ruby on Rails vs Java - Commercial #1 of 9': Programming Tutorial: BAT,GWB,QB,VBA,HTML,PHP,Java,Python
fast_index_creation variable has been removed, it is replaced by the MySQL 5.6's ALGORITHM= option to ALTER TABLE
HandlerSocket has been removed from the tree. It was not built with the 5.6.5-60.0 binaries and may return when HandlerSocket supports MySQL 5.6.
SHOW [GLOBAL] TEMPORARY TABLES functionality is now only available via the TEMPORARY TABLES and GLOBAL TEMPORARY TABLES INFORMATION SCHEMA tables.
…poor IO. So, if you were deciding to not use RDS and run your own MySQL servers with the HandlerSocket plugin, it wouldn't bring you much improvement (1) . Actually, if you are already IO bound, it would make things worse, because you are centralizing your system around the most unreliable part of your architecture. Based on that premise, RDS won't support HandlerSocket because RDS runs on the same AWS architecture and has to deal with the same IO constraints. What's …
- High Scalability: Scaling an AWS infrastructure - Tools and Patterns
- blog.webandy.com | Andy Atkinson: Twin Cities Code Camp 2006
- Justin Leitgeb: NYC Amazon Web Services Meetup Talk
- paperplanes: Be Humble, and Get Shit Done!
- Engine Yard Developer Blog: Announcement: New Engine Yard Private Cloud Infrastructure
- Opscode Blog: enStratus and Opscode Announce Partnership
…Yoshi's tests show that direct access to InnoDB via the HandlerSocket protocol yields a significant improvement even when compared to a raw memcached connection! Perhaps it is memcached we should be optimizing, not running away from our RDBMS engines?
Hands on with HandlerSocket
To get started, follow the installation instructions provided in the HandlerSocket repo, or simply pickup one of the latest builds of the Percona Server - it now ships with HandlerSocket …
- MySQL Performance Blog: HandlerSocket on SSD
- High Scalability: Stuff the Internet Says on Scalability For December 17th, 2010
- Labnotes: Rounded Corners 258 — Taco bell
HandlerSocket has been upgraded to version 1.1.0.
Bugs Fixed:
Loading LRU dump was preventing shutdown. Bug fixed # 712055 ( George Ormond Lorch III ).
The kill idle transactions feature in XtraDB (if enabled) could sometimes cause the server to crash. Bug fixed # 871722 ( Stewart Smith ).
Fixed server assertion error related to buffer pool, only visible in debug builds. Bug fixed # 905334 ( Laurynas Biveinis ).
Querying I S.GLOBAL TEMPORARY TABLES…
What is HandlerSocket?
Where does HandlerSocket fit in my application stack?
Why would I want to use HandlerSocket?
How do I use Handlersocket?
He'll walk through relevant configuration & tuning options, and at the end of the presentation attendees will be able to identify candidate use cases within their application to use HandlerSocket.
For a chance to win a free ticket to Percona Live London and get the opportunity to hear Ryan and so many others speak on a number …
- igvita.com: HandlerSocket: The NoSQL MySQL & Ruby
- Merbist: Causality of scalability
HandlerSocket, a NoSQL plugin for MySQL, has been updated to the latest stable version as April 11th, 2011.
The authors of the plugins used have been corrected. Bug Fixes: # 723050 ( Y. Kinoshita)
For more information, please see the following links:
Downloads: Binary distributions , Percona Software Repositories
Consulting , support , training , and custom development
- Junior developer: Rails test data not getting rolled back
- Signal vs. Noise: Keeping your slave warm
- paperplanes: MongoDB, Data Durability and Improvements coming in 1.8
- Axon Flux // A Ruby on Rails Blog: Impressive tech talk on Scaling MySQL at Facebook
- High Scalability: Facebook at 13 Million Queries Per Second Recommends: Minimize Request Variance
- carpeaqua by Justin Williams: My 2010 Ultimate Developer and Power Users Tool List for Mac OS X (2010 Edition)
HandlerSocket, a NoSQL plugin for MySQL, has been updated to the latest stable version as April 11th, 2011.
InnoDB fast index creation now works with mysqldump, ALTER TABLE and OPTIMIZE TABLE. ( Alexey Kopytov)
Variable Changes
Variable innodb_extra_rsegments was removed because the equivalent, ‘innodb_rollback_segments', has been implemented in MySQL 5.5. ( Yasufumi Kinoshita)
Bug Fixes
Bug # 757749 - Using ALTER TABLE to convert …
- A Fresh Cup: Double Shot #578
- JJinuxLand: MySQL: Disk Usage Can Never Shrink When Using InnoDB
- Simple thoughts - articles: The Internal Storage Mechanism For Globalize for Rails Model Translations
- Pennysmalls: Much faster Rails tests if you use MyISAM
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- Rails Envy » Home: RailsLab: Scaling Your Database - Part 2
Most of these "issues" will work themselves out naturally as HandlerSocket matures. More people will publish benchmarks and use cases. As companies upgrade their Percona-Server installations, HandlerSocket will become available and easily accessible to them. Finally, as the code matures and the community grows, we'll see lots more third-party involvement with bug reports, feature requests, and patches. I see lots of interest in HandlerSocket and am tremendously optimistic …
- Merbist: Causality of scalability
- igvita.com: HandlerSocket: The NoSQL MySQL & Ruby
…Response Time Distribution (it depends on GCC platform specific functions) , HandlerSocket ( compilation issues on Solaris), Maatkit UDFs.
I want to say a special thanks to Joyent (a cloud computing provider) for Solaris resources and help with building binaries. Joyent provides templates for Percona Server and Percona XtraBackup by request.
- pingles: DTrace in Leopard with Ruby probes
- carpeaqua by Justin Williams: Indie+Relief: Thank You
- Rails on the Run - Home: News update
- New Relic: New Relic RPM for PHP is GA. The first on-demand performance management tool for PHP apps