2014–2017
1,491 posts
2017 428
December 2017
- Percona Database Performance Blog Year in Review: Top Blog Posts
- This Week in Data with Colin Charles 21: Looking Back on 2017 in the Open Source Database Community
- Monitoring Amazon Aurora with PMM
- The hidepid Options for /proc and Percona XtraDB Cluster Don’t Play Well Together
- MongoDB 3.6 Aggregation and Array Improvements
- MongoDB 3.6 Sorting Changes and Useful New Features
- This Week in Data with Colin Charles 20: cPanel changes strategy, Percona Live CFP extended
- Three P’s of a Successful Black Friday: Percona, Pepper Media Holding, and PMM
- Percona Live 2018 Call for Papers Deadline Extended to January 12, 2018
- Updates to Percona Bug Tracking
- Webinar Q&A: Percona XtraDB Cluster 101
- Percona Monitoring and Management a Trend Setting Product for 2018
- Webinar Wednesday, December 20, 2017: InnoDB Performance Optimization
- Percona Monitoring and Management 1.5.3 Is Now Available
- MongoDB 3.6 Security Improvements
- This Week in Data with Colin Charles 19: Percona Live Tickets, Call for Papers and FOSDEM
- Percona Server for MySQL 5.7.20-18 Is Now Available
- What Are Your Cloud Database Plans? Help Inform the Community, Take Percona’s Survey
- Demystifying Sequence Numbers (seqno) in Percona XtraDB Cluster
- Exciting Pre-Cursors to MongoDB 3.6 Transactions
- Webinar Friday, December 15, 2017: Capacity Planning for Your Data Stores
- Get Your Percona Live 2018 Tickets at the Super Saver Rate Now (Before Time Runs Out)!
- Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate
- Webinar: Best Practices for Right-Sizing Your Aurora Footprint
- Webinar Wednesday, December 13, 2017: Open Source Database Software Year in Review
- Percona Server for MongoDB 3.2.18-3.9 Is Now Available
- Percona Server for MySQL 5.6.38-83.0 is Now Available
- This Week in Data with Colin Charles 18: Percona Live Call For Papers and a MongoDB 3.6 Overview
- MongoDB 3.6 Sessions Explained
- Hands-On Look at ZFS with MySQL
- Percona Server for MySQL 5.5.58-38.10 is Now Available
- MongoDB 3.6 Community Is Here!
- Webinar Thursday, December 7, 2017: Percona XtraDB Cluster (PXC) 101
- Percona Monitoring and Management 1.5.2 Is Now Available
- MySQL 8.0 Window Functions: A Quick Taste
- Webinar Wednesday, December 6, 2017: Gain a MongoDB Advantage with the Percona Memory Engine
- Internal Temporary Tables in MySQL 5.7
- Percona Monitoring and Management 1.5: QAN in Grafana Interface
- This Week in Data with Colin Charles 17: AWS Re:Invent, a New Book on MySQL Cluster and Another Call Out for Percona Live 2018
November 2017
- Percona Server for MongoDB 3.4.10-2.10 Is Now Available
- Percona Monitoring and Management 1.5.1 Is Now Available
- Percona XtraBackup 2.3.10 Is Now Available
- Percona XtraBackup 2.4.9 Is Now Available
- Best Practices for Percona XtraDB Cluster on AWS
- Percona Monitoring and Management 1.5.0 Is Now Available
- autoxtrabackup v1.5.0: A Tool for Automatic Backups
- This Week in Data with Colin Charles 16: FOSDEM, Percona Live call for papers, and ARM
- MongoDB 3.6 Change Streams: A Nest Temperature and Fan Control Use Case
- Sudoku Recursive Common Table Expression Solver
- Percona Toolkit 3.0.5 is Now Available
- InnoDB Page Compression: the Good, the Bad and the Ugly
- This Week in Data with Colin Charles 15: Percona Live 2018 Call for Papers and Best Practices for Observability
- Understanding how an IST donor is selected
- ZFS from a MySQL perspective
- Webinars on Wednesday November 15, 2017: Proxy Wars and Percona Software Update for Q4
- Common MongoDB Topologies
- Percona Live Open Source Database Conference 2018 Call for Papers Is Now Open!
- This Week in Data with Colin Charles 14: A Meetup in Korea and The Magic Quadrant
- MySQL and Linux Context Switches
- Using Prometheus to Check for auto_increment Value Exhaustion
- Upcoming MongoDB Security Webinar November 8, 2017: Enhanced Security Using LDAP Authentication
- MongoDB Security: Using LDAP Authentication
- This Week in Data with Colin Charles 13: MariaDB, M18 and YugaByte
- Percona Monitoring and Management 1.4.1 Is Now Available
- Percona Server for MongoDB 3.2.17-3.8 Is Now Available
October 2017
- MySQL Dashboard Improvements in Percona Monitoring and Management 1.4.0
- Percona XtraDB Cluster 5.7.19-29.22-3 is now available
- Percona XtraDB Cluster 5.6.37-26.21-3 is Now Available
- This Week in Data with Colin Charles 12: Open Source Summit Europe and Open Source Entrepreneur Network
- Percona Server for MongoDB 3.4.9-2.9 is Now Available
- JSON Output of the pmm-admin list Command
- Community Matters
- Upcoming Joint Webinar Tuesday October 24, 2017: How to automate and manage MongoDB & Percona Server for MongoDB
- MySQL Point in Time Recovery the Right Way
- Percona Monitoring and Management 1.4.0 Is Now Available
- This Week in Data with Colin Charles 11: Velocity EU London and Open Source Summit Europe
- Percona Blog Poll: How Do You Currently Host Applications and Databases?
- How to Choose the MySQL innodb_log_file_size
- Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2
- Webinar Wednesday, October 18, 2017: How to Scale with MongoDB
- This Week in Data with Colin Charles 10: MariaDB and Upcoming Appearances
- A Mystery with MySQL open_files_limit
- Percona Monitoring and Management 1.3.2 Is Now Available
- Webinar Thursday, October 12, 2017: MongoDB Readiness from an SRE and Ops Viewpoint
- Webinar Wednesday, October 11, 2017: Percona Monitoring and Management (PMM) Demonstration
- This Week in Data with Colin Charles 9: Oracle OpenWorld and Percona Live Europe Post Mortem
- Graph Descriptions for Metrics Monitor in Percona Monitoring and Management 1.3.0
- Percona Live Europe Social
- ClickHouse MySQL Silicon Valley Meetup Wednesday, October 25 at Uber Engineering with Percona’s CTO Vadim Tkachenko
- MyRocks Metrics Now in PMM 1.3.0
- Webinar October 4, 2017: Databases in the Hosted Cloud
- Big Dataset: All Reddit Comments – Analyzing with ClickHouse
- One Million Tables in MySQL 8.0
September 2017
- This Week in Data with Colin Charles 8: Percona Live Europe 2017 Is a Wrap!
- Percona Live Europe Session Interview: High-Performance JSON – PostgreSQL Vs. MongoDB with Wei Shan Ang and Dominic Dwyer (GlobalSign)
- Percona Monitoring and Management 1.3.1 Is Now Available
- MySQL on Docker – Containerizing the Dolphin
- Percona Monitoring and Management 1.3.0 Query Analytics Support for MongoDB
- Percona Live Europe Session Interview: Building Multi-Petabyte Data Warehouses with ClickHouse
- Percona Live Europe Session Interviews with Yandex ClickHouse: A DBMS for Interactive Analytics at Scale and Quick Tour of ClickHouse Internals
- Percona Server for MongoDB 3.2.16-3.7 Is Now Available
- Percona Live Europe Session Interview: Spatial Data in MySQL 8.0 with Norvald Ryeng (Oracle)
- Percona Live Europe 2017 Keynotes Day 2
- Pepper Turns to Percona to Ensure a Great Customer Experience at Pepper.com
- Percona Live Europe 2017 Keynotes Day One
- Percona Monitoring and Management 1.3.0 Is Now Available
- Avoid Shared Locks from Subqueries When Possible
- Percona Live Europe: Tutorials Day
- Percona XtraDB Cluster 5.7.19-29.22 is now available
- How to Deal with XA Transactions Recovery
- This Week in Data with Colin Charles #7: Percona Live Europe and Open Source Summit North America
- Percona Support with Amazon RDS
- Percona Live Europe Featured Talks: Modern sysbench – Teaching an Old Dog New Tricks with Alexey Kopytov
- sysbench Histograms: A Helpful Feature Often Overlooked
- Percona XtraDB Cluster 5.6.37-26.21 is Now Available
- Automatic Database Management System Tuning Through Large-Scale Machine Learning
- ProxySQL Improves MySQL SSL Connections
- Webinar Tuesday, September 19, 2017: A Percona Support Engineer Walkthrough for pt-stalk
- Percona Live Europe Featured Talks: Debugging with Logs (and Other Events) Featuring Charity Majors
- Percona Blog Poll Results: What Database Engine Are You Using to Store Time Series Data?
- The MySQL High Availability Landscape in 2017 (the Babies)
- This Week in Data with Colin Charles #6: Open Source Summit and Percona Live Europe
- Lock, Stock and MySQL Backups: Data Guaranteed Webinar Follow Up Questions
- Percona Live Europe Featured Talks: Monitoring Open Source Databases with Icinga with Bernd Erk
- Percona Server for MongoDB 3.4.7-1.8 is Now Available
- Percona Live Europe Featured Talks: Visualize Your Data with Grafana Featuring Daniel Lee
- Massive Parallel Log Processing with ClickHouse
- cscope: Searching Code Efficiently
- Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse
- How to Update InnoDB Table Statistics Manually
- Upcoming Webinar Tuesday September 12: Differences between MariaDB® and MySQL®
- Percona Live Europe Featured Talks: MongoDB – Sharded Cluster Tutorial with Jason Terpko and Antonios Giannopoulos
- This Week in Data with Colin Charles #5: db tech showcase and Percona Live Europe
- Always Verify Examples When Comparing DB Products (PostgreSQL and MySQL)
- Percona Live Europe Featured Talks: NoSQL Best Practices for PostgreSQL with Dmitry Dolgov
- Upcoming Webinar Thursday, September 7: Using PMM to Troubleshoot MySQL Performance Issues
- MyRocks Experimental Now Available with Percona Server for MySQL 5.7.19-17
- Revenge of Ransomware! MongoDB Security in the News Again . . .
- Webinar: Percona Roadmap and Software News Update – Q3 2017
- How Life360 Used ProxySQL to Lower Its Database Load
- This Week in Data with Colin Charles #4: Percona Server for MySQL with MyRocks
August 2017
- Percona Live Europe Featured Talks: Orchestrating ProxySQL with Orchestrator and Consul with Avraham Apelbaum
- Percona Server for MySQL 5.7.19-17 Is Now Available
- Nested Data Structures in ClickHouse
- Percona Live Europe Featured Talks: Migrating To and Living on RDS/Aurora with Balazs Pocze
- Looking at Disk Utilization and Saturation
- This Week in Data with Colin Charles #3: More Percona Live Europe!
- Percona Server for MySQL 5.6.37-82.2 Is Now Available
- Percona Live Europe Featured Talks: A Quick Tour of MySQL 8.0 Roles with Giuseppe Maxia
- Percona Server for MySQL 5.5.57-38.9 Is Now Available
- Percona Monitoring and Management 1.2.2 is Now Available
- Migrating Data from an Encrypted Amazon MySQL RDS Instance to an Encrypted Amazon Aurora Instance
- The MySQL High Availability Landscape in 2017 (The Adults)
- Percona Server for MongoDB 3.2.16-3.6 is Now Available
- This Week in Data with Colin Charles: Percona Live Europe!
- IMDb Data in a Graph Database
- Percona Monitoring and Management 1.2.1 is Now Available
- Upcoming Webinar Thursday, August 17: Efficient CRUD Queries in MongoDB
- Upcoming Webinar Wednesday August 16: Lock, Stock and Backup – Data Guaranteed
- Learning MySQL 5.7: Q & A
- This Week in Data: Thoughts from Percona Chief Evangelist Colin Charles
- How to Configure Aurora Parameters on Amazon RDS
- Avoiding the "An optimized (without redo logging) DDL operation has been performed" Error with Percona XtraBackup
- Webinar Wednesday August 9, 2017: MongoDB Security – Making Things Secure by Default
- Saturation Metrics in PMM 1.2.0
- Percona Live Europe 2017 Sneak Peek Schedule Up Now! See Available Sessions!
- Percona Toolkit 3.0.4 is Now Available
- Percona Server for MongoDB 3.4.6-1.7 is Now Available
- Percona Server for MySQL 5.6.36-82.1 is Now Available
- Group Replication: The Sweet and the Sour
- Platform End of Life (EOL) Announcement for RHEL 5 and Ubuntu 12.04 LTS
July 2017
- Webinar Wednesday August 2, 2017: MySQL Disk Encryption with LUKS
- Percona Server for MySQL 5.7.18-16 Is Now Available
- Percona Server for MongoDB 3.4.6-1.6 is Now Available
- Percona Server for MongoDB 3.2.15-3.5 is Now Available
- What is innodb_autoinc_lock_mode?
- Webinar Thursday July 27, 2017: Database Backup and Recovery Best Practices (with a Focus on MySQL)
- Percona XtraBackup 2.4.8 is Now Available
- Percona XtraBackup 2.3.9 is Now Available
- Faster Node Rejoins with Improved IST performance
- Where Do I Put ProxySQL?
- Blog Poll: What Operating System Do You Run Your Development Database On?
- Multi-Threaded Slave Statistics
- Backups and Disaster Recovery
- Upcoming Webinar Wednesday, July 19, 2017: Learning MySQL 5.7
- Percona Live Europe 2017 Call for Papers Deadline Extended to July 24, 2017
- Percona Server for MongoDB 3.2.14-3.4 is Now Available
- Percona Monitoring and Management 1.2.0 is Now Available
- A Little Trick Upgrading to MySQL 5.7
- Setting Up Percona PAM with Active Directory for External Authentication
- Gh-ost benchmark against pt-online-schema-change performance
- Thread_Statistics and High Memory Usage
- Webinar Wednesday July 12, 2017: MongoDB Index Types – How, When and Where Should They Be Used?
- Percona Server for MongoDB 3.4.5-1.5 is Now Available
- Webinar Tuesday July 11, 2017: Securing Your MySQL/MariaDB Data
- MongoDB Indexing Types: How, When and Where Should They Be Used?
- Last Resort: How to Use a Backup to Start a Secondary Instance for MongoDB
- ClickHouse: One Year!
- Differences in PREPARE Statement Error Handling with Binary and Text Protocol (Percona XtraDB Cluster / Galera)
- Webinar Thursday July 6, 2017: Security and Encryption in the MySQL World
- Webinar Wednesday July 5, 2017: Indexes – What You Need to Know to Get the Most Out of Them
June 2017
- Industry Recognition of Percona: Great Products, Great Team
- How Does Percona Software Compare: the Value of Percona Software and Services
- MySQL Encryption at Rest – Part 2 (InnoDB)
- SSL Connections in MySQL 5.7
- Webinar Thursday June 29, 2017: Choosing a MySQL® High Availability Solution
- Webinar Tuesday June 27, 2017: MariaDB® Server 10.2 – The Complete Guide
- Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication High Availability Webinar: Q & A
- ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)
- Percona Monitoring and Management 1.1.5 is Now Available
- Tracing MongoDB Queries to Code with Cursor Comments
- Webinar Thursday June 22, 2017: Deploying MySQL in Production
- The MySQL High Availability Landscape in 2017 (The Elders)
- Upcoming HA Webinar Wed 6/21: Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication
- MariaDB Server 10.2 GA Release Overview
- Peter Zaitsev’s Speaking Schedule: Percona University Belgium / PG Day / Meetups
- Three Methods of Installing Percona Monitoring and Management
- MySQL Triggers and Updatable Views
- Webinar Thursday, June 15, 2017: Demystifying Postgres Logical Replication
- Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling
- Blog Poll: What Operating System Do You Run Your Production Database On?
- ProxySQL Admin Interface Is Not Your Typical MySQL Server!
- MySQL Encryption at Rest – Part 1 (LUKS)
- Upcoming Webinar Thursday June 8, 2017: MongoDB Shell – A Primer
- Percona Live Open Source Database Conference Europe 2017 in Dublin, Ireland Call for Papers is Open!
- Webinar June 7, 2017: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling
- Percona XtraDB Cluster 5.7.18-29.20 is now available
- Percona XtraDB Cluster 5.6.36-26.20 is Now Available
May 2017
- ProxySQL-Assisted Percona XtraDB Cluster Maintenance Mode
- Percona XtraBackup 2.4.7-2 is Now Available
- Webinar May 31, 2017: Online MySQL Backups with Percona XtraBackup
- Percona Monitoring and Management 1.1.4 is Now Available
- Percona Server for MongoDB 3.0.15-1.10 is Now Available
- Percona Server for MySQL 5.7.18-15 is Now Available
- What About ProxySQL and Mirroring?
- Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017
- How to Save and Load Docker Images to Offline Servers
- ICP Counters in information_schema.INNODB_METRICS
- Webinar May 23, 2017: MongoDB Monitoring and Performance for the Savvy DBA
- Percona Toolkit 3.0.3 is Now Available
- MongoDB Authentication and Roles: Creating Your First Personalized Role
- Percona Live Open Source Database Conference 2017 Slides and Videos Available
- Percona Server for MongoDB 3.2.13-3.3 is Now Available
- Percona Server for MySQL 5.7.18-14 is Now Available
- Percona Server for MySQL 5.6.36-82.0 is Now Available
- MyRocks and LOCK IN SHARE MODE
- Percona Server for MySQL 5.5.55-38.8 is Now Available
- Percona-Lab/mongodb_consistent_backup: 1.0 Release Explained
- MariaDB Handler_icp_% Counters: What They Are, and How To Use Them
- Percona Server for MongoDB 3.4.4-1.4 is Now Available
- Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back
- How much disk space should I allocate for Percona Monitoring and Management?
- Storing UUID and Generated Columns
- Percona University in Europe May 9 and May 11
- Webinar Thursday May 4, 2017: Percona Software News and Roadmap Update Q2 2017
April 2017
- From Percona Live 2017: Thank You, Attendees!
- Percona Live 2017: Beringei – Facebook’s Open Source, In-Memory Time Series Database (TSDB)
- Percona Live 2017: Hawkular Metrics, An Overview
- Percona Live 2017: Lessons Learned While Automating MySQL Deployments in the AWS Cloud
- Percona Live 2017: Day Three Keynotes
- Percona Live 2017: MySQL Makes Toast
- Percona Live 2017: Database Management Made Simple – Amazon RDS
- Percona Live 2017: Histograms in MySQL and MariaDB
- Percona Live 2017: Deploying MongoDB on Public Clouds
- Percona Live 2017: A Deep-Dive Into What’s New in Amazon Aurora
- Percona Live 2017: Day Two Keynotes
- Migrate from TokuMX to Percona Server for MongoDB
- Percona Live 2017: Real-Time Data Loading from MySQL and Oracle into Analytics/Big Data
- Percona Live 2017: Designing your SaaS Database for Scale with Postgres
- Percona Live 2017 – MySQL 8.0: Major New Features
- Percona Live 2017: Day One Keynotes
- Percona Live 2017 Tutorials Day
- Improved wsrep-stages and related instrumentation in Percona XtraDB Cluster
- Percona XtraDB Cluster: SST tmpdir option
- Percona XtraDB Cluster: "dh key too small" error during an SST using SSL
- Percona XtraDB Cluster Transaction Replay Anomaly
- BEWARE: Increasing fc_limit can affect SELECT latency
- Better Than Linear Scaling
- Percona Monitoring and Management 1.1.3 is Now Available
- Percona Server for MySQL in Docker Swarm with Secrets
- Simplified Percona XtraDB Cluster SSL Configuration
- How to Setup and Troubleshoot Percona PAM with LDAP for External Authentication
- Enabling Percona XtraDB Cluster SST Traffic Encryption
- Percona Live Featured Session with Alibaba Cloud – Flashback: Rolling Back a MySQL/MariaDB Instance, Database or Table to a Previous Snapshot
- Tracking IST Progress in Percona XtraDB Cluster
- More Trackable Flow Control for Percona XtraDB Cluster
- Percona Live Featured Session with Casper Kejlberg-Rasmussen: Placing Databases @ Uber
- How We Made Percona XtraDB Cluster Scale
- Percona XtraDB Cluster 5.6.35-26.20-3 is now available
- Performance improvements in Percona XtraDB Cluster 5.7.17-29.20
- Percona XtraDB Cluster 5.7.17-29.20 is now available
- Percona XtraBackup 2.4.7 is Now Available
- Percona XtraBackup 2.3.8 is Now Available
- M17 Conference Observations on the Future of MariaDB
- Experimental Build of MyRocks with Percona Server for MySQL
- The mysqlpump Utility
- Run Percona Server on Bash on Windows on Ubuntu
- TokuDB Hotbackup and Replication
- TokuDB Troubleshooting: Q & A
- Percona Live Featured Session with Wei Hu – AliSQL: Breakthrough for the Future
- At Percona Live 2017: Many Technical MariaDB Server Sessions!
- ProxySQL Rules: Applying and Chaining the Rules
- Correct Index Choices for Equality + LIKE Query Optimization
- Webinar Wednesday 4/12: Tuning MongoDB Consistency
- ProxySQL Rules: Do I Have Too Many?
- InnoDB Page Merging and Page Splitting
- Non-Deterministic Order for SELECT with LIMIT
- Percona Server for MongoDB 3.4.3-1.3 is Now Available
- Percona Live Featured Session with Ilya Kosmodemiansky: Linux IO internals for Database Administrators
- MySQL Error Code 1215: "Cannot add foreign key constraint"
- Evaluation of PMP Profiling Tools
- Percona Server for MySQL 5.7.17-13 is Now Available
- Percona Live Webinar Thursday, April 6, 2017: Best Practices Migrating to Open Source Databases
- Percona Live Featured Session: Using SelectStar to Monitor and Tune Your Databases
- New MariaDB Dashboard in Percona Monitoring and Management Metrics Monitor
- Percona Monitoring and Management 1.1.2 is Now Available
March 2017
- Performance Evaluation of SST Data Transfer: With Encryption (Part 2)
- Performance Evaluation of SST Data Transfer: Without Encryption (Part 1)
- Webinar Thursday 3/30: MyRocks Troubleshooting
- Troubleshooting Issues with MySQL Character Sets Q & A
- What’s Next for SQL Databases?
- Percona Toolkit 3.0.2 is now available
- $5 Percona Live keynote passes and $101 101 crash courses
- Percona Server for MySQL 5.7.17-12 is Now Available
- Percona Server 5.6.35-81.0 is Now Available
- Percona Live Featured Session with Luís Soares: The New MySQL Replication Features in MySQL 8
- Running Percona XtraDB Cluster on Windows … in Docker
- The Puzzling Performance of the Samsung 960 Pro
- Percona Server for MySQL 5.5.54-38.7 is Now Available
- Dropping the Foreign Key Constraint Using pt-online-schema-change
- Webinar Wednesday March 22, 2017: TokuDB Troubleshooting
- Running Percona XtraBackup on Windows … in Docker
- Prophet: Forecasting our Metrics (or Predicting the Future)
- Percona XtraDB Cluster 5.7.17-27.20 is now available
- Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark
- Percona Server for MongoDB: Dashing New LDAP Authentication Plugin
- Monitoring Databases: A Product Comparison
- Percona Live Featured Session with Evan Elias: Automatic MySQL Schema Management with Skeema
- Upgrading to Percona Server for MongoDB 3.4 from Previous Versions
- How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It
- Webinar Thursday, March 16, 2017: Moving to Amazon Web Services (AWS)
- Percona XtraDB Cluster 5.6.35-26.20 is now available
- Troubleshooting MySQL access privileges issues: Q & A
- Percona Monitoring and Management (PMM) Graphs Explained: Custom MongoDB Graphs and Metrics
- Percona Server for MongoDB 3.2.12-3.2 is now available
- Services Monitoring with Probabilistic Fault Detection
- Migrating MongoDB Away from MMAPv1
- Percona Live Featured Session with Bogdan Munteanu: Edgestore Multi-Tenancy and Isolation
- How to Change MongoDB Storage Engines Without Downtime
- Improving TokuDB Hot Backup Usage with the autotokubackup Command Line Tool
- Webinar Thursday, March 9, 2017: Troubleshooting Issues with MySQL Character Sets
- MySQL, –i-am-a-dummy!
- MongoDB Audit Log: Why and How
- A Look at MariaDB Subquery Cache
- Using Percona Toolkit pt-mongodb-summary
- Using Percona Toolkit pt-mongodb-query-digest
- Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity
February 2017
- Percona Monitoring and Management (PMM) Graphs Explained: MongoDB MMAPv1
- Webinar Thursday March 2, 2017: MongoDB Query Patterns
- MySQL Ransomware: Open Source Database Security Part 3
- Percona Monitoring and Management (PMM) Graphs Explained: WiredTiger and Percona Memory Engine
- How to Install Percona Monitoring and Management (PMM) for the First Time
- Synchronous Replication in MySQL: Galera vs. Group Replication
- Percona MongoDB 3.4 Bundle Release: Percona Server for MongoDB 3.4 Features Explored
- Webinar Thursday, February 23, 2017: Troubleshooting MySQL Access Privileges Issues
- Percona Monitoring and Management (PMM) Graphs Explained: MongoDB with RocksDB
- Percona XtraBackup 2.4.6 is Now Available
- Percona XtraBackup 2.3.7 is Now Available
- Percona Monitoring and Management (PMM) Upgrade Guide
- Webinar Wednesday February 22, 2017: Percona Server for MongoDB 3.4 Product Bundle Release
- MongoDB 3.4 Bundle Release: Percona Server for MongoDB 3.4, Percona Monitoring and Management 1.1, Percona Toolkit 3.0 with MongoDB
- Percona Toolkit 3.0.1 is now available
- Percona Monitoring and Management 1.1.1 is now available
- Percona Server for MongoDB 3.4.2-1.2 is now available
- MySQL Bug 72804 Workaround: "BINLOG statement can no longer be used to apply query events"
- Percona Blog Poll Results: What Programming Languages Are You Using for Backend Development?
- MariaDB at Percona Live Open Source Database Conference 2017
- Group Replication: Shipped Too Early
- Docker Images for Percona Server for MySQL Group Replication
- Percona Live Open Source Database Conference 2017 Crash Courses: MySQL and MongoDB!
- Percona Server for MongoDB 3.4 Product Bundle Release is a Valentine to the Open Source Community
- ClickHouse: New Open Source Columnar Database
- Percona Blog Poll: What Database Engine Are You Using to Store Time Series Data?
- Using NVMe Command Line Tools to Check NVMe Flash Health
- Percona Server 5.6.35-80.0 is Now Available
- MySQL super_read_only Bugs
- Percona Monitoring and Management 1.1.0 Beta is Now Available
- Percona Server for MongoDB 3.4.1-1.1 Release Candidate is Now Available
- Percona Toolkit 3.0.0 Release Candidate is Now Available
- Percona Server for MySQL 5.7.17-11 is now available
- ProxySQL Tutorial with Derek Downey, David Turner and René Cannaò
- PMM Alerting with Grafana: Working with Templated Dashboards
- Vote Percona in LinuxQuestions.org Members Choice Awards 2016
- WAN Synchronous Clusters: Dealing with Latency Using Concurrency
- Percona Server for MySQL 5.5.54-38.6 is now available
January 2017
- Docker Security Vulnerability CVE-2016-9962
- MySQL Sharding Models for SaaS Applications
- MariaDB ColumnStore
- Percona Software News and Roadmap Update with CEO Peter Zaitsev: Q1 2017
- When MySQL Lies: Wrong seconds_behind_master with slave_parallel_workers > 0
- Percona Live Featured Tutorial with Frédéric Descamps — MySQL InnoDB Cluster & Group Replication in a Nutshell: Hands-On Tutorial
- Performance Schema Benchmarks: OLTP RW
- ProxySQL Admin Configuration
- Webinar Thursday January 26, 2017: Overcoming the Challenges of Databases in the Cloud
- Webinar Wednesday January 25, 2017: Percona Server for MySQL 5.7 Key Performance Algorithms
- MySQL and MongoDB Alerting with PMM and Grafana
- How to Manually Build Percona Server for MySQL RPM Packages
- Setup ProxySQL for High Availability (not a Single Point of Failure)
- Open Source Databases on Big Machines: Does READ COMMITTED Scale on 144 Cores?
- Elasticsearch Ransomware: Open Source Database Security Part 2
- Webinar Wednesday January 18, 2017: Lessons from Database Failures
- Percona Live Featured Tutorial with Morgan Tocker — MySQL 8.0 Optimizer Guide
- Ad-hoc Data Visualization and Machine Learning with mysqlshell
- MongoDB 3.4 Views
- The Impact of Swapping on MySQL Performance
- CVE-2016-6225: Percona Xtrabackup Encryption IV Not Being Set Properly
- The Percona Online Store: Get Database Help Now with Support and Health Audit Services
- How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server
- Reinstall MySQL and Preserve All MySQL Grants and Users
- Webinar Thursday, January 12: Percona Software News and Roadmap Update for Q1 2017
- How to Move a MySQL Partition from One Table to Another
- MongoDB PIT Backups: Part 2
- MySQL 8.0.1: The Next Development Milestone
- Archiving MySQL and MongoDB Data
- PostgreSQL and MySQL: Millions of Queries per Second
- MongoDB Ransomware: Not Likely, But How Do You Know?
- MongoDB 3.4: Sharding Improvements
- Enabling and Disabling Jemalloc on Percona Server
2016 426
December 2016
- Query Language Type Overview
- Percona Live Featured Tutorial with Øystein Grøvlen — How to Analyze and Tune MySQL Queries for Better Performance
- Quickly Troubleshoot Metadata Locks in MySQL 5.7
- Using Percona XtraBackup on a MySQL Instance with a Large Number of Tables
- Webinar Thursday December 29: JSON in MySQL 5.7
- Don’t Let a Leap Second Leap on Your Database!
- Percona Server for MongoDB 3.4 Beta is now available
- Percona Blog Poll: What Programming Languages are You Using for Backend Development?
- Percona Poll Results: What Database Technologies Are You Using?
- Installing Percona Monitoring and Management on Google Container Engine (Kubernetes)
- Securing MongoDB Instances
- MongoDB PIT Backups In Depth
- Percona Live 2017 Sneak Peek Schedule Up Now! See the Available Sessions!
- Percona XtraDB Cluster 5.7.16-27.19 is now available
- Percona Live Featured Tutorial with Giuseppe Maxia — MySQL Document Store: SQL and NoSQL United
- Row Store and Column Store Databases
- Percona XtraDB Cluster 5.6.34-26.19 is now available
- Webinar Wednesday 12/14: MongoDB System Tuning Best Practices
- MongoDB 3.4: Facet Aggregation Features and SERVER-27395 Mongod Crash
- Database Solutions Engineer FAQs
- Percona Monitoring and Management 1.0.7 release
- Percona Monitoring Plugins 1.1.7 release
- Percona Toolkit 2.2.20 is now available
- Tuning Linux for MongoDB: Automated Tuning on Redhat and CentOS
- First MongoDB replica-set Configuration for MySQL DBAs
- Percona Server for MongoDB 3.2.11-3.1 is now available
- Webinar Thursday, December 8: Virtual Columns in MySQL and MariaDB
- Percona Live 2017 Open Source Database Conference Tutorial Schedule is Live!
- MongoDB Troubleshooting: My Top 5
- Business Continuity and MySQL Backups
- Make MySQL 8.0 Better Through Better Benchmarking
- Managing Replication with Percona XtraDB Cluster
- GTID Replication and Binary Logs Purge
November 2016
- Galera Cache (gcache) is finally recoverable on restart
- Using the InnoDB Buffer Pool Pre-Load Feature in MySQL 5.7
- Percona XtraBackup 2.4.5 is now available
- Percona XtraBackup 2.3.6 is now available
- Percona Server for MongoDB 3.0.14-1.9 is now available
- Percona Server 5.7.16-10 is now available
- Percona Server 5.6.34-79.1 is now available
- Percona Server for MySQL 5.5.53-38.5 is now available
- Webinar Q/A: MySQL High Availability with Percona XtraDB Cluster 5.7
- Percona Server 5.5.53-38.4 is now available
- WiredTiger B-Tree versus WiredTiger In-Memory: Q & A
- Help Us Shape the Future of Percona
- All You Need to Know About GCache (Galera-Cache)
- Are Docker Containers Good for Your Database?
- Webinar Thursday, November 17: MySQL High Availability with Percona XtraDB Cluster 5.7
- Percona Monitoring and Management 1.0.6 is now available
- Using Vault with MySQL
- MongoDB Through a MySQL Lens
- Amazon AWS Service Tiers
- How to Fully Disable Query Cache in MySQL
- Thoughts About Column Compression, with Optional Predefined Dictionary
- Database Daily Ops Series: GTID Replication
- Orchestrator and ProxySQL
- Checking if a Slave Has Applied a Transaction from the Master
- Percona Live 2017 Call for Papers Extended Deadline: November 13th
- Updating Percona XtraDB Cluster from 5.6.24-72.2 to 5.6.32-25.17
- Changing the Tablespace Directory with pt-online-schema-change
- Orchestrator: Moving VIPs During Failover
- Percona responds to CVE-2016-6663 and CVE-2016-6664
- Webinar Thursday November 3: The MySQL Ecosystem in 2016
- Percona Monitoring and Management (PMM) Information Script
- The Future of TokuDB at Percona
October 2016
- Percona Server for MongoDB 3.2.10-3.0 is now available
- Webinar Wednesday November 2: MongoDB Backups, All Grown Up!
- Blog Series: MySQL Configuration Management
- New TokuDB and PerconaFT database file management feature in Percona Server 5.6.33-79.0 and Percona Server 5.7.15-9
- Thoughts on MySQL 8.0 Invisible Indexes
- Percona Poll: What Database Technologies Are You Using?
- Percona Live Open Source Database Conference 2017: Submit Papers ASAP!
- Monitoring OS metrics for Amazon RDS with Grafana
- TokuDB and PerconaFT Data Files: Database File Management Part 2 of 2
- Announcing MyRocks in Percona Server for MySQL
- Replication Triggers a Performance Schema Issue on Percona XtraDB Cluster
- Percona Responds to East Coast DDoS Attack
- Percona Server 5.7.15-9 is now available
- MySQL 8.0: Descending Indexes Can Speed Up Your Queries
- A Guide to the Percona Monitoring and Management Demo
- Three Things to Consider When Thinking About Containers
- Upgrading to MySQL 5.7? Beware of the new STRICT mode
- MySQL Downgrade Caveats
- Percona Server 5.6.33-79.0 is now available
- Percona Monitoring and Management 1.0.5 is now available
- Update the Signing Key for Percona Debian and Ubuntu Packages
- MySQL 5.7 Performance Tuning After Installation
- Encrypt your –defaults-file
- Using the loose_ option prefix in my.cnf
- Take Percona’s One-Click 2017 Top Database Concerns Poll
- Percona Database Security Poll Results
- Consul Architecture
- Why Percona didn’t participate in the 2016 Gartner Operational DBMS MQ
- From Percona Live Europe 2016: Thank You, Attendees!
- Use MySQL Shell Securely from Bash
- Percona Live Europe 2016: "Google Cloud SQL: MySQL in the Cloud" with Pravin Pillai
- Percona Live Europe 2016: "Inside CockroachDB’s Survivability Model" with Marc Berhault
- Percona Live Europe 2016: "MongoDB Query Monitoring" with Pavel Trukhanov
- Percona Live Europe 2016: Day Two Keynote Speakers
- Percona Server 5.5.52-38.3 is now available
- Percona Live Europe 2016: "PostgreSQL Worst Practices" with Ilya Kosmodemiansky
- Percona Live Europe 2016: "MySQL 8.0: what’s new in Optimizer" with Manyi Lu
- Percona Live Europe 2016: Day One Keynote Speakers
- Percona XtraDB Cluster 5.6.32-25.17 is now available
- MySQL 8.0 General Tablespaces: File per Database (and no FRM files)
- Percona Live Europe 2016: "MongoDB 101, Part Two" with David Murphy Kim Wilkins
- Percona Live Europe 2016: "Become a MySQL DBA" with Severalnines’ Johan Andersson and Krzysztof Książek
- Percona Live Europe featured talk with Philipp Krenn — Elasticsearch for SQL Users
September 2016
- Percona Software News and Roadmap Update with CEO Peter Zaitsev
- Percona XtraDB Cluster 5.7.14-26.17 GA is now available
- 7 Fresh Bugs in MySQL 8.0
- Percona Live Europe featured talk with John De Goes — MongoDB Analytics & Dashboards
- Using the MySQL super_read_only system variable
- TokuDB and PerconaFT database file management part 1 of 2
- High Availability at Percona Live Europe 2016
- Webinar Wednesday, September 28: Percona Software News and Roadmap Update – Q3 2016
- MariaDB Sessions at Percona Live Europe 2016
- Identifying and Solving Database Performance Issues with PMM: Webinar Q&A
- Percona Live Europe featured talk with Anthony Yeh — Launching Vitess: How to run YouTube’s MySQL sharding engine
- Percona XtraDB Cluster 5.5.41-25.12 is now available
- Sixth Annual Percona Live Open Source Database Conference 2017 Call for Speakers Now Open
- Percona XtraDB Cluster 5.6.30-25.16.3 is now available
- Percona Server 5.7.14-8 is now available
- Percona Server 5.6.32-78.1 is now available
- Percona Server 5.5.51-38.2 is now available
- Regular Expressions Tutorial
- Webinar Thursday September 22 – Black Friday and Cyber Monday: How to Avoid an E-Commerce Disaster
- MongoDB Point-in-Time Backups Made Easy
- Percona Live Europe featured talk with Marc Berhault — Inside CockroachDB’s Survivability Model
- Open Source Databases at Percona Live Europe, Amsterdam
- Percona Server for MongoDB 3.2.9-2.1 is now available
- How X Plugin Works Under the Hood
- Consul, ProxySQL and MySQL HA
- ProxySQL and Percona XtraDB Cluster (Galera) Integration
- Percona XtraDB Cluster 5.6.30-25.16.2 is now available (CVE-2016-6662 fix)
- MySQL Default Configuration Changes between 5.6 and 5.7
- pmp-check-pt-table-checksum Percona Monitoring Plugin
- Webinar Thursday Sept. 15: Identifying and Solving Database Performance Issues with PMM
- Black Friday and Cyber Monday: Best Practices for Your E-Commerce Database
- MySQL CDC, Streaming Binary Logs, and Asynchronous Triggers
- ProxySQL and MHA Integration
- Percona Monitoring and Management (PMM) is now available
- Is Your Database Affected by CVE-2016-6662?
- Percona Live Europe featured talk with Ronald Bradford — Securing your MySQL/MariaDB data
- Percona Server Critical Update CVE-2016-6662
- Don’t Spin Your Data, Use SSDs!
- Basic Housekeeping for MySQL Indexes
- MySQL Replication Troubleshooting: Q & A
- Percona Live Europe featured talk with Igor Canadi — Everything you wanted to know about MongoRocks
- Get MySQL Passwords in Plain Text from .mylogin.cnf
- MyRocks Docker images
- MongoDB at Percona Live Europe
- InnoDB Troubleshooting: Q & A
- MHA MySQL Quick Start Guide
- Percona Live Europe featured talk with Manyi Lu — MySQL 8.0: what’s new in Optimizer
August 2016
- Webinar Thursday, September 1 – MongoDB Security: A Practical Approach
- MySQL Sharding with ProxySQL
- Percona Live Europe Discounted Pricing and Community Dinner!
- Percona Live Europe featured talk with Alexander Krasheninnikov — Processing 11 billion events a day with Spark in Badoo
- Percona Live Europe featured talk with Krzysztof Książek — MySQL Load Balancers – MaxScale, ProxySQL, HAProxy, MySQL Router & nginx
- PostgreSQL Day at Percona Live Amsterdam 2016
- How to stop offending queries with ProxySQL
- Percona Server 5.7.14-7 is now available
- Percona Server 5.6.32-78.0 is now available
- Query rewrite plugin: scalability fix in MySQL 5.7.14
- Top Most Overlooked MySQL Performance Optimizations: Q & A
- Percona Server 5.5.51-38.1 is now available
- ProxySQL 1.2.1 GA Release
- TokuDB/PerconaFT fragmented data file performance improvements
- How Apache Spark makes your slow MySQL queries 10x faster
- Webinar Thursday 8/18: Preventing and Resolving MySQL Downtime
- Percona Toolkit 2.2.19 is now available
- I’m Colin Charles, and I’m here to evangelize open source databases!
- Percona Live Europe 2016 Schedule Now Live
- Tuning Linux for MongoDB
- Percona XtraDB Cluster 5.7.12 RC1 is now available
- Percona Memory Engine for MongoDB
- Percona Server for MongoDB 3.2.8-2.0 is now available
- Introducing Percona Memory Engine for MongoDB
- Small innodb_page_size as a performance boost for SSD
- tpcc-mysql benchmark tool: less random with multi-schema support
- Webinar Thursday 8/11 at 10 am: InnoDB Troubleshooting
- Docker Images for MySQL Group Replication 5.7.14
- Percona XtraDB Cluster on Ceph
- Testing Docker multi-host network performance
- Take Percona’s One-Click Database Security Downtime Poll
- High Availability Poll Results
- Introduction into storage engine troubleshooting: Q & A
July 2016
- MariaDB 10.2 CHECK and DEFAULT clauses
- Percona Monitoring and Management 1.0.2 Beta
- Upcoming Webinar August 2 10:00 am PDT: MySQL and Ceph
- Percona Live Europe Amsterdam 2016 Tutorial Schedule is Up!
- Monitoring MongoDB with Nagios
- Testing Samsung storage in tpcc-mysql benchmark of Percona Server
- Percona XtraBackup 2.4.4 is now available
- MongoDB Consistent Backups
- The Value of Database Support
- Upcoming Webinar Wednesday July 20, 11 am PDT: Practical MySQL Performance Optimization
- Percona Live Europe, Amsterdam 2016: Speaking Gets You the Whole Community Event!
- MongoDB Data Durability
- Using Ceph with MySQL
- Call for Percona Live Europe MongoDB Speakers
- Percona Server for MongoDB 3.0.12-1.8 is now available
- Webinar July 14, 10 am PDT: Introduction into storage engine troubleshooting
- Percona Server 5.5.50-38.0 is now available
- Percona XtraBackup 2.3.5 is now available
- Percona Server 5.6.31-77.0 is now available
- Pipelining versus Parallel Query Execution with MySQL 5.7 X Plugin
- Percona Server 5.7.13-6 is now available
- MySQL 8.0
- How MySQL 5.7 Handles UTF8MB4 and the Load Data infile
- Amazon RDS and pt-online-schema-change
June 2016
- Rescuing a crashed pt-online-schema-change with pt-archiver
- 2016 MySQL User Group Leaders Summit
- Percona Server for MongoDB 3.2.7-1.1 is now available
- Webinar Wednesday June 29: Percona XtraDB Cluster Reference Architecture
- The need for parallel crash recovery in MySQL
- Percona Toolkit 2.2.18 is now available
- Percona Server for MongoDB 3.0.12-1.7 is now available
- Migrate from MS SQL Server to MySQL
- Troubleshooting configuration issues: Q & A
- Sneak peek at the Percona Live Europe Amsterdam 2016 talks
- Docker automatic MySQL slave propagation
- Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host
- Webinar Thursday June 23: Choosing a MySQL High Availability Solution Today
- InnoDB locks and transaction isolation level
- MongoDB Security: Why Pay for Enterprise when Open Source Has You Covered?
- Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes
- Why MongoRocks: Deprecating PerconaFT and MongoDB Optimistic locking
- Troubleshooting hardware resource usage webinar: Q & A
- Installing MongoDB 3.2 and upgrading MongoDB replica set
- MongoDB and non-existent collections
- Scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm
- RocksDB from Docker containers
- Webinar Thursday, June 16: MongoDB Schema Design
- Percona XtraDB Cluster 5.6.30-25.16 is now available
- Running Percona XtraDB Cluster in a multi-host Docker network
- Percona Monitoring and Management 1.0.1 Beta
- Percona XtraDB Cluster 5.7 beta is now available
- Using MySQL 5.7 Document Store with Internet of Things (IoT)
- Severe performance regression in MySQL 5.7 crash recovery
- Webinar Thursday, June 9: Troubleshooting MySQL configuration issues
- Percona Server 5.7.12-5 is now available
- EL5 and why we’ve had to enable TLSv1.0 again
- Percona Server for MongoDB 3.2.6-1.0 is now available
- MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs
- Galera warning "last inactive check"
- Percona Live Europe call for papers is now open!
- Why use provisioned IOPS volumes for AWS databases?
- MongoDB Administration Checklist for MySQL DBAs
- Embracing MongoRocks
May 2016
- Troubleshooting locking issues webinar: Q & A
- What is a big innodb_log_file_size?
- Galera Error Failed to Report Last Committed (Interrupted System Call)
- Asynchronous Query Execution with MySQL 5.7 X Plugin
- Join me for the Community Open House for MongoDB
- Monitoring made easy with Percona App for Grafana
- AWS Aurora Benchmarking part 2
- MongoDB 3.2: elections just got better!
- Percona Server 5.6.30-76.3 is now available
- Looking inside the MySQL 5.7 document store
- pt-online-schema-change (if misused) can’t save the day
- Webinar Thursday May 26: Troubleshooting MySQL hardware resource usage
- Take Percona’s one-click high availability poll
- Percona disabling TLSv1.0 May 31st 2016
- Percona XtraBackup 2.4.3 is now available
- Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A
- Percona XtraDB Cluster 5.6.29-25.15 is now available
- Fixing MySQL scalability problems with ProxySQL or thread pool
- Webinar Tuesday, May 24: Understanding how your MongoDB schema affects scaling, and when to consider sharding for help
- Percona Server for MongoDB 3.0.11-1.6 is now available
- Percona Server 5.5.49-37.9 is now available
- Where is the MySQL 5.7 root password?
- Webinar Thursday May 19, 2016: MongoDB administration for MySQL DBA
- MySQL 5.7 read-write benchmarks
- MySQL "Got an error reading communication packet"
- Benchmark MongoDB with sysbench
- ProxySQL versus MaxScale for OLTP RO workloads
- Quick start MySQL testing using Docker (on a Mac!)
- Query Rewrite plugin can harm performance
- Percona Server 5.7 parallel doublewrite
- CPU governor performance
- Percona Server 5.7: multi-threaded LRU flushing
- MySQL High Availability: The Road Ahead for Percona and XtraDB Cluster
- MySQL 5.7: initial flushing analysis and why Performance Schema data is incomplete
- Best Practices for Configuring Optimal MySQL Memory Usage
April 2016
- Upgrading to MySQL 5.7, focusing on temporal types
- How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator
- Percona Live 2016: Closing Comments and Prize Giveaway
- Percona Live 2016: MongoDB Security
- Percona Live 2016: Sometimes "Less is More" for dash-boarding and graphing
- Percona Live 2016: Percona Live Game Night!
- Percona Live 2016: MySQL Community Awards Ceremony
- Percona Live 2016: Day Three Keynote Talks
- Percona Live 2016: What’s New in MySQL
- Percona Live 2016: MySQL and Docker Strategies
- Percona Live 2016: Indexing Strategies and Tips for MongoDB
- Percona Live 2016: Operational Buddhism — Building Reliable Services from Unreliable Components
- Percona Live 2016: Day Two Keynote Talks
- Percona Live 2016: Running MongoRocks in Production
- Percona Live 2016: High Availability Using MySQL Group Replication
- Percona Live 2016: A quick chat with Bill Nye, the Science Guy!
- Percona Live 2016: Let Robots Manage your Schema (without destroying all humans)!
- Percona Live 2016: Performance of Percona Server for MySQL on Intel Server Systems using HDD, SATA SSD, and NVMe SSD as Different Storage Mediums
- Day One of the Percona Live Data Performance Conference 2016 is off and running!
- Percona Server for MongoDB 3.2.4-1.0rc2 is now available
- Percona Announces the Launch of Percona Monitoring and Managment Beta
- How Percona XtraDB Cluster certification works
- The final three Database Performance Team characters are . . .
- Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution?
- Creating Geo-Enabled applications with MongoDB, GeoJSON and MySQL
- MySQL Document Store Developments
- Percona Live featured talk with Álvaro Hernández Tortosa — ToroDB: Supercharging your RDBMS with MongoDB super powers
- Orchestrator-agent: How to recover a MySQL database
- Evaluating Database Compression Methods: Update
- Percona Live featured talk with Ying Qiang Zhang — What’s new in AliSQL: Alibaba’s branch of MySQL
- Is Adaptive Hash Index in InnoDB right for my workload?
- Downloading MariaDB MaxScale binaries
- Understanding GCache and Record-Set Cache in Percona XtraDB Cluster
- Understanding Percona XtraDB Cluster threading model
- MySQL Data at Rest Encryption
- The first two Database Performance Team characters are . . .
- MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really faster?
- 11 Days Until Percona Live: Justification, Julian Cash, Sponsor List
- Percona Live: Advanced Percona XtraDB Cluster in a Nutshell, La Suite
- EXPLAIN FORMAT=JSON wrap-up
- Webinar April 7, 10am PDT – Introduction to Troubleshooting Performance: What Affects Query Execution?
- Percona Live featured talk with Anastasia Ailamaki — RAW: Fast queries on JIT databases
- Data in the Cloud track at Percona Live with Brent Compton and Ross Turk: The Data Performance Cloud
- See Bill Nye the Science Guy at Percona Live and help change the world: a special offer!
- Percona XtraBackup 2.4.2 is now available
- Fixing MySQL Bug#2: now MySQL makes toast!
March 2016
- MongoDB at Percona Live: A Special Open Source Community Discount
- Docker MySQL Replication 101
- Percona Live featured talk with Avi Kivity: Scylla, a Cassandra-compatible NoSQL database at two million requests per second
- Read-write split routing in MaxScale
- MySQL 5.7 primary key lookup results: is it really faster?
- Percona How To: Field Names and Document Size in MongoDB
- Want to be a superhero? Join the Database Performance Team!
- Stewart Smith: Why Would I Run MySQL or MariaDB on POWER Anyway?
- TokuDB impacts InnoDB Performance?
- Webinar Thursday March 24: What MongoDB Storage Engine is Right for You?
- Percona Live 2016 Community Game Night
- Moving with SQL Server to Linux? Move from SQL Server to MySQL as well!
- Introduction to MySQL troubleshooting basic techniques webinar: Q & A
- Percona Server for MongoDB 3.0.10-1.5 is now available
- MySQL replication primer with pt-table-checksum / pt-table-sync, part 2
- Percona Server 5.7 performance improvements
- Percona XtraBackup 2.3.4 is now available
- Percona Live featured talk with Konstantin Osipov: Tarantool – a Lua Based Database Engine and In-Memory Data Grid
- Change user password in MySQL 5.7 with "plugin: auth_socket"
- Update for Percona Live 2016 Attendees: Fun Events, Don’t Miss Out!
- Percona Server 5.7.11-4 is now available
- Percona XtraDB Cluster in a high latency network environment
- Percona Server for MongoDB 3.0.9-1.4 is now available
- Introduction to MySQL Troubleshooting Webinar: Q & A for How to Create a Test Setup
- Percona Live featured talk with Sugu Sougoumarane – Vitess: The Complete Story
- What to expect at Percona Live 2016!
- Evaluating Database Compression Methods
- Orchestrator: MySQL Replication Topology Manager
- JSON document fast lookup with MySQL 5.7
- Percona Toolkit 2.2.17 is now available
- Percona Server 5.6.29-76.2 is now available
- How to Mitigate DROWN CVE-2016-0800
- Virtual columns in MySQL and MariaDB
- Percona Server 5.5.48-37.8 is now available
- Deals of a "Live" time: $5 Percona Live Keynote Passes!
- Percona Live featured talk with Mark Callaghan – Keynote speaker: RocksDB
- How MaxScale monitors servers
February 2016
- EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent
- Graphing MySQL performance with Prometheus and Grafana
- Monitoring MongoDB Response Time
- Percona Back to Basics: MongoDB updates
- High availability with asynchronous replication… and transparent R/W split
- Percona Live featured talk with Kat Styons – Shifting the Paradigm: MongoDB and the MEAN Stack
- Percona Server for MongoDB 3.0.8-1.3 is now available
- MySQL connection using SSL… or not ?
- Percona Server 5.7.10-3 GA is now available
- Percona XtraBackup 2.4.1 GA is now available
- EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another
- Upcoming Webinar Wednesday: Using Grafana for MySQL Monitoring
- MongoDB Scalability Myth Busting (it scales!)
- MongoDB, security, and how not to get stung
- Percona Live featured talk with Geir Hoydalsvik: What’s New in MySQL
- MySQL Auditing with MariaDB Auditing Plugin
- Measuring Docker IO overhead
- Percona Live featured talk with Sergej Jurecko: ActorDB — an alternative view of a distributed database
- Estimating potential for MySQL 5.7 parallel replication
- EXPLAIN FORMAT=JSON: buffer_result is not hidden!
- Percona Server 5.7.10-2 second RC available
- Percona XtraBackup 2.4.0-rc1 is now available
- MySQL 5.7: Introduction for Operational DBAs
- Measuring Percona Server Docker CPU/network overhead
- MySQL password expiration features to help you comply with PCI-DSS
- New GIS Features in MySQL 5.7
- Percona Live Crash Courses: for MySQL and MongoDB!
- Experimental Percona Docker images for Percona Server
- InnoDB and TokuDB on AWS
January 2016
- EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications
- Percona XtraDB Cluster 5.6.28-25.14 is now available
- Vote Percona Server in LinuxQuestions.org Members Choice Awards
- Setup a MongoDB replica/sharding set in seconds
- MongoDB revs you up: What storage engine is right for you? (Part 4)
- Percona CEO Peter Zaitsev discusses working remotely with Fortune Magazine
- Finding MySQL Table Size on Disk
- EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values
- Peter Zaitsev webinar January 27th: Compression In Open Source Databases
- Percona Live Data Performance Conference 2016: news you need to know!
- Tired of MySQL Making You Wait? Webinar: Questions and Answers
- MongoDB revs you up: What storage engine is right for you? (Part 3)
- Dealing with corrupted InnoDB data
- Making Apache Spark Four Times Faster
- OpenSSH CVE-2016-0777: Details and Mitigation
- Prometheus as an Engine for MySQL Monitoring
- Play the Percona Powerball Pool!!
- Percona Server 5.6.28-76.1 is now available
- Percona Server 5.5.47-37.7 is now available
- Percona Monitoring Plugins 1.1.6 release
- Bare-metal servers for button-push database-as-a-service
- MongoDB revs you up: What storage engine is right for you? (Part 2)
- Percona XtraDB Cluster 5.6.27-25.13 is now available
- ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing
- Apache Spark with Air ontime performance data
- MongoDB revs you up: What storage engine is right for you? (Part 1)
- grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY
- Percona Server for MongoDB 3.0.8-1.2 is now available
2015 252
December 2015
- Database Performance Webinar: Tired of MySQL Making You Wait?
- 2016 Percona Live Tutorials Schedule is UP!
- EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY
- EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness
- Percona Server for MongoDB storage engines in iiBench insert workload
- EXPLAIN FORMAT=JSON: everything about attached_subqueries, optimized_away_subqueries, materialized_from_subquery
- Better high availability: MySQL and Percona XtraDB Cluster with good application design
- Performance Schema: Measure Multi-Threaded Slave Activity
- Sneak peek at the Percona Live Data Performance Conference and Expo 2016
- used_key_parts: EXPLAIN FORMAT=JSON provides insight into which part of multiple-column key is used
- Percona XtraBackup 2.3.3 is now available
- Using dbsake to recover table structure from .frm files and process mysqldump output
- Act Quickly for Percona Live Super Saver rate – Plus an added incentive!
- MongoDB 3.2 WiredTiger in iiBench
- used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes
- Percona Server 5.7.10-1 first RC available
- Percona Server for MongoDB 3.0.7-1.0 is now available
- rows_examined_per_scan, rows_produced_per_join: EXPLAIN FORMAT=JSON answers on question "What number of filtered rows mean?"
- attached_condition: How EXPLAIN FORMAT=JSON can spell-check your queries
- Percona Server 5.6.27-76.0 is now available
- Percona Server 5.5.46-37.6 is now available
- Amazon Aurora in sysbench benchmarks
- Upcoming Webinar: MySQL 5.7 in a Nutshell
- Fixing errant transactions with mysqlslavetrx prior to a GTID failover
- How to upgrade your master server with minimal downtime
- Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)
November 2015
- Smallest MySQL Server in the World (under $60) which can even make you toast while fixing MySQL bug #2
- Amazon Aurora – Looking Deeper
- pt-online-schema-change and innodb_stats_persistent on MySQL 5.6
- Logical MySQL backup tool Mydumper 0.9.1 now available
- Percona Toolkit 2.2.16 is now available
- Percona Server 5.6.27-75.0 is now available
- Percona Server 5.5.46-37.5 is now available
- MySQL 5.7: CHANGE REPLICATION FILTER online
- A first look at RDS Aurora
October 2015
- MySQL and Trojan.Chikdos.A
- MySQL 5.7 first impressions on group-replication
- How Big Can Your Galera Transactions Be
- State of Percona Server 5.6, MySQL 5.6 and MySQL 5.7 RC
- Internet of Things, Messaging and MySQL
- Percona XtraBackup 2.3.2 GA is now available
- Percona XtraBackup 2.2.13 is now available
- RocksDB 101
- Slow query graphs using Performance Schema and Graphite
- Percona Live 2016 Call for Papers Open! Introducing: Community Voting
- Percona Welcomes David Murphy as Practice Manager for MongoDB
- Percona Live Amsterdam Recap
- MySQL 101 Videos – A Must Have Starter Kit for a MySQL DBA
- Gartner, Thank You for Recognizing Percona in the Magic Quadrant for ODBMS!
- Proxy Protocol and Percona XtraDB Cluster: A Quick Guide
- Percona XtraDB Cluster 5.6.26-25.12 is now available
- MySQL query digest with Performance Schema
- Online DDL and Percona XtraDB Cluster 5.6
- When mysqld kills mysqld
- Apache Spark and MySQL for Data Analysis
- Capture database traffic using the Performance Schema
September 2015
- Percona XtraDB Cluster 5.6.25-25.12 is now available
- Containing your logical backups: mydumper in docker
- Percona Server for MongoDB 3.0.5-rc7 is now available
- VividCortex Agent Benchmark
- Clarification on "Call me Maybe: MariaDB Galera Cluster"
- Webinar: Introduction to MySQL SYS Schema follow up questions
- Percona Server 5.6.26-74.0 is now available
- MongoDB and Percona TokuMX Security Guidelines
- Webinar: Writing Application Code for MySQL High Availability Followup Questions
- Percona TokuMX 2.0.2 is now available
- Percona Live Keynote Speakers and Topics!
- Percona Server audit log plugin best practices
- Testing MySQL partitioning with pt-online-schema-change
- super_read_only and GTID replication
- Facebook’s Simon Martin on semi-synchronous replication
- Percona Toolkit and systemd
- Percona Server 5.5.45-37.4 is now available
- Booking.com’s Jean-François Gagné on Percona Live Amsterdam
August 2015
- High-load clusters and desynchronized nodes on Percona XtraDB Cluster
- Percona Toolkit 2.2.15 is now available
- ObjectRocket’s David Murphy talks about MongoDB, Percona Live Amsterdam
- Advanced Query Tuning in MySQL 5.6 and MySQL 5.7 Webinar: Q&A
- Find unused indexes on MongoDB and TokuMX
- Optimizing PXC Xtrabackup State Snapshot Transfer
- How much could you benefit from MySQL 5.6 parallel replication?
- Featured Talk: The Future of Replication is Today: New Features in Practice
- MySQL is crashing: a support engineer’s point of view
- The language of compression
- MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)
- Percona Live Amsterdam Discounted Pricing and Community Dinner!
- MySQL replication primer with pt-table-checksum and pt-table-sync
- MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash
- The MySQL query cache: Worst enemy or best friend?
- PXC – Incremental State transfers in detail
- MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How
- Percona XtraBackup 2.2.12 is now available
- Checkpoint strikes back
July 2015
- MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right
- Why base64-output=DECODE-ROWS does not print row events in MySQL binary logs
- Multi-source replication in MySQL 5.7 vs Tungsten Replicator
- MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh
- InnoDB vs TokuDB in LinkBench benchmark
- The Q&A: Creating best-in-class backup solutions for your MySQL environment
- SELinux and the MySQL init script
- Percona now offering 24/7 support for MongoDB and TokuMX
- MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh!
- Percona Live Amsterdam discounted pricing ends July 26!
- Fractal Tree library as a Key-Value store
- Bypassing SST in Percona XtraDB Cluster with binary logs
- Bypassing SST in Percona XtraDB Cluster with incremental backups
- MySQL QA Episode 6: Analyzing and Filtering
- MongoDB benchmark: sysbench-mongodb IO-bound workload comparison
- MySQL QA Episode 5: Preparing Your QA Run with pquery
- How to create a rock-solid MySQL database backup & recovery strategy
- Percona Live Europe 2015 conference, tutorials schedule now available
- Percona Server 5.6.25-73.1 is now available
- How to obtain the MySQL version from an FRM file
- MySQL QA Episode 4: QA Framework Setup Time!
- MySQL QA Episode 3: How to use the debugging tool GDB
- TOI wsrep_RSU_method in PXC 5.6.24 and up
- Percona Server 5.5.44-37.3 is now available
- Percona Server 5.6.25-73.0 is now available
- Using Cgroups to Limit MySQL and MongoDB memory usage
June 2015
- Playing with Percona XtraDB Cluster in Docker
- Practical MySQL Performance Optimization (July 2 webinar)
- Tips for avoiding malware from a lesson learned
- Oracle license revenue and the MySQL ecosystem
- Percona XtraDB Cluster (PXC): How many nodes do you need?
- Percona Monitoring Plugins 1.1.5 release
- Q&A: High availability when using MySQL in the cloud
- Getting EXPLAIN information from already running queries in MySQL 5.7
- Update on the InnoDB double-write buffer and EXT4 transactions
- Speed up MySQL Queries GROUP BY with subselects
- Percona XtraDB Cluster: Quorum and Availability of the cluster
- Percona Live Europe 2015! Call for speakers; registration open
- Auditing MySQL with McAfee and MongoDB
- MaxScale: A new tool to solve your MySQL scalability problems
- High availability using MySQL in the cloud
- Percona XtraDB Cluster 5.6.24-25.11 is now available
- Optimizing Percona XtraDB Cluster for write hotspots
- innodb_buffer_pool_size – Is 80% of RAM the right amount?
- Percona TokuMXse 3.0.3-1.0-rc6 is now available
- New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7
May 2015
- MongoDB Community Open House: June 1 in NYC
- Percona XtraBackup 2.2.11 is now available
- MySQL 5.7 key features
- Storing time-series data with MongoDB and TokuMX
- MongoDB / TokuMX plugin for LinkBench (Part 1)
- Percona XtraBackup 2.3.1-beta1 is now available
- Percona security update: oCERT and SSL improvements
- MySQL QA Episode 2: Build a MySQL server – Git, Bazaar, Compiling & Build tools
- Percona Server 5.6.24-72.2 is now available
- Percona Server 5.5.43-37.2 is now available
- MongoDB with Percona TokuMXse – experimental build RC5 is available!
- MySQL indexing 101: a challenging single-table query
- Introducing email reports for Percona Cloud Tools!
- Percona Security Advisory CVE-2015-1027
- Peter Zaitsev hits the road for East Coast MySQL Meetup tour
- MongoDB’s flexible schema: How to fix write amplification
- Keep your MySQL data in sync when using Tungsten Replicator
- LinkBenchX: benchmark based on arrival request rate
April 2015
- Optimizer hints in MySQL 5.7.7 – The missed manual
- Generated (Virtual) Columns in MySQL 5.7 (labs)
- Test your knowledge: Percona XtraDB Cluster (PXC) quiz
- Indexing 101: Optimizing MySQL queries on a single table
- Percona Live & OpenStack Live 2015 wrap-up
- Considering Sharding with MySQL? Join my April 22 webinar. Questions welcome!
- Profiling MySQL queries from Performance Schema
- Checking table definition consistency with mysqldiff
- Why Percona Acquired Tokutek: by Peter Zaitsev
- Team Tokutek is proud to join Team Percona!
- Tokutek now part of the Percona family
- Percona Toolkit 2.2.14 is now available
- Staying ahead of MySQL operational problems at Percona Live
- Measuring the impact of tcpdump on Very Busy Hosts
- InnoDB locks and deadlocks with or without index for different isolation level
- pquery binaries with statically included client libs now available!
- More on OpenStack Live and our talks at OpenStack Summit Vancouver
- More on (transactional) MySQL metadata locks
- The cost of not properly managing your databases
- Illustrating Primary Key models in InnoDB and their impact on disk usage
- The value of MySQL Support
- MySQL shell prompt vs MongoDB shell prompt
March 2015
- Percona XtraBackup 2.2.10 for MySQL hot backups is now available (free!)
- Percona XtraDB Cluster 5.5.41-25.11 is now available
- Woz on your mind?’ Share your questions for Steve Wozniak during his Percona Live keynote!
- FoundationDB is acquired by Apple: My thoughts
- Yelp IT! A talk with 3 Yelp MySQL DBAs on Percona Live & more
- Calling all MySQL DBAs: How do you use Percona Toolkit?
- Choosing a good sharding key in MongoDB (and MySQL)
- Getting started guide for OpenStack contributors
- MySQL QA Episode 1: Bash/GNU Tools & Linux Upskill & Scripting Fun
- Free MySQL QA & Bash/Linux Training Series
- Deep dive into MySQL’s innochecksum tool
- Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7
- MySQL and geospatial programming: An introduction to GIS
- Easy query metrics with MySQL Performance Schema
- Advanced JSON to MySQL indexing
- Tools for Monitoring and Managing MySQL Replication
- What stopped MySQL? Tracing back signals sent to MySQL
- How to test if CVE-2015-0204 FREAK SSL security flaw affects you
- Steve ‘Woz’ Wozniak to speak at Percona Live MySQL Conference & Expo 2015
- Percona XtraDB Cluster 5.6.22-25.8 is now available
- Percona Server 5.6.23-72.1 is now available
- Percona Server 5.5.42-37.1 is now available
- Introducing ‘MySQL 101,’ a 2-day intensive educational track at Percona Live this April 15-16
- Improving Percona XtraDB Cluster SST startup with Google Compute Engine snapshots
- Emulating MySQL roles with the Percona PAM plugin and proxy users
February 2015
- 3 handy tools to remove problematic MySQL processes
- Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?
- Increasing Cloud Database Efficiency – Like Crows in a Closet
- Using MySQL Event Scheduler and how to prevent contention
- Is MySQL’s innodb_file_per_table slowing you down?
- MySQL community t-shirt contest for Percona Live 2015
- How to setup a PXC cluster with GTIDs (and have async slaves replicating from it!)
- More on MySQL 5.6 multi-threaded replication and GTIDs (and Feb. 25 webinar)
- Percona submits 7 talks for Vancouver OpenStack Summit (voting ends Feb. 23)
- Percona XtraBackup 2.2.9 is now available
- Indexing’ JSON documents for efficient MySQL queries over JSON data
- Percona XtraDB Cluster 5.6: a tale of 2 GTIDs
- TokuDB Table Optimization Improvements
- Online GTID rollout now available in Percona Server 5.6
- Percona Server 5.6.22-72.0 is now available
- TokuDB Hot Backup Now a MySQL Plugin
- A Tokutek Take on MongoDB v3.0
- The future of MySQL quality assurance: Introducing pquery
- Percona Live 2015 Lightning Talks, BoF submission deadline Feb. 13! And introducing "MySQL 101" program
- Faster fingerprints and Go packages for MySQL
January 2015
- OpenStack Live 2015: FAQs on the who, what, where, when, why & how
- TokuDB 7.5.5 is now available
- GHOST vulnerability (CVE-2015-0235) Percona response
- Multi-threaded replication with MySQL 5.6: Use GTIDs!
- Percona University: Back to school Feb. 12 in Raleigh, N.C.
- Percona Toolkit 2.2.13 is now available
- MySQL benchmarks on eXFlash DIMMs
- Using Percona Cloud Tools to solve real-world MySQL problems
- Mo’ Data, Mo’ Problems
- The MongoDB Speed-up & Slim-down Big Data Challenge
- Importing big tables with large indexes with Myloader MySQL tool
- Identifying Useful Info from MySQL Row-Based Binary Logs
- Announcing TokuMXse v1.0.0-rc.0
- Looking deeper into InnoDB’s problem with many row versions
- FOSDEM 2015: MySQL and Friends Community Dinner!
- Fractal Tree Greatness: The Nexus
- Hyper-threading -How does it double CPU throughput?
- Percona XtraBackup 2.2.8 is now available
- MySQL performance implications of InnoDB isolation modes
- Percona Live 2015 conference sessions announced!
- Percona Server 5.6.22-71.0 is now available
- Percona Server 5.5.41-37.0 is now available
- First TokuMXse performance numbers
- Managing data using open source technologies? Learn what’s hot in 2015!
- Django with time zone support and MySQL
- Getting mutex information from MySQL’s performance_schema
- Using YUM to install specific MySQL/Percona Server versions
- The MySQL Query Cache: How it works, plus workload impacts
2014 385
December 2014
- How small changes impact complex systems – MySQL example
- Diagnosing SST errors with Percona XtraDB Cluster for MySQL
- How well does your table fit in the InnoDB buffer pool in MySQL 5.6+?
- InnoDB crash recovery speed in MySQL 5.6
- Testing TokuDB’s Group Commit Algorithm Improvement
- File carving methods for the MySQL DBA
- Testing backup locks during Xtrabackup SST on Percona XtraDB Cluster
- Storing UUID Values in MySQL
- Making HAProxy 1.5 replication lag aware in MySQL
- Scaling TokuDB Performance with Binlog Group Commit
- InnoDB’s multi-versioning handling can be Achilles’ heel
- Yes, Virginia, There is Going to be a TokuMX Storage Engine for MongoDB 2.8
- OpenStack Live tutorials & sessions to bring OpenStack users up to speed
- MySQL Tutorials: A time to learn at Percona Live 2015
- Frohe Festtage Von Weinhem! (Or A Music-driven Holiday Light Display for MongoDB Hackers)
- Percona XtraBackup 2.2.7 is now available
- Reset MySQL root password without restarting MySQL (no downtime!)
- OpenStack Live 2015: Sneak peak of the April conference
- MySQL 5.6 Transportable Tablespaces best practices
- Application Cannot Open Another Connection to MySQL
- Streamlined Percona XtraDB Cluster (or anything) testing with Consul and Vagrant
- MySQL and OpenStack deep dive: Dec. 10 webinar
- Sneak peek at the Percona Live MySQL Conference & Expo 2015
- Auto-bootstrapping an all-down cluster with Percona XtraDB Cluster
- Tips from the trenches for over-extended MySQL DBAs
- Faster restarts for MySQL and Percona Server 5.6.21+
November 2014
- MySQL benchmarking: Know your baseline variance!
- Percona XtraDB Cluster 5.6.21-25.8 is now available
- (More) Secure local passwords in MySQL 5.6 and up
- Percona Server 5.6.21-70.1 is now available
- Schema changes in MySQL for OpenStack Trove users
- Google Compute Engine adds Percona XtraDB Cluster to click-to-deploy process
- Sys Schema for MySQL 5.6 and MySQL 5.7
- How a set of queries can be killed in MySQL using Percona Toolkit’s pt-kill
- Avoiding MySQL ALTER table downtime
- MySQL’s INNODB_METRICS table: How much is the overhead?
- Percona Toolkit 2.2.12 is now available
- Typical misconceptions on Galera Replication for MySQL
- RDS for Aurora unveiled at AWS re:Invent
- Q&A: Percona XtraDB Cluster as a MySQL HA solution for OpenStack
- Optimizing MySQL for Zabbix
- Percona Live London 2014 Wrap Up
- Log rotate and the (deleted) MySQL log file mystery
- Percona Live MySQL Conference Call for Proposals closes Nov. 16
- OpenStack Live Call for Proposals closes November 16
- Impressions from MongoDB Day London 2014
- Percona at AWS re:Invent and events around the world
- OpenStack MySQL HA Solution = Percona XtraDB Cluster: Webinar
- Data inconsistencies on MySQL replicas: Beyond pt-table-checksum
- Percona XtraBackup 2.2.6 is now available
- Percona Server 5.6.21-70.0 is now available
- Backup and restore of MySQL to OpenStack Swift
October 2014
- Get a handle on your HA at Percona Live London 2014
- Facebook MySQL database engineers ready for Percona Live London 2014
- MySQL and Openstack deep dive talk at OpenStack Paris Summit (and more!)
- How to deal with MySQL deadlocks
- MySQL & Friends Devroom FOSDEM 2015
- MySQL 5.6 Full Text Search Throwdown: Webinar Q&A
- MySQL community set to meet at Percona Live London 2014
- Percona XtraDB Cluster: How to run a 2-node cluster on a single server
- Autumn: A season of MySQL-related conferences. Here’s my list
- Innodb transaction history often hides dangerous ‘debt’
- Oct 22 Webinar: What’s New in TokuDB 7.5
- Percona Toolkit for MySQL with MySQL-SSL Connections
- Benchmarking Presentation at Percona Live London 2014
- How to close POODLE SSLv3 security flaw (CVE-2014-3566)
- Rackspace doubling-down on open-source databases, Percona Server
- Recover orphaned InnoDB partition tablespaces in MySQL
- How to avoid hash collisions when using MySQL’s CRC32 function
- MySQL compression: Compressed and Uncompressed data size
- MySQL Replication: ‘Got fatal error 1236’ causes and cures
- MySQL ring replication: Why it is a bad option
- Percona Server 5.6.21-69.0 is now available
- Percona Server 5.5.40-36.1 is now available
- Percona XtraBackup 2.2.5 now available (free MySQL hot backup software)
- Oct 9 Webinar: Get More Out of MongoDB With TokuMX 2.0
- HAProxy: Give me some logs on CentOS 6.5!
September 2014
- Announcing TokuMX v2.0
- Percona Toolkit 2.2.11 for MySQL is now available
- Fast Updates : Coming Soon in TokuMX v2.0
- MySQL & OpenStack: How to overcome issues as your dataset grows
- Bash Bug’ giving you Shellshock? CVE-2014-6271 update
- Logical MySQL backup tool mydumper 0.6.2 now available
- Looking forward to Oracle OpenWorld 2014; visit us at Booth 2413!
- TokuDB Read Free Replication : Details and Use Cases
- More then 1000 columns – get transactional with TokuDB
- Percona Server, OpenStack and the Tesora DBaaS Platform
- TokuDB v7.5 Read Free Replication : The Benchmark
- How to scale big data applications using MySQL sharding frameworks
- TokuMX 2.0 preview and bug hunt
- Should you migrate to Percona XtraDB Cluster?
- MySQL Upgrade Best Practices
- Announcing TokuDB v7.5: Read Free Replication
- Managing big data? Say ‘hello’ to HP Vertica
- Syncing MySQL slave table with pt-online-schema-change
- Percona Live London: Top Ten reasons to attend Nov. 3-4
- OpenStack Live 2015: Call for speakers open through November 9
- Percona XtraBackup 2.2.4 is now available
- OpenStack users shed light on Percona XtraDB Cluster deadlock issues
- Generating test data from the mysql> prompt
- Multi-Valued INSERTs, AUTO_INCREMENT & Percona XtraDB Cluster
- How to calculate the correct size of Percona XtraDB Cluster’s gcache
- Percona XtraDB Cluster 5.5.39-25.11 is now available
- Using MySQL 5.6 Global Transaction IDs (GTIDs) in production: Q&A
- MySQL 101: Monitor Disk I/O with pt-diskstats
- Migrating to Percona XtraDB Cluster 2014 edition: Sept. 10 MySQL webinar
- Reducer.sh – A powerful MySQL test-case simplification/reducer tool
- Using sysbench 0.5 for performing MySQL benchmarks
- Percona XtraDB Cluster 5.6.20-25.7 is now available
- Galera replication – how to recover a PXC cluster
August 2014
- Galera data on Percona Cloud Tools (and other MySQL monitoring tools)
- Percona Server 5.6.20-68.0 is now available
- Percona Server 5.5.39-36.0 is now available
- OpenStack Trove Day 2014 Recap: MySQL and DBaaS
- Trawling the binlog with FlexCDC and new FlexCDC plugins for MySQL
- mysqld_multi: How to run multiple instances of MySQL
- OpenStack’s Trove: The benefits of this database as a service (DBaaS)
- When (and how) to move an InnoDB table outside the shared tablespace
- A closer look at the MySQL ibdata1 disk space issue and big tables
- How to use MySQL Global Transaction IDs (GTIDs) in production
- 5 great new features from Percona Cloud Tools for MySQL
- Measuring failover time for ScaleArc load balancer
- Getting my hands dirty on an OpenStack lab
- Make a difference! See the world! Speak at Percona Live London; Santa Clara!
- Benchmarking IBM eXFlash™ DIMM with sysbench fileio
- Release Candidate Packages for Red Hat Enterprise Linux 7 and CentOS 7 now available
- Percona Toolkit 2.2.10 is now available
- Explaining Ark Part 4: Fixing Majority Write Concern
- An Updated Description of Clustering Keys for TokuDB
- New in Percona Replication Manager: Slave resync, Async stop
- Q&A: Putting MySQL Fabric to use
- Advanced MySQL Query Tuning (Aug. 6) and MySQL 5.6 Performance Schema (Aug. 13) webinars
- New TokuMX Meetup Groups Formed
- Paris OpenStack Summit Voting – Percona Submits 16 MySQL Talks
July 2014
- MariaDB: Selective binary logs events
- Percona Server 5.1.73-14.12 is now available
- Examining the TokuDB MySQL storage engine file structure
- Explaining Ark Part 3: Why Data May Be Lost on a Failover
- Prevent MySQL ERROR 1040 (00000): Too many connections
- What I learned while migrating a customer MySQL installation to Amazon RDS
- Monitoring MySQL flow control in Percona XtraDB Cluster 5.6
- Explaining Ark Part 2: How Elections and Failover Currently Work
- Putting MySQL Fabric to Use: July 30 webinar
- DBaaS, OpenStack and Trove 101: Introduction to the basics
- Why TokuDB hates Transparent HugePages
- Reference architecture for a write-intensive MySQL deployment
- Explaining Ark Part 1: The Basics
- Percona XtraDB Cluster 5.6.19-25.6 is now available
- Percona Monitoring Plugins 1.1.4 release
- A schema change inconsistency with Galera Cluster for MySQL
- Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue
- Introducing Ark: A Consensus Algorithm For TokuMX and MongoDB
- Q&A: Even More Deadly Mistakes of MySQL Development
- High Availability with mysqlnd_ms | Percona XtraDB Cluster
- TokuDB tips: MySQL backups
- Simple MySQL Master HA with mysqlnd_ms
- Managing shards of MySQL databases with MySQL Fabric
- Percona Toolkit 2.2.9 is now available
- TokuDB gotchas: slow INFORMATION_SCHEMA TABLES
- Check for MySQL slave lag with Percona Toolkit plugin for Tungsten Replicator
- TIMESTAMP Columns, Amazon RDS 5.6, and You
- Looking out for max values in integer-based columns in MySQL
- Failover with the MySQL Utilities: Part 2 – mysqlfailover
- Percona Server 5.5.38-35.2 is now available
- Using MySQL triggers and views in Amazon RDS
- Percona Server 5.6.19-67.0 with TokuDB (GA) now available
June 2014
- How to avoid even more of the common (but deadly) MySQL development mistakes
- Failover with the MySQL Utilities – Part 1: mysqlrpladmin
- Why a Partitioned Collection Cannot Be Sharded
- Percona Server with TokuDB (beta): Installation, configuration
- TokuMX Compression & Performance Innovation Awards @ MongoDB World 2014
- Why %util number from iostat is meaningless for MySQL capacity planning
- Sysbench Benchmarking of Tesora’s Database Virtualization Engine
- Getting to know TokuDB for MySQL
- TokuMX @ MongoDB World 2014
- How to setup Docker for Percona ClusterControl and add existing Percona XtraDB Cluster
- Use TokuMX Partitioned Collections in Place of TTL Indexes
- Using UDFs for geo-distance search in MySQL
- Announcing TokuMX v1.5
- "How to monitor MySQL performance" with Percona Cloud Tools: June 25 webinar
- MySQL Backup Service from Percona
- Best Practices for Partitioned Collections and Tables in TokuDB and TokuMX
- mydumper [less] locking
- Announcing Percona XtraBackup 2.2.3 GA
- Percona Server 5.6.17-66.0 is now available
- Measure the impact of MySQL configuration changes with Percona Cloud Tools
- Understanding the Performance Characteristics of Partitioned Collections
- Architecture and Design of MySQL-powered applications: June 11 Webinar
- Using MySQL 5.6 Performance Schema in multi-tenant environments
- June 11 Webinar: Comparing MongoDB and TokuMX Replication
- Why TokuMX Changed MongoDB’s Oplog Format for Operations
- The Difference Between TokuMX Partitioning and Sharding
- Why did we develop percona-agent in Go?
- Percona Toolkit 2.2.8 is now available
- Do not trust vmstat IOwait numbers
- Percona Server 5.5.37-35.1 is now available
- Using InfiniDB MySQL server with Hadoop cluster for data analytics
May 2014
- High Availability with MySQL Fabric: Part II
- Introducing Partitioned Collections for MongoDB Applications
- How MySQL ‘queries’ and ‘questions’ are measured
- From zero to full visibility of MySQL in 3 minutes with Percona Cloud Tools
- Location for InnoDB tablespace in MySQL 5.6.6
- Installing Percona XtraDB Cluster 5.6 with the Docker open-source engine
- Introducing the 3-Minute MySQL Monitor
- TokuMX Compared to MongoDB Using a Specific Common Use Case
- May 29 Webinar: Get More Out of MongoDB with TokuMX
- A technical WebScaleSQL review and comparison with Percona Server
- MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training)
- MongoDB World TokuMX™ Innovation Awards: Call for Nominations
- Database auditing alternatives for MySQL
- Errant transactions: Major hurdle for GTID-based failover in MySQL 5.6
- MongoDB World "Scale Up & Slim Down with TokuMX" Breakfast Meet-up
- Benchmark: SimpleHTTPServer vs pyclustercheck (twisted implementation)
- Introduction to the Percona Server Audit Log feature
- High Availability with MySQL Fabric: Part I | Percona
- Why ALTER TABLE runs faster on Percona Server 5.5 vs. MySQL 5.5
- Tips on benchmarking Go + MySQL
- max_allowed_packet and binary log corruption in MySQL
- Using Percona Server 5.6 with the Docker open-source engine
- Practical MySQL performance optimization: May 14 Webinar
- Thoughts on Small Datum – Part 3
- GTIDs in MySQL 5.6: New replication protocol; new ways to break replication
- Percona XtraDB Cluster 5.5.37-25.10 is now available
- Doing a rolling upgrade of Percona XtraDB Cluster from 5.5 to 5.6
- Percona XtraBackup 2.2.2 beta release is now available
- May 13 Webinar: Build Better Time-Series Apps with MongoDB
- MySQL Audit Plugin now available in Percona Server 5.5 and 5.6
- Percona XtraBackup 2.1.9 is now available
- Percona Server 5.6.17-65.0 is now available
- Percona Server 5.5.37-35.0 is now available
- Row-based replication, MySQL 5.6 upgrades and temporal data types
- Exploring message brokers
- The top 9 Percona Toolkit tools that can make your job easier: May 7 Webinar
- How to identify and cure MySQL replication slave lag
- Maybe You Should Try Taking a Walk in My Shoes
- Parallel Query for MySQL with Shard-Query
April 2014
- Galera 3.5 for Percona XtraDB Cluster 5.6 is now available
- ScaleArc: Real-world application testing with WordPress (benchmark test)
- Thoughts on Small Datum – Part 2
- OOM relation to vm.swappiness=0 in new kernel
- Managing farms of MySQL servers with MySQL Fabric
- Encrypted and incremental MySQL backups with Percona XtraBackup
- Percona Live 2014 behind; MySQL ahead
- Percona University @Montevideo, FISL & São Paulo MySQL Meetup
- Percona Live 2014 Impressions
- Using Apache Hadoop and Impala together with MySQL for data analysis
- Percona Software in Ubuntu 14.04 LTS (Trusty Tahr) release
- Thoughts on Small Datum – Part 1
- April 24 Webinar – MongoDB Clusters: Tips, Tricks, Manage and Automate
- How to find bugs in MySQL
- Simplifying Database Management for Big Data
- Open Source Appreciation Day’ draws OpenStack, MySQL and CentOS faithful
- How TokuMX Secondaries Work in Replication
- percona-millipede – Sub-second replication monitor
- Advisory on Heartbleed (CVE-2014-0160) for Percona’s customers and users
- Percona Live MySQL Conference Highlights
- How Tokutek uses the Random Query Generator framework to test TokuDB
- Heartbleed: Separating FAQ From FUD
- OpenSSL heartbleed CVE-2014-0160 – Data leaks make my heart bleed
- Why TokuDB does not use the ‘uint3korr’ function
- Optimizing MySQL Performance: Choosing the Right Tool for the Job
- Percona Live 2014 Recap
- Facebook’s Yoshinori Matsunobu on MySQL, WebScaleSQL & Percona Live
- Uninitialized data in the TokuDB recovery log
- On TokuMX Oplog, Tailable Cursors, and Concurrency
- How to add an existing Percona XtraDB Cluster to Percona ClusterControl
March 2014
- ScaleArc: Benchmarking with sysbench
- Percona XtraBackup 2.2.1 alpha release is now available
- Innodb redo log archiving
- On TokuMX (and MongoDB) Replication and Transactions
- Percona Server 5.6.16-64.2 with TokuDB engine Beta is now available
- Lock Escalation and Big Transactions in TokuDB and TokuMX
- A conversation with 5 Facebook MySQL gurus
- Comparing a TokuMX and MongoDB Oplog Entry
- Explosive OpenStack growth at the Percona Live MySQL Conference & Expo
- Database security: Why should you review yours?
- Percona Server 5.5.36-34.2 is now available
- Percona Server 5.6.16-64.2 is now available
- 7 Key MySQL clustering technologies – A joint webinar with 451 Research
- Creating GEO-enabled applications with MySQL 5.6
- Why TokuMX Replication Differs from MongoDB Replication
- Notes from the Newb
- Percona Monitoring Plugins 1.1.3. Addressed CVE-2014-2569.
- Percona XtraDB Cluster 5.6.15-25.5 is now available
- How to log slow queries on Slave in MySQL 5.0 with pt-query-digest
- Great Speakers, Fun, and Insights at Percona Live MySQL Conference
- Hardening your Cacti setup
- Percona Server with TokuDB: Packing 15TB into local SSDs
- My Favorite MongoDB Replication Feature: Crash Safety
- Percona Server 5.6.16-64.1 is now available
- Percona Server 5.5.36-34.1 is now available
- Big trouble with zero-length character columns in TokuDB
- MySQL Slow Query Log: Tools and Tips
- Percona Monitoring Plugins 1.1.2, now with Amazon RDS support
- March 20 Webinar: How to Scale MySQL for Big Data Applications
- Open Source Appreciation Day at the Percona Live MySQL Conference
- Monitoring MySQL with MONyog
- Announcing TokuDB v7.1.5
- Introducing backup locks in Percona Server
- Percona Server 5.6.16-64.0 is now available
- New mydumper 0.6.1 release offers performance and usability features
- Percona Server 5.5.36-34.0 is now available
- Q&A: Common (but deadly) MySQL Development Mistakes
- Percona XtraBackup 2.1.8 is now available
- Many-table joins in MySQL 5.6
- Tokutek and Percona Live 2014
- Engineer duo from Google, LinkedIn join again for InnoDB talks
- Percona Toolkit 2.1.11 is now available
- Oracle’s Mats Kindahl to weave MySQL Fabric into Percona Live session
- Percona Server 5.6.16-64.0 with TokuDB engine now available
February 2014
- How to avoid common (but deadly) MySQL development mistakes
- How rows_sent can be more than rows_examined?
- March 5 Webinar: Which MongoDB Distribution Should You Use? AOL Benchmark
- DBA 101: Sometimes forgotten functionality in the MySQL client
- ClusterControl: Percona XtraDB Cluster Monitoring
- How to monitor ALTER TABLE progress in MySQL
- What’s new in TokuMX 1.4, Bonus Part 6: Faster count queries
- Quick review of InfiniDB 4
- Percona Toolkit 2.2.7 is now available
- The MySQL ARCHIVE storage engine – Alternatives
- Before every release: A glimpse into Percona XtraDB Cluster CI testing
- What’s new in TokuMX 1.4, Part 5: Faster chunk migrations
- What’s new in TokuMX 1.4, Part 4: Smaller, faster sharded clusters
- Percona XtraDB Cluster 5.6.15-25.4 is now available
- What’s new in TokuMX 1.4, Part 3: Optimized updates
- You spoke, we listened: Percona Cloud Tools accelerates query reviews
- What’s new in TokuMX 1.4, Part 2: Partitioned oplog
- Oracle’s Morgan Tocker opens up about MySQL development, MySQL 5.7
- Don’t worry about embedding large arrays in your MongoDB documents
- How to create a new Percona XtraDB Cluster with ClusterControl
- TokuMX vs. MongoDB : Sharding Balancer Performance
- What’s new in TokuMX 1.4, Part 1: Primary keys
- Using Percona rsync repositories to set up the local CentOS mirror
- ClusterControl: Percona XtraDB Cluster Monitoring – Webinar
- Changing an async slave of a PXC cluster to a new Master using 5.6 and GTID
- Introducing TokuMX 1.4: Major improvements to MongoDB sharding and replication
- February 20 Webinar: MongoDB and Sharding for Scalability – Tips & Tricks
- Keynote Speakers for Percona Live MySQL Conference 2014 and $5 Expo Only Passes
- Migrating off MongoDB? Try TokuMX First
- 8 common (but deadly) MySQL operations mistakes and how to avoid them
- PERFORMANCE_SCHEMA vs Slow Query Log
- How TokuMX was Born
- WITHer Recursive Queries?
- Generating Test Data for MySQL tables
- Followup questions to ‘What’s new in Percona XtraDB Cluster 5.6’ webinar
- Calvin Sun on MySQL at Twitter, Percona Live 2014 and Facebook
- Analyze MySQL Query Performance with Percona Cloud Tools: Feb. 12 webinar
- 16000 active connections – Percona Server continues to work when others die
- ClusterControl for Percona XtraDB Cluster Improves Management and Monitoring
- The Effects of Database Heap Storage Choices in MongoDB
- Quick installation guide for Percona Cloud Tools for MySQL
- Percona Toolkit collection: pt-visual-explain
January 2014
- Percona XtraDB Cluster 5.6 GA release now available
- February 6 Webinar: Transactions and MongoDB – Ways To Have It All
- Percona Live MySQL Conference and Expo 2014: Things I’m looking forward to
- Percona Server: Thread Pool Improvements for Transactional Workloads
- MySQL performance optimization: Don’t guess! Measure with Percona Cloud Tools
- MySQL Performance Tuning Settings
- Looking to upgrade to MySQL 5.6? Check out my webinar on Jan 29!
- FOSDEM 2014 MySQL Devroom, Community Dinner in Brussels this Saturday!
- MySQL server memory usage troubleshooting tips
- Percona XtraBackup 2.1.7 is now available
- Percona Server: Improve Scalability with Percona Thread Pool
- FOSDEM 2014 – MySQL & Friends Devroom Event in Brussels
- Past, present and future of MySQL and variants: linux.conf.au 2014 video
- January 28 Webinar: Get More Out of MySQL with TokuDB
- Beware of MySQL 5.6 Server UUID when Cloning Slaves
- Percona is hiring a Go back-end engineer
- Percona Replication Manager (PRM) now supporting 5.6 GTID
- keepalived with reader and writer VIPs for Percona XtraDB Cluster
- FOSDEM 2014: MySQL And Friends Community Dinner
- Analyzing WordPress MySQL queries with Query Analytics
- Percona Cloud Tools January 2014 status update
- Percona Live MySQL Conference Sessions Announced
- Upcoming Webinar: What’s new in Percona XtraDB Cluster 5.6
- InnoDB file formats: Here is one pitfall to avoid
- Webinars: Common (but deadly) MySQL mistakes
- The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB
- Percona Cloud Tools: Making MySQL performance easy
- January 14 Webinar: Get More Out of MongoDB with TokuMX
- Finding a good IST donor in Percona XtraDB Cluster 5.6
- Increasing slow MySQL query performance with the parallel query execution
- The ARCHIVE Storage Engine – does it do what you expect?
- Multiple column index vs multiple indexes with MySQL 5.6
- How to recover table structure from .frm files with MySQL Utilities