EmergencyEMERGENCY? Get 24/7 Help Now!

Updating InnoDB Table Statistics Manually

 | September 11, 2017 |  Posted In: Database Monitoring, InnoDB, Insight for DBAs, Insight for Developers, MySQL

InnoDB Tables

In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Read More

This Week in Data with Colin Charles #5: db tech showcase and Percona Live Europe

 | September 8, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MyRocks, MySQL, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe 2017 in Dublin Have you registered for Percona Live Europe Dublin? We have announced some awesome keynotes, and our sponsor list is growing (and we’re always looking for more!). There will also be […]

Read More

Upcoming Webinar Thursday, September 7: Using PMM to Troubleshoot MySQL Performance Issues

 | September 6, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, Technical Webinars

Percona Monitoring and Management

Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   Successful applications often become limited by MySQL performance. Michael will show you how to get great MySQL performance […]

Read More

Revenge of Ransomware! MongoDB Security in the News Again . . .

 | September 5, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Security

MongoDB Security

A new set of MongoDB attacks and data breaches struck businesses this weekend, mirroring the attacks that hit back in January and putting MongoDB security back into the spotlight. Like the last set, this new attack strategy focused on ransomware that demanded a paid ransom to unlock hijacked data. As with many security breaches, the attack was preventable – […]

Read More

Percona Live Europe 2017 Sneak Peek Schedule Up Now! See Available Sessions!

 | August 3, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MySQL, Percona Live

Percona Live Europe 2017

We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel. The theme of Percona Live Europe 2017 is Championing Open Source Databases, with sessions on MySQL, MariaDB, MongoDB and […]

Read More

Tracing MongoDB Queries to Code with Cursor Comments

 | June 21, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB

Tracing MongoDB Queries

In this short blog post, we will discuss a helpful feature for tracing MongoDB queries: Cursor Comments. Cursor Comments Much like other database systems, MongoDB supports the ability for application developers to set comment strings on their database queries using the Cursor Comment feature. This feature is very useful for both DBAs and developers for quickly […]

Read More

Percona Monitoring and Management 1.1.4 is Now Available

 | May 29, 2017 |  Posted In: Database Monitoring, Docker, Events and Announcements, Insight for Developers, MariaDB, MongoDB, MySQL, Orchestrator, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, Percona Software, PMM, Prometheus, ProxySQL

Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017. For installation instructions, see the Deployment Guide. This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface.

Read More

Percona-Lab/mongodb_consistent_backup: 1.0 Release Explained

 | May 10, 2017 |  Posted In: Backups, Insight for DBAs, Insight for Developers, MongoDB

mongodb_consistent_backup

In this blog post, I will cover the Percona-Lab/mongodb_consistent_backup tool and the improvements in the 1.0.1 release of the tool. Percona-Lab/mongodb_consistent_backup mongodb_consistent_backup is a tool for performing cluster consistent backups on MongoDB clusters or single-replica sets. This tool is open source Python code, developed by Percona and published under our Percona-Lab GitHub repository. Percona-Lab is […]

Read More

Percona University in Europe May 9 and May 11

 | May 2, 2017 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona University

Percona University

In 2013 we started Percona University, which consists of technology discussion events held in different cities around the world. The next installments of Percona University in Europe are next week when I fly there for Percona University Berlin (May 9) and Percona University Budapest (May 11). Both events are free to attend, and you are […]

Read More

Percona Live 2017: Deploying MongoDB on Public Clouds

 | April 26, 2017 |  Posted In: Cloud and NoSQL, Insight for DBAs, Insight for Developers, Percona Live

MongoDB on Public Clouds

Today at Percona Live 2017, the afternoon is jam-packed with open source technology lectures filled with community members eager for the latest on the best strategies – including how you should deploy MongoDB on public clouds. Dharshan Rangegowda (CEO of ScaleGrid) discussed deploying MongoDB on public clouds. ScaleGrid provides a fully managed Database-as-a-Service (DBaaS) solution […]

Read More