All Blogs / Technology / Programming / Database Development / New


Percona Live Europe featured talk with Alexander Krasheninnikov — Processing 11 billion events a day with Spark in Badoo

Welcome to a new Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live […]

Stuff The Internet Says On Scalability For August 26th, 2016

Hey, it's HighScalability time: The Pixar render farm in 1995 is half of an iPhone (@BenedictEvans) If you like this sort of Stuff then please support me on Patreon. 33.0%: of all retail goods sold online in the US are sold on Amazon;...Show More Summary

Percona Live Europe featured talk with Krzysztof Ksi??ek — MySQL Load Balancers – MaxScale, ProxySQL, HAProxy, MySQL Router & nginx

Welcome to the first Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live […]

PostgreSQL Day at Percona Live Amsterdam 2016

Introducing PostgreSQL Day at Percona Live Europe, Amsterdam 2016. As modern open source database deployments change, often including more than just a single open source database, Percona Live has also changed. We changed our model from being a purely MySQL-focused conference (with variants) to include a significant amount of MongoDB content. We’ve also expanded our […]

The Always On Architecture - Moving Beyond Legacy Disaster Recovery

Failover does not cut it anymore. You need an ALWAYS ON architecture with multiple data centers. -- Martin Van Ryswyk, VP of Engineering at DataStax Failover, switching to a redundant or standby system when a component fails, has a long and checkered history as a way of dealing with failure. Show More Summary

How to stop offending queries with ProxySQL

This blog discusses how to find and address badly written queries using ProxySQL. All of us are very good in writing good queries. We know this to always be true! ???? But sometimes a bad query escapes our control and hits our database. There is the new guy, the probie, who just joined the company […]

Percona Server 5.7.14-7 is now available

Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current GA release in the Percona Server 5.7 series. Percona’s provides completely open-source and free […]

Percona Server 5.6.32-78.0 is now available

Percona announces the release of Percona Server 5.6.32-78.0 on August 22nd, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.32, including all the bug fixes in it, Percona Server 5.6.32-78.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this […]

Query rewrite plugin: scalability fix in MySQL 5.7.14

In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance. Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which includes fixes for this issue. I reran tests for MySQL 5.7.13 and 5.7.14 using the […]

Found data leak of a company while giving a college lecture | Sijmen Ruwhof

Sijmen writes: A few weeks ago I gave a guest lecture at the Windesheim University of Applied Sciences in The Netherlands. I graduated there and over the years I kept in contact with some of my teachers since then. One of the teachers told me recently that a lot of students wanted to learn more […]

Choosing Whether to Migrate to Another Database: Uber

Uber Engineering explains the technical reasoning behind its switch in database technologies, from Postgres to MySQL: https://eng.uber.com/mysql-migration/ These things are always an interesting read, because it looks at one company’s decision making process and operational steps. Show More Summary

The Australian Online Census 2016 Example of How-Not-To

One of the key problems with the 2016 online census was the architecture, but also the how the whole thing was organised and who was contracted for the job. IBM, for the $9.6mln it got paid for the job, built something very clunky. They used Java, which is not bad per-se but the system also […]

Top Most Overlooked MySQL Performance Optimizations: Q & A

Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations“. In this blog, I will provide answers to the Q & A for that webinar. For hardware, which disk raid level do you suggest? Is raid5 suggested performance-wise and data-integrity-wise? RAID 5 comes with high overhead, as each write […]

Stuff The Internet Says On Scalability For August 19th, 2016

Hey, it's HighScalability time: Modern art? Nope. Pancreatic cancer revealed by fluorescent labeling. If you like this sort of Stuff then please support me on Patreon. 4: SpaceX rocket landings at sea; 32TB: 3D Vertical NAND Flash; 10x:...Show More Summary

Percona Server 5.5.51-38.1 is now available

Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can find release details of the release in the 5.5.51-38.1 milestone on Launchpad. […]

ProxySQL 1.2.1 GA Release

The GA release of ProxySQL 1.2.1 is available. You can get it from https://github.com/sysown/proxysql/releases. There are also Docker images for Release 1.2.1: https://hub.docker.com/r/percona/proxysql/. This post is published with René...Show More Summary

Improve TokuDB/PerconaFT fragmented data file performance

In this blog post, we’ll discuss how to improve TokuDB and PerconaFT fragmented data file performance. Through our internal benchmarking and some user reports, we have found that with long term heavy write use TokuDB/PerconaFT performance can degrade significantly on large data files. Using smaller node sizes makes the problem (which is one of our […]

How Apache Spark makes your slow MySQL queries 10x faster (or more)

In this blog post, we’ll discuss how to improve the performance of slow MySQL queries using Apache Spark. Introduction In my previous blog post, I wrote about using Apache Spark with MySQL for data analysis and showed how to transform and analyze a large volume of data (text files) with Apache Spark. Vadim also performed a […]

Webinar Thursday 8/18: Preventing and Resolving MySQL Downtime

Join Percona’s Jervin Real for a webinar on Thursday August 18, 2016 at 10 am PDT (UTC-7) on Preventing and Resolving MySQL Downtime. Preventing MySQL downtime and emergencies is difficult. Often complex combinations of several things going wrong cause these emergencies. Show More Summary

Sponsored Post: Zohocorp, Exoscale, Host Color, Cassandra Summit, Scalyr, Gusto, LaunchDarkly, Aerospike, VividCortex, MemSQL, AiScaler, InMemory.Net

Who's Hiring? IT Security Engineering. At Gusto we are on a mission to create a world where work empowers a better life. As Gusto's IT Security Engineer you'll shape the future of IT security and compliance. We're looking for a strong IT technical lead to manage security audits and write and implement controls. Show More Summary

Copyright © 2015 Regator, LLC