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

Webinar Wednesday, October 18, 2017: How to Scale with MongoDB

and  | October 17, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MongoDB

Scale with MongoDB

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In this webinar, we will talk about how to scale with MongoDB, up to thousands of writes and reads per second. What are […]

Read More

This Week in Data with Colin Charles 10: MariaDB and Upcoming Appearances

 | October 13, 2017 |  Posted In: MariaDB, MongoDB, open source databases

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Beyond spending time getting ready for Velocity and Open Source Summit Europe this week, there was some feature testing this week that compared MySQL and MariaDB. Naturally, a long report/blog is coming soon. Stay tuned. […]

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