All Blogs / Technology / Programming / Database Development / New
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
Announcing Percona XtraBackup 2.1.1 GA
Percona is glad to announce the release of Percona XtraBackup 2.1.1 on May 15th 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered [...]Show More Summary
Sponsored Post: Dow Jones, Spotify, Evernote, Surge, Rackspace, Amazon, Booking, aiCache, Aerospike, Percona, ScaleOut, New Relic, LogicMonitor, AppDynamics, ManageEngine, Site24x7
Who's Hiring? Amazing things are happening at Dow Jones – help build the next generation News and Media platforms that serve the best journalism in the world. High-impact, passionate, and driven technologists thrive in our environment, building platforms that deliver trusted content that enlightens and inspires millions around the world. Show More Summary
Is Synchronous Replication right for your app?
I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution. But, what they tend not to think too much about is if moving from async to synchronous replication is right for their application or not. Facts about Galera replication [...]Show More Summary
How to pick indexes is the same for MongoDB as mySQL
I recently went to MongoDB Days, a conference about everything MongoDB in SF. Starting my career as a Systems Programmer then Web Developer, MySQL DB[Admin|Architect], to Software|System Architecture I like to keep an open mind about new technology and trends. Show More Summary
The Secret to 10 Million Concurrent Connections -The Kernel is the Problem, Not the Solution
Now that we have the C10K concurrent connection problem licked, how do we level up and support 10 million concurrent connections? Impossible you say. Nope, systems right now are delivering 10 million concurrent connections using techniques...Show More Summary
Webinar: MySQL 5.6 Performance Schema
This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing [...]Show More Summary
LEVENSHTEIN MySQL stored function
At Open Query we steer clear of code development for clients. We sometimes advise on code, but as a company we don’t want to be in the programmer role. Naturally we do write scripts and other necessities to do our job. Assisting with an Open Source project, I encountered three old UDFs. User Defined Functions [...]
Stuff The Internet Says On Scalability For May 10, 2013
Hey, it's HighScalability time:
(In Thailand, they figured out how to solve the age-old queuing problem!)
Nanoscale: Plants IM Using Nanoscale Sound Waves; 100 petabytes: CERN data storage
Quotable Quotes:
Geoff Arnold: Arguably allShow More Summary
Open Source, the MySQL market (and TokuDB in particular)
I was reviewing the Percona Live sponsors list the other day and pondering the potential success stories associated with this product or that one…. and as I was preparing to put more thought on the topic, a PlanetMySQL post caught my eye. It was penned by Mike Hogan and titled, “Thoughts on Xeround and Free!” [...]Show More Summary
InnoDB without PRIMARY KEY
Having an InnoDB table without a PRIMARY KEY is not good. Many have known this for years, but exact opinions as to why have differed. From observation, it was clear to me that it impacted performance. InnoDB stores its row data in the leaf nodes of the primary key B+tree structure, that means that it [...]
How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
Percona XtraBackup 2.0.7 has been published with support for GTID based replication. As promised, here is the step-by-step guide on how to create a new GTID based slave (or repair a broken one) using XtraBackup. The process is pretty straightforward. 1- Take a backup from any server on the replication environment, master or slave: [crayon-518b7c044bf0b/] [...]Show More Summary
