Discover a new way to find and share stories you'll love… Learn about Reading Desk

All Blogs / Technology / Programming / Database Development / New


Stuff The Internet Says On Scalability For February 27th, 2015

Hey, it's HighScalability time: Hear ye puny mortal. 1.3 million Earths doth fill our Sun. Whence comes this monster black hole with a mass 12 billion times that of the Sun? 1 Terabit of Data per Second: 5G; 1.9 Terabytes: customer in...Show More Summary

3 handy tools to remove problematic MySQL processes

DBAs often encounter situations where they need to kill queries to ensure there are no long-running queries on a MySQL server that would impact performance. Long-running queries can be the result of many factors. Fortunately, Percona Server contains some handy tools to remove problematic MySQL processes. Show More Summary

Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?

If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them: [crayon-54efdea25e01e546724629/] Worry not as this is mostly harmless. Show More Summary

Using MySQL Event Scheduler and how to prevent contention

MySQL introduced the Event Scheduler in version 5.1.6. The Event Scheduler is a MySQL-level “cron job”, which will run events inside MySQL. Up until now, this was not a very popular feature, however, it has gotten more popular sinceShow More Summary

Is MySQL’s innodb_file_per_table slowing you down?

MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own.ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Show More Summary

MySQL community t-shirt contest for Percona Live 2015

Have designs on Percona Live this April in Silicon Valley? Send them to us! The winning entry will appear on a cool limited edition t-shirt that we’ll award to a few dozen lucky recipients at our booth’s new Percona T-Shirt Bar. TheShow More Summary

Deep Learning without Deep Pockets

Now that you’ve transformed your system through successive evolutions of architecture goodness...you've made it cloud native, you now treat a fist full of datacenters as a single computer, you’ve microservicized it, you’ve containerized...Show More Summary

HappyPancake: a Retrospective on Building a Simple and Scalable Foundation

This is a guest repost by Rinat Abdullin, who worked on HappyPancake, the largest free dating site in Sweden. Initially written in ASP.NET and MS SQL Database server, it eventually became overly complex and expensive to scale. This is the last post in a nearly two year long series of engaging articles on the evolution of the project. Show More Summary

Stuff The Internet Says On Scalability For February 20th, 2015

Hey, it's HighScalability time: Networks are everywhere, they can even help reveal disease connections. rillions: number of photons constantly hitting your eyes; $19 billion: Snapchat valuation; 8.5K: average number of questions asked...Show More Summary

How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)

This past week was marked by a series of personal findings related to the use of Global Transaction IDs (GTIDs) on Galera-based clusters such as Percona XtraDB Cluster (PXC). The main one being the fact that transactions touching MyISAM...Show More Summary

More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar)

In a previous post, titled “Multi-threaded replication with MySQL 5.6: Use GTIDs,” I explained that using GTID replication is almost a requirement when using MySQL 5.6 MTS. Let’s see now how to perform the day-to-day operations when MTS and GTIDs are both enabled. Show More Summary

Free Book: Is Parallel Programming Hard, And, If So, What Can You Do About It?

“The trouble ain’t that people are ignorant: it’s that they know so much that ain’t so." -- Josh Billings Is Parallel Programming Hard? Yes. What Can You Do About It? To answer that, Paul McKenney, Distinguished Engineer at IBM Linux...Show More Summary

Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23)

Percona has submitted seven talks for the next OpenStack Summit in Vancouver this May. And as with all OpenStack Summit events, the community decides the content. Voting ends February 23, and if you aren’t already an OpenStack Foundation member (required to vote), you can join now for free here. Show More Summary

Percona XtraBackup 2.2.9 is now available

Percona is glad to announce the release of Percona XtraBackup 2.2.9 on February 17, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user...Show More Summary

Sponsored Post: Apple, Sentient, Couchbase, Farmerswife, VividCortex, Internap, SocialRadar, Campanja, Transversal, MemSQL, Scalyr, FoundationDB, AiScaler, Aerospike, AppDynamics, ManageEngine, Site24x7

Who's Hiring?x Apple is hiring a Application Security Engineer. Apple’s Gift Card Engineering group is looking for a software engineer passionate about application security for web applications and REST services. Be part of a team working...Show More Summary

‘Indexing’ JSON documents for efficient MySQL queries over JSON data

MySQL meets NoSQL with JSON UDF I recently got back from FOSDEM, in Brussels, Belgium. While I was there I got to see a great talk by Sveta Smirnova, about her MySQL 5.7 Labs release JSON UDF functions. It is important to note that while...Show More Summary

Scaling Kim Kardashian to 100 Million Page Views

The team at PAPER estimated their article (NSFW) containing pictures of a very naked Kim Kardashian would quickly receive over 100 million page views. The very definition of bursty viral driven traffic. As a comparison in 2013 it was estimated Google processed over 500 million searches a day. Show More Summary

Open source ‘wasn’t available’ two years ago, says Universal Credit chief | ComputerWorld UK

http://www.computerworlduk.com/news/public-sector/3493090/open-source-wasnt-available-two-years-ago-says-universal-credit-chief/ A bit of light entertainment (Dilbert style) on a big public project. Do read the whole article, it’s worthwhile…...Show More Summary

Stuff The Internet Says On Scalability For February 13th, 2015

Hey, it's HighScalability time: Stunning depiction of every space mission over the past 50 years. (Max Roser) 700 billion: Apple's valuation; 1: Number of lines of code it takes to bring down UK air traffic control; 20: how old thatShow More Summary

Percona XtraDB Cluster 5.6: a tale of 2 GTIDs

Say you have a cluster with 3 nodes using Percona XtraDB Cluster (PXC) 5.6 and one asynchronous replica connected to node1. If asynchronous replication is using GTIDs, moving the replica so that it is connected to node2 is trivial, right? Actually replication can easily break for reasons that may not be obvious at first sight. Show More Summary

Copyright © 2011 Regator, LLC