by Corrado Pandiani | Sep 4, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Open Source, Percona Software
In this two-part series, I’m going to explain explain. No, the repetition is not a pun or a typo. I’m talking about explain(), the most useful MongoDB feature to investigate a query. Here, I’ll introduce the index types available in MongoDB, their...
by Peter Zaitsev | Sep 3, 2018 | MySQL, Percona Software
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...
by Alexander Rubin | Sep 3, 2018 | Benchmarks, Insight for DBAs, MySQL
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...
by Colin Charles | Aug 31, 2018 | MySQL, Open Source, PostgreSQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. There has been a lot of talk around licenses in open source software, and it has hit the database world in the past weeks....
by Peter Zaitsev | Aug 31, 2018 | MariaDB, MongoDB, MySQL, PostgreSQL, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents Choosing the Right Open Source Database on Wednesday, September 5th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Watch Now The world of open-source databases is overwhelming. There are...
by Peter Zaitsev | Aug 30, 2018 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Software
One of the common ways to classify database workloads is whether it is “read intensive” or “write intensive”. In other words, whether the workload is dominated by reads or writes. Why should you care? Because recognizing if the workload is read intensive or write...
by Vadim Tkachenko | Aug 29, 2018 | Benchmarks, Cloud, Hardware and Storage, MySQL, Percona Software, Storage Engine
Is increasing GP2 volumes size or increasing IOPS for IO1 volumes a valid method for scaling IO-Bound workloads? In this post I’ll focus on one question: how much can we improve performance if we use faster cloud volumes? This post is a continuance of previous...
by Ibrar Ahmed | Aug 29, 2018 | Insight for DBAs, PostgreSQL
For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are...
by Vadim Yalovets | Aug 28, 2018 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Software
Percona Monitoring and Management (PMM) provides an excellent solution for system monitoring. Sometimes, though, you’ll have the need for a metric that’s not present in the list of node_exporter metrics out of the box. In this post, we introduce a simple...
by Colin Charles | Aug 28, 2018 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MySQL, Open Source, Webinars
Please join Percona’s Chief Evangelist, Colin Charles on Wednesday, August 29th, 2018, as he presents Databases in the Hosted Cloud at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now Nearly everyone today uses some form of database in the hosted cloud....
by Marco Tusa | Aug 27, 2018 | Insight for DBAs, MySQL
MySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, thereby allowing the DBA to manage application priorities. Essentially, you can assign a thread to a specific virtual CPU. In this...
by Peter Zaitsev | Aug 27, 2018 | Insight for DBAs, MySQL, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents Forking or Branching – Lessons from the MySQL Community on Tuesday, August 28th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now The MySQL Community offers a great example of various forks...
by Colin Charles | Aug 24, 2018 | Cloud, Insight for DBAs, MariaDB, MySQL, Percona Live, PostgreSQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Grading is underway for talks at Percona Live Europe 2018. I understand that by next week you will see the tutorial schedule...
by Jobin Augustine | Aug 24, 2018 | MySQL, PostgreSQL
There are many organizations where front/web-facing applications use MySQL and back end processing uses PostgreSQL®. Any system integration between these applications generally involves the replication—or duplication—of data from system to system. We recently blogged...
by Ceri Williams | Aug 23, 2018 | MariaDB, MySQL, Percona Software, Security
Protecting the data stored in your database may have been at the top of your priorities recently, especially with the changes that were introduced earlier this year with GDPR. There are a number of ways to protect this data, which until not so long ago would have...
by Walter Garcia | Aug 22, 2018 | MySQL, Percona Software
In this post I’ll give to you the steps to compile Percona Server for MySQL 5.7.22 in Raspberry Pi 3. Why? Well because in general this little computer is cheap, has low power consumption, and is great to use as a test machine for developers. By default Raspbian...
by Peter Zaitsev | Aug 22, 2018 | MongoDB, MySQL, Percona Events, Percona Software, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents MySQL vs MongoDB – Choosing the Right Technology for Your Application on Thursday, August 23, 2018, at 10:30 AM PDT (UTC-7) / 1:30 PM EDT (UTC-4). Register Now Are you considering to adopt the most popular...
by Jobin Augustine | Aug 21, 2018 | Open Source, PostgreSQL
There are a few features in PostgreSQL that are very compelling, and that I rarely see in other RDBMSs. Some of these features are the driving force behind the growing popularity of PostgreSQL. This blog post is about one of my favorite features: FDW (Foreign Data...
by Alexander Rubin | Aug 20, 2018 | Cloud, Insight for DBAs, MySQL
If you are using large EBS GP2 volumes for MySQL (i.e. 10TB+) on AWS EC2, you can increase performance and save a significant amount of money by moving to local SSD (NVMe) instance storage. Interested? Then read on for a more detailed examination of how to achieve...
by Colin Charles | Aug 20, 2018 | MariaDB, MySQL, Percona Events, Webinars
Please join Percona’s Chief Evangelist, Colin Charles on Tuesday, August 21st, 2018, as he presents MariaDB 10.3 vs. MySQL 8.0 at 7:00 AM PDT (UTC-7) / 10:00 PM EDT (UTC-4). Register Now Are they syntactically similar? Where do these two languages differ? Why would I...
