In a previous post I had mentioned that I was doing a bit of digging into Docker in order to get a better grasp of the technology. Part of that was exploring common administrative tasks. I would venture to say…Read More >
In recent weeks I’ve been focusing on Docker in order to get a much better understanding of the containerized world that is materializing in front of us. Containers aren’t just for stateless applications anymore and we’re seeing more cases where…Read More >
Whenever we do upgrades for our clients from one major version of MySQL to another we strongly recommend to test in two forms. First, it would be a performance test between the old version and the new version to make…Read More >
One of the more common struggles I’ve had to assist with in regard to Amazon RDS is enabling binary logging on read replicas, or forming multi-tier replication in instances using version 5.6 or later after seeing that multi-tier replication is…Read More >
On April 4th 2012 Xtrabackup 2.0 was released in to GA by Percona along with a new streaming feature called xbstream. This new tool allowed for compression and parallelism of streaming backups when running xtrabackup or innobackupex without having to…Read More >
High availability for MySQL has become increasingly relevant given the ever increasing rate of adoption and implementation. It’s no secret to anyone in the community that the popularity of MySQL has become noteworthy. I still remember my start with MySQL…Read More >
Recently there have been several issues reported to me about DDL activity causing MySQL crash scenarios. In one case it stemmed from dropping multiple databases, one after the other in rapid succession. But in the case that I was recently…Read More >
In part 5 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at variables that relate to enforcing data consistency, and how index statistics are handled and stored.Read More >
In part 4 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at the mechanics that impact CPU resourcing and how InnoDB handles concurrent threads.Read More >
Peter Sylvester takes a look at the mechanics of how data gets written to table files as well as how background threads read from them.Read More >
© Copyright 2019 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.