Buy Percona ServicesBuy Now!

Percona XtraDB Cluster, MySQL Asynchronous Replication and log-slave-updates

 | March 19, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Replication

Asynchronous Replication

Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned. MySQL asynchronous replication and Galera replication interactions are complicated due to the number of factors involved (Galera replication vs. asynchronous replication, replication filters, and row-based vs. statement-based replication). So […]

Read More

How to Speed Up Pattern Matching Queries

 | March 19, 2018 |  Posted In: Insight for DBAs, MySQL

pattern matching queries

From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]

Read More

Percona Server for MongoDB 3.2.19-3.10 Is Now Available

 | March 16, 2018 |  Posted In: Events and Announcements, MongoDB, Percona Server for MongoDB, Percona Software

Percona Server for MongoDB 3.4

Percona announces the release of Percona Server for MongoDB 3.2.19-3.10 on March 16, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.2 Community Edition. It supports MongoDB 3.2 protocols and drivers. […]

Read More

Percona Toolkit 3.0.8 Is Now Available

 | March 16, 2018 |  Posted In: Events and Announcements, MySQL, Percona Toolkit

Percona announces the release of Percona Toolkit 3.0.8 on March 16, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona […]

Read More

This Week in Data with Colin Charles 32: Stack Overflow Developer Survey, SCALE16x and Interesting MySQL 8 Version Numbers

 | March 16, 2018 |  Posted In: MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, PostgreSQL, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. SCALE16x is over. Percona had a large showing — both Peter Zaitsev & myself had talks, and the booth in the expo hall saw Rick Golba, Marc Sherwood, and Dave Avery also pop by. The lead […]

Read More

Verifying Query Performance Using ProxySQL

 | March 15, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management, ProxySQL

Query Performance Using ProxySQL

In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]

Read More

Percona Live 2018 Featured Talk: MongoDB for a High Volume Logistics Application with Eric Potvin

 | March 15, 2018 |  Posted In: MongoDB, Percona Live

Eric Potvin Shipwire

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post highlights Eric Potvin, Software Engineer at Shipwire. His talk is titled MongoDB […]

Read More

Saw Percona at SCaLE 16x? Come See Even More at Percona Live 2018!

 | March 14, 2018 |  Posted In: Amazon Aurora, Amazon RDS, MariaDB, MongoDB, MySQL, Percona Live

Did you see Percona at SCaLE 16x? I spent a couple of days there learning about open source software, databases, and other interesting topics. You can get even more open source database information at Percona Live 2018. SCaLE is the largest community-run open-source and free software conference in North America. It is held annually in […]

Read More

Adding Custom Graphs and Dashboards to Percona Monitoring and Management

 | March 14, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management

PMM custom graphs

In this blog post, we’ll look at how to create PMM custom graphs and dashboards to track what you need to see in your database. Percona Monitoring and Management (PMM)‘s default set of graphs is pretty complete: it covers most of the stuff a DBA requires to fully visualize database servers. However, sometimes custom information […]

Read More

Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.