All Blogs / Technology / Programming / Database Development / Popular


Business Continuity and MySQL Backups

This blog post discusses the business continuity plan around MySQL backups, and how organizations should think about them. During the years I’ve worked in IT, I’ve learned that backups sometimes are a conceptual subject in organizations. Many companies have them, but don’t document the associated business continuation plan for them. I experienced this the hard way many […]

Make MySQL 8.0 Better Through Better Benchmarking

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Stuff The Internet Says On Scalability For December 2nd, 2016

Hey, it's HighScalability time: A phrase you've probably heard a lot this week: AWS announces... If you like this sort of Stuff then please support me on Patreon. 18 minutes: latency to Mars; 100TB: biggest dynamodb table; 55M: visits...Show More Summary

Managing Replication with Percona XtraDB Cluster

This blog post discusses managing replication with Percona XtraDB Cluster. Recently a customer asked me to setup replication between two distinct Percona XtraDB Clusters located in geographically separate data centers. The customer goal was to use one of the clusters only in case of disaster recovery. They tried extending the cluster, but because of the […]

Database Daily Ops Series: GTID Replication and Binary Logs Purge

This blog continues the ongoing series on daily operations and GTID replication. In this blog, I’m going to investigate why the error below has been appearing in a special environment I’ve been working with on the last few days: [crayon-584066ac6ab60316797384/] The error provides the right message, and explains what is going on. But sometimes, it can be a […]

Galera Cache (gcache) is finally recoverable on restart

This post describes how to recover Galera Cache (or gcache) on restart. Recently Codership introduced (with Galera 3.19) a very important and long awaited feature. Now users can recover Galera cache on restart. Need If you gracefully shutdown cluster nodes one after another, with some lag time between nodes, then the last node to shutdown holds […]

Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7

In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7 Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default behavior. Without any special effort, MySQL saves and […]

Percona XtraBackup 2.4.5 is now available

Percona announces the GA release of Percona XtraBackup 2.4.5 on November 29th, 2016. You can download it from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL 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 […]

How to Make Your Database 200x Faster Without Having to Pay More?

This is a guest repost Barzan Mozafari, an assistant professor at University of Michigan and an advisor to a new startup, snappydata.io, that recently launched an open source OLTP + OLAP Database built on Spark. Almost everyone these days is complaining about performance in one way or another. Show More Summary

Percona Server for MongoDB 3.0.14-1.9 is now available

Percona announces the release of Percona Server for MongoDB 3.0.14-1.9 on November 28, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.0.14-1.9 is an enhanced,...Show More Summary

Percona Server 5.7.16-10 is now available

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

Stuff The Internet Says On Scalability For November 25th, 2016

Hey, it's HighScalability time: Margaret Hamilton was honored with the Presidential Medal of Freedom for writing Apollo guidance software. Oddly, she's absent from best programmers of all time lists. If you like this sort of Stuff then...Show More Summary

Percona Server for MySQL 5.5.53-38.5 is now available

Percona announces the release of Percona Server for MySQL 5.5.53-38.4 on November 18, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server for MySQL 5.5.53-38.5 is now the current stable release in the 5.5 series. Percona Server for MySQL is open-source and free. You can find release details in the 5.5.53-38.5 […]

INNODB Tablespace Copy in Go Lang

I just uploaded a quick tool that I think you will find useful if you need to consolidate, expand innodb databases if tablespaces are in use. This golang application will copy an entire innodb database from one server to another server via scp.innodb-tablespace-copy follows the algorithm described here. Show More Summary

Webinar Q/A: MySQL High Availability with Percona XtraDB Cluster 5.7

In this blog I will provide answers to the questions and queries that some of you have raised during the webinar on Nov 17th. I would like to say thank you to all of the audience who attended the talk on November 17, 2016. You can also check the recording and slides here. Q. How is […]

IT Hare: Ultimate DB Heresy: Single Modifying DB Connection. Part I. Performanc

Sergey Ignatchenko continues his excellent book series with a new chapter on databases. This is a guest repost. The idea of single-write-connection is used extensively in the post, as it's defined elsewhere I asked Sergey for a definition...Show More Summary

Percona Server 5.5.53-38.4 is now available

Percona announces the release of Percona Server 5.5.53-38.4 on November 18, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server 5.5.53-38.4 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can find release details in the 5.5.53-38.4 milestone on Launchpad. Downloads are available […]

WiredTiger B-Tree versus WiredTiger In-Memory: Q & A

In this blog, I will provide answers to the Q & A for the WiredTiger B-Tree versus WiredTiger In-Memory webinar. First, I want to thank everybody for attending the October, 13 webinar. The recording and slides for the webinar are available here. Below is the list of questions that I wasn’t able to fully answer […]

Stuff The Internet Says On Scalability For November 18th, 2016

Hey, it's HighScalability time: Now you don't have to shrink yourself to see inside a computer. Here's a fully functional 16-bit computer that's over 26 square feet huge! Bighex machine. If you like this sort of Stuff then please support...Show More Summary

Help Us Shape the Future of Percona

Let us know what you think about Percona, and what we should be thinking about for the future. Over the last ten years, Percona has grown considerably. We’ve moved from being a strictly MySQL company, to a company that supports MongoDB and other open source databases. Percona Live and Percona Live Europe have become key […]

Copyright © 2015 Regator, LLC