Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   In the last few weeks, we have shown you how to successfully migrate from [&]

The post Upcoming Webinar Tues 9/11: Migrating to AWS Aurora: A Checklist for Success appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/webinar-migrating-aws-aurora-checklist/

Please join Percona’s Senior Consultant, Jervin Real, as he presents Migrating to AWS Aurora: A Checklist for Success. The event will take place on Tuesday, September 11th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   In the last few weeks, we have shown you how to successfully migrate from [&]

The post Upcoming Webinar Tues 9/11: Migrating to AWS Aurora: A Checklist for Success appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/webinar-migrating-aws-aurora-checklist/

Configuring replication between two databases is considered to be a best strategy towards achieving high availability during disasters and provides fault tolerance against unexpected failures. PostgreSQL satisfies this requirement through streaming replication. We shall talk about another option called logical replication and logical decoding in our future blog post. Streaming replication works on log shipping. [&]

The post Setting up Streaming Replication in PostgreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/

Configuring replication between two databases is considered to be a best strategy towards achieving high availability during disasters and provides fault tolerance against unexpected failures. PostgreSQL satisfies this requirement through streaming replication. We shall talk about another option called logical replication and logical decoding in our future blog post. Streaming replication works on log shipping. [&]

The post Setting up Streaming Replication in PostgreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/

From time to time, Percona hosts and co-hosts events around the world, often at no cost for attendees. The common focus for these events is, of course, open source databases. On October 3 2018, we team up with Taboola for an evening of talks suitable for all levels of expertise, addressing both the how and [&]

The post Taboola and Percona Host a Meetup in Tel Aviv, Oct 3 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/taboola-and-percona-host-a-meetup-in-tel-aviv-oct-3/

From time to time, Percona hosts and co-hosts events around the world, often at no cost for attendees. The common focus for these events is, of course, open source databases. On October 3 2018, we team up with Taboola for an evening of talks suitable for all levels of expertise, addressing both the how and [&]

The post Taboola and Percona Host a Meetup in Tel Aviv, Oct 3 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/taboola-and-percona-host-a-meetup-in-tel-aviv-oct-3/

This is the second part of a two parts series. In MongoDB: index usage and MongoDB explain() we introduced the main index types supported by MongoDB, and how to create and use them. In this second article, we are going to see some examples on how to use explain() method to investigate queries. Do you [&]

The post MongoDB: Investigate Queries with explain() and Index Usage (part 2) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/06/mongodb-investigate-queries-with-explain-index-usage-part-2/

This is the second part of a two parts series. In MongoDB: index usage and MongoDB explain() we introduced the main index types supported by MongoDB, and how to create and use them. In this second article, we are going to see some examples on how to use explain() method to investigate queries. Do you [&]

The post MongoDB: Investigate Queries with explain() and Index Usage (part 2) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/06/mongodb-investigate-queries-with-explain-index-usage-part-2/

We are excited to announce we have joined the MariaDB Foundation as a Bronze Sponsor! Percona’s mission is to be an unbiased champion of open source databases. We pride ourselves on helping customers avoid vendor lock-in by supporting them across a range of database technologies and deployment strategies. Sponsoring the MariaDB Foundation is a great way [&]

The post Percona Becomes a Sponsor of the MariaDB Foundation appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/06/percona-becomes-a-sponsor-of-the-mariadb-foundation/

https://www.percona.com/blog/2018/09/05/percona-monitoring-and-management-pmm-1-14-0-is-now-available/

https://www.percona.com/blog/2018/09/05/percona-monitoring-and-management-pmm-1-14-0-is-now-available/

https://www.percona.com/blog/2018/09/05/percona-monitoring-and-management-pmm-1-14-0-is-now-available/

Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMMs linux:metrics exporter.  We will assume that the PMM client packages are installed, and they are configured already. Using a custom list of metrics Lets now [&]

The post Modifying List of Collected Metrics on PMM Linux Exporter appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/05/modifying-list-of-collected-metrics-on-pmm-linux-exporter/

Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMMs linux:metrics exporter.  We will assume that the PMM client packages are installed, and they are configured already. Using a custom list of metrics Lets now [&]

The post Modifying List of Collected Metrics on PMM Linux Exporter appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/05/modifying-list-of-collected-metrics-on-pmm-linux-exporter/

Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMMs linux:metrics exporter.  We will assume that the PMM client packages are installed, and they are configured already. Using a custom list of metrics Lets now [&]

The post Modifying List of Collected Metrics on PMM Linux Exporter appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/05/modifying-list-of-collected-metrics-on-pmm-linux-exporter/

Please join Percona’s Chief Technology Officer, Vadim Tkachenko, as he presents Running MySQL in Kubernetes on Thursday, September 6th, 2018, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   Without question, Kubernetes is the most popular container orchestration platform. But can it handle databases? I think so, and in this webinar, [&]

The post Upcoming Webinar Thurs 9/6: Running MySQL in Kubernetes appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/04/webinar-9-6-running-mysql-kubernetes/

In this two part series, Im going to explain explain. No, the repetition is not a pun or a typo. Im talking about explain(), the most useful MongoDB feature to investigate a query. Here, Ill introduce the index types available in MongoDB, their properties and how to create and use them. In the next article well [&]

The post MongoDB: index usage and MongoDB explain() (part 1) appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/04/mongodb-index-usage-and-mongodb-explain-part-1/

In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM) A quick search led me to the  text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation For PMM, Vadim Yalovets recently [&]

The post Monitoring S.M.A.R.T. Metrics with Prometheus and PMM appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/03/monitoring-smart-metrics-with-prometheus-and-pmm/

In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM) A quick search led me to the  text_collector plugin SmartMon, which can be easily integrated with any Prometheus Installation For PMM, Vadim Yalovets recently [&]

The post Monitoring S.M.A.R.T. Metrics with Prometheus and PMM appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/03/monitoring-smart-metrics-with-prometheus-and-pmm/

In my previous blog post about millions of table in MySQL 8, I was able to create one million tables and test the performance of it. My next challenge is to create 40 million tables in MySQL 8 using shared tablespaces (one tablespace per schema). In this blog post Im showing how to do it [&]

The post 40 million tables in MySQL 8.0 with ZFS appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/03/40-million-tables-in-mysql-8-0-with-zfs/