The “swap insanity” problem, in brief When running MySQL on a large system (e.g., 64GB RAM and dual quad core CPUs) with a large InnoDB buffer pool (e.g., 48GB), over time, Linux decides to swap out potentially large amounts of memory, desp... 続きを読む
Facebook has one of the largest MySQL installations in the world, with thousands of database servers in multiple regions, so it's no surprise that we have unique challenges when we take backups. Our job is to keep every piece of information y... 続きを読む
README.md Kodama Kodama is a MySQL replication listener based on ruby-binlog. Kodama provides a simple DSL to easily write your own replication listener. Features Provides simple DSL for writing binlog event handlers Automatically restarts fr... 続きを読む
Mozilla IT Mozilla IT & Operations MySQL and the Leap Second, High CPU and the Fix Jun 30 2012 3 So, MySQL seemed to be faring just fine during and after the leap second. There were no big problems or catastrophic failures. However, we notice... 続きを読む
Jeremy Cole, a DBA Team Lead/Database Architect at Twitter, gave a really good talk at the O'Reilly MySQL conference: Big and Small Data at @Twitter, where the topic was thinking of Twitter from the data perspective. One of the interesting st... 続きを読む
WL#3283: C/C++ API to binary log Affects: Server-Prototype Only — Status: In-Progress — Priority: Medium DESCRIPTION =========== The motivation for this is to support software that mine the binary log by developing and deploying a programma... 続きを読む
The ability to replicate from one MySQL server to another is a well established and proven technology. Until recently, replication from a MySQL server to an external application was not supported. This technology would not only enable a unive... 続きを読む
Reading should be social! Post a message on your social networks to let others know what you're reading. Select the sites below and start sharing. 続きを読む
Harrison discusses how Facebook uses MySQL now, what challenges face the world’s largest MySQL user, how they’ve solved many of them, and what remains. Facebook’s MySQL deployment is notable not only for its size, but also for how openly F... 続きを読む
The “swap insanity” problem, in brief When running MySQL on a large system (e.g., 64GB RAM and dual quad core CPUs) with a large InnoDB buffer pool (e.g., 48GB), over time, Linux decides to swap out potentially large amounts of memory, desp... 続きを読む
Saturday, May 14, 2011 Introducing MySQL to MongoDB Replication The last article on this blog described our planned MySQL to MongoDB replication hackathon at the recent Open DB Camp in Sardinia. Well, it worked, and the code is now checked i... 続きを読む
Calpont’s InfiniDB is now available!...Contributed by Calpont, InfiniDB Community Edition provides a scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQLT... 続きを読む
Wednesday, October 20, 2010 Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server Most of high scale web applications use MySQL + memcached. Many of them use also NoSQL like TokyoCabinet/Tyrant. In some cases people... 続きを読む
It is great to be able to build small utilities on top of an excellent RDBMS. Thank you MySQL. This is a small but complex utility to perform online schema change for MySQL. We call it OSC and the source is here. Some ALTER TABLE statements ... 続きを読む
Saturday, September 11, 2010 MySQL versus MongoDB - yet another silly benchmark This is yet another silly benchmark because the results are likely to be misused. The results probably do not matter to you. I like MongoDB. It has many things in... 続きを読む
I wrote about FlashCache there, and since that I run couple benchmarks, to see what performance benefits we can expect. For initial tries I took sysbench oltp tests ( read-only and read-write) and case when data fully fits into L2 cache. I ma... 続きを読む
Essential command-line utilities for MySQL (formerly MySQL Toolkit)What is Maatkit? Maatkit makes MySQL easier and safer to manage. It provides simple, predictable ways to do things you cannot otherwise do. It would be nice if these features ... 続きを読む
EC2上では、仮想IPアドレスなどのIPレベルの機能が制限されているため、仮想IPアドレスを使用した冗長化は基本的には使用できません。が、DNSを使用することで、VIPほどの精度は高くないもののMySQL Multi-master構成を構築することができました。今回は、MySQL... 続きを読む
2009年9月12日 新書籍「Linux-DBシステム構築/運用入門」 Linux上で「高速で、落ちない」DBサーバーを構築するための技術解説をした書籍を出版します。タイトルはストレートに「Linux-DBシステム構築/運用入門」です。 9月17日発売ですが、ジュンク堂など一部... 続きを読む
Fast, Reliable, Proven transactional storage for MySQL The InnoDB team gratefully acknowledges the contributions of leading MySQL community members. These contributions have in some cases significantly improved the performance of the InnoDB P... 続きを読む