On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high [&]

The post Q&A: Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs Webinar appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/qa-percona-xtradb-cluster-proxysql-high-availability/

On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high [&]

The post Q&A: Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs Webinar appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/qa-percona-xtradb-cluster-proxysql-high-availability/

On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar experience. We tried answering some of your high [&]

The post Q&A: Percona XtraDB Cluster 5.7 and ProxySQL for Your High Availability Needs Webinar appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/qa-percona-xtradb-cluster-proxysql-high-availability/

Recently I worked on one customer issue that I would describe as slave performance too slow. During a quick analysis, Ive found that the replication slave SQL thread cannot keep up while processing row-based events from the masters binary log. For example: [crayon-5aeb9fbaec0ea724830671/] The processlist state for the SQL thread can be one of the following: Reading [&]

The post Causes and Workarounds for Slave Performance Too Slow with Row-Based Events appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/slave-performance-too-slow-with-row-based-events-causes-and-workarounds/

Recently I worked on one customer issue that I would describe as slave performance too slow. During a quick analysis, Ive found that the replication slave SQL thread cannot keep up while processing row-based events from the masters binary log. For example: [crayon-5aef650f85662300585333/] The processlist state for the SQL thread can be one of the following: Reading [&]

The post Causes and Workarounds for Slave Performance Too Slow with Row-Based Events appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/slave-performance-too-slow-with-row-based-events-causes-and-workarounds/

Recently I worked on one customer issue that I would describe as slave performance too slow. During a quick analysis, Ive found that the replication slave SQL thread cannot keep up while processing row-based events from the masters binary log. For example: [crayon-5aeb9fbaec0ea724830671/] The processlist state for the SQL thread can be one of the following: Reading [&]

The post Causes and Workarounds for Slave Performance Too Slow with Row-Based Events appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/03/slave-performance-too-slow-with-row-based-events-causes-and-workarounds/

In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for building ProxySQL. Why would you need to rewrite a query? [&]

The post ProxySQL Query Rewrite Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/02/proxysql-query-rewrite-use-case/

In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for building ProxySQL. Why would you need to rewrite a query? [&]

The post ProxySQL Query Rewrite Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/02/proxysql-query-rewrite-use-case/

In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for building ProxySQL. Why would you need to rewrite a query? [&]

The post ProxySQL Query Rewrite Use Case appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/02/proxysql-query-rewrite-use-case/

In this blog post, well look at how MongoDB rollback works during replicaset failovers. In recent versions, MongoDB has provided lots of features related to replicaset and automatic failover. When it comes to failover, the next question that arises is “How does MongoDB ROLLBACK work during replicaset failover?” If a PRIMARY member (say node A) stepped [&]

The post MongoDB Rollback in replicaset appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/mongodb-rollback-in-replicaset/

In this blog post, well look at how MongoDB rollback works during replicaset failovers. In recent versions, MongoDB has provided lots of features related to replicaset and automatic failover. When it comes to failover, the next question that arises is “How does MongoDB ROLLBACK work during replicaset failover?” If a PRIMARY member (say node A) stepped [&]

The post MongoDB Rollback in replicaset appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/mongodb-rollback-in-replicaset/

In this blog post, well look at how MongoDB rollback works during replicaset failovers. In recent versions, MongoDB has provided lots of features related to replicaset and automatic failover. When it comes to failover, the next question that arises is “How does MongoDB ROLLBACK work during replicaset failover?” If a PRIMARY member (say node A) stepped [&]

The post MongoDB Rollback in replicaset appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/mongodb-rollback-in-replicaset/

Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production (Part 3) on Thursday, May 3, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment [&]

The post Webinar Thursday May 3, 2018: Running MongoDB in Production (Part 3) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/webinar-thursday-may-3-2018-running-mongodb-in-production-part-3/

Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production (Part 3) on Thursday, May 3, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment [&]

The post Webinar Thursday May 3, 2018: Running MongoDB in Production (Part 3) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/webinar-thursday-may-3-2018-running-mongodb-in-production-part-3/

Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production (Part 3) on Thursday, May 3, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment [&]

The post Webinar Thursday May 3, 2018: Running MongoDB in Production (Part 3) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/webinar-thursday-may-3-2018-running-mongodb-in-production-part-3/

Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, Ill be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup. Interestingly enough, even though it is totally different from OLTP engines, [&]

The post ClickHouse Meetup in Salt Lake City appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/clickhouse-meetup-in-salt-lake-city/

Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, Ill be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup. Interestingly enough, even though it is totally different from OLTP engines, [&]

The post ClickHouse Meetup in Salt Lake City appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/clickhouse-meetup-in-salt-lake-city/

Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, Ill be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup. Interestingly enough, even though it is totally different from OLTP engines, [&]

The post ClickHouse Meetup in Salt Lake City appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/05/01/clickhouse-meetup-in-salt-lake-city/

In this blog post, Ill look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. [&]

The post A Look at MyRocks Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/30/a-look-at-myrocks-performance/

In this blog post, Ill look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. [&]

The post A Look at MyRocks Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/04/30/a-look-at-myrocks-performance/