EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Point in Time Recovery the Right Way

 | October 23, 2017 |  Posted In: Backups, GTID, MySQL, Replication

MySQL Point In Time Recovery

In this blog, I’ll look at how to do MySQL point in time recovery (PITR) correctly. Sometimes we need to restore from a backup, and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans, when for example you accidentally drop a table/database or run […]

Read More

Percona Monitoring and Management 1.4.0 Is Now Available

 | October 20, 2017 |  Posted In: Events and Announcements, MongoDB, MySQL, open source databases, Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.4.0. This release introduces the support of external Prometheus exporters so that you can create dashboards in the Metrics monitor even for the monitoring services other than those provided with PMM client packages. To attach an existing external Prometheus exporter, run pmm-admin add external:metrics NAME_OF_EXPORTER URL:PORT. The list of […]

Read More

Percona Blog Poll: How Do You Currently Host Applications and Databases?

 | October 19, 2017 |  Posted In: Aurora RDS, Cloud and MySQL, Cloud and NoSQL, Database Poll, Insight for DBAs, Insight for Developers, MongoDB, MySQL

Host applications and databases

Percona latest blog poll asks how you currently host applications and databases. Select an option below, or leave a comment to clarify your deployment! With the increased need for environments that respond more quickly to changing business demands, many enterprises are moving to the cloud and hosted deployments for applications and software in order to […]

Read More

How to Choose the MySQL innodb_log_file_size

 | October 18, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

innodb_log_file_size

In this blog post, I’ll provide some guidance on how to choose the MySQL innodb_log_file_size. Like many database management systems, MySQL uses logs to achieve data durability (when using the default InnoDB storage engine). This ensures that when a transaction is committed, data is not lost in the event of crash or power loss. MySQL’s […]

Read More

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

and  | October 18, 2017 |  Posted In: Insight for DBAs, MySQL, open source databases, Technical Webinars

Indexes

Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now Proper indexing is key to database performance. Finely tune your query writing and database performance with […]

Read More

A Mystery with open_files_limit

 | October 12, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Server

open_files_limit

In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL. MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able […]

Read More

Percona Monitoring and Management 1.3.2 Is Now Available

 | October 11, 2017 |  Posted In: Events and Announcements, MongoDB, MySQL, open source databases, Percona Monitoring and Management

Percona announces the release of Percona Monitoring and Management 1.3.2. This release only contains bug fixes related to usability. For install and upgrade instructions, see Deploying Percona Monitoring and Management. Bug fixes PMM-1529: When the user selected “Today”, “This week”, “This month” or “This year” range in Metrics Monitor and clicked the Query Analytics button, the QAN […]

Read More

Webinar Wednesday, October 11, 2017: Percona Monitoring and Management (PMM) Demonstration

 | October 10, 2017 |  Posted In: MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Technical Webinars

Percona Monitoring and Management

Join Percona’s Product Manager Michael Coburn as he presents a Percona Monitoring and Management (PMM) Demonstration on Wednesday, October 11, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now How can you optimize database performance if you can’t see what’s happening? Percona Monitoring and Management (PMM) is a free, open source database troubleshooting […]

Read More

MySQL, Percona Server for MySQL and MariaDB Default Configuration Differences

 | October 9, 2017 |  Posted In: InnoDB, Insight for DBAs, MariaDB, MySQL

MySQL and MariaDB Default Configuration

In this blog post, I’ll discuss some of the MySQL and MariaDB default configuration differences, focusing on MySQL 5.7 and MariaDB 10.2. Percona Server for MySQL uses the same defaults as MySQL, so I will not list them separately. MariaDB Server is a general purpose open source database, created by the founders of MySQL. MariaDB […]

Read More

This Week in Data with Colin Charles 9: Oracle OpenWorld and Percona Live Europe Post Mortem

 | October 6, 2017 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, open source databases, 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. This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and upcoming appearances. Oracle OpenWorld happened in San Francisco this past week, and […]

Read More