All Blogs / Technology / Programming / Database Development / Popular
Percona Server for MySQL 5.5.31-30.3 now available
Percona is glad to announce the release of Percona Server for MySQL 5.5.31-30.3 on May 24, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the current stable release in the 5.5 series. Show More Summary
Stuff The Internet Says On Scalability For May 24, 2013
Hey, it's HighScalability time:
(Scaling the Mighty Redwood photograph by Michael Nichols for NatGEO)
~20K : Netflix AWS instances; 100 million hours per minute: Youtube video upload;
Quotable Quotes:
@sw17ch: Computer Science is thinking about thinking. Show More Summary
ZFS on Linux and MySQL
I am currently working with a large customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and ZFS and this provides a very low virtualization overhead. I learned quite a lot about these [...]Show More Summary
Non-Deterministic Query in Replication Stream
You might find a warning like the below in your error log: 130522 17:54:18 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what [...]
Paper: Calvin: Fast Distributed Transactions for Partitioned Database Systems
Distributed transactions are costly because they use agreement protocols. Calvin says, surprisingly, that using a deterministic database allows you to avoid the use of agreement protocols. The approach is to use a deterministic transaction...Show More Summary
Experiences with the McAfee MySQL Audit Plugin
I recently had to do some customer work involving the McAfee MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves a lot of data you don’t need too, and [...]Show More Summary
Percona XtraBackup 2.1.3 for MySQL available for download
Percona is glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes a high priority bug. It’s advised to upgrade your latest 2.1 version to 2.1.3 if you’re using the Percona XtraBackup with Percona XtraDB [...]Show More Summary
Hint of the day: Warning level in Error Log to see Aborted Connections
log_warnings = 2 Yields useful information in the MariaDB or MySQL error log file (or syslog on Debian/Ubuntu) you don’t want to miss out on. You will know about aborted connections, which are otherwise only visible through global status as Aborted_connects (lost connection before they completed authentication) and Aborted_clients (cut fully authenticated connection). It looks [...]
Percona MySQL University @Portland: June 17
Portland is a well-recognized hub for Open Source technologies in the Northwest, home to conferences such as OSCON and Open Source Bridge as well as hosts of OpenSQL Camp in 2009. As such it is a very natural place for our next Percona MySQL University event scheduled for June 17. We run this event in [...]Show More Summary
Strategy: Stop Using Linked-Lists
What data structure is more sacred than the link list? If we get rid of it what silly interview questions would we use instead? But not using linked-lists is exactly what Aater Suleman recommends in Should you ever use Linked-Lists?
In...Show More Summary
MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark. There was [...]Show More Summary
Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep in mind some limitations of the current implementation. This post is the [...]Show More Summary
The Tumblr Architecture Yahoo Bought for a Cool Billion Dollars
It's being reported Yahoo bought Tumblr for $1.1 billion. You may recall Instagram was profiled on HighScalability and they were also bought by Facebook for a ton of money. A coincidence? You be the judge.
Just what is Yahoo buying?Show More Summary
Webinar: SQL Query Patterns, Optimized
This Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several common types of queries with which developers struggle. I’ll test several SQL solutions for each type of query objective, and show how [...]Show More Summary
Percona XtraBackup 2.1.2 for MySQL available for download
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 17, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised to upgrade your latest 2.1 version to 2.1.2. This release is the [...]Show More Summary
Stuff The Internet Says On Scalability For May 17, 2013
Hey, it's HighScalability time:
(Earth sized solar flare, some more flair)
Google I/O to world: Just try to keep up with us. You can't. But go ahead and try. Nah na na na nah...
17 billion: Google Cloud Messaging messages per day with...Show More Summary
Virident vCache vs. FlashCache: Part 2
This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results. Disclosure: The research and testing conducted for this post were sponsored by Virident. First, some background information. All tests were conducted [...]Show More Summary
Paper: Warp: Multi-Key Transactions for Key-Value Stores
Looks like an interesting take on "a completely asynchronous, low-latency transaction management protocol, in line with the fully distributed NoSQL architecture."
Warp: Multi-Key Transactions for Key-Value Stores overview:
Implementing ACID transactions has been a longstanding challenge for NoSQL systems. Show More Summary
Virident vCache vs. FlashCache: Part 1
(This is part one of a two part series) Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular, Virident engaged Percona to do a usability and feature-set [...]Show More Summary
Lesson from Airbnb: Give Yourself Permission to Experiment with Non-scalable Changes
If you are stuck drowning in too much data and too many options and are dazzled by all the possibilities of code, here's a helpful bit of advice from Airbnb's rags to riches origin story: it's okay to do things that don’t scale.
A corollary...Show More Summary
