With PerconaLive 2017 coming up in a couple of months, go ahead and get excited! The conference is being held in Santa Clara, California from April 24-28, 2017.

While you’re there, be sure to add these Pythian sessions to your schedule:

Monday April 24

• 1:30pm-4:30pm – ProxySQL Tutorial, Derek Downey co-presenting with Rene Cannao (ProxySQL) and David Turner (Uber)

Tuesday April 25

• 11:30am-12:20pm – B-Trees, Fractal Trees, Heaps and Log Structured Merge Trees, Where did they all come from and why?, John Schulz
• 1:20pm-2:10pm – …

The Southern California Linux Expo (SCaLE) returns to Pasadena, California this week. This event is the largest event of its type in the US and will attract north of three thousand attendees. It attracts the best speakers from around the plant and the expo hall has exhibitors you will rarely see at other events. It is part Woodstock, part post-grad class in computer science, and 100% entertaining. The full pass is $75, unless you mention the “SPEAK” discount code to gt 50% off.

And for the fifth or sixth year, MySQL will be sponsoring the MySQL Track on Friday March 13th in Room 103.

• MySQL 8
  10:00am
  Dave Stokes
• Best Practices for MySQL High Availability in 2017
  11:30
  Colin Charles
• Cassandra Eye for the MySQL Guy
  13:30
  Solomon Chang
• MySQL vs MongoDB – Choosing …

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. This post is meant to walk a prospective user through the benefits of Percona Monitoring and Management (PMM), how it’s architected and the simple install process. By the end of this post, you should have a good idea of what PMM is, where it can add value in your environment and how you can get PMM going quickly.

Percona Monitoring and Management (PMM) is Percona’s open-source tool for monitoring and alerting on database performance and the components that contribute to it. PMM monitors MySQL (Percona Server and MySQL CE), Amazon RDS/Aurora, MongoDB ( …

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. The purpose of this blog post is to demonstrate current best-practices for an in-place Percona Monitoring and Management (PMM) upgrade. Following this method allows you to retain data previously collected by PMM in your MySQL or MongoDB environment, while upgrading to the latest version.

Step 1: Housekeeping

Before beginning this process, I recommend that you use a package manager that installs directly from Percona’s official software repository. The install instructions vary by distro, but for Ubuntu users the commands are:

wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb

sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb

…

This post is part of a series of Percona’s MongoDB 3.4 bundle release blogs. In this blog, we’ll look at the process for installing Percona Monitoring and Management (PMM) for the first time.

Installing Percona Monitoring and Management

Percona Monitoring and Management (PMM) is Percona’s open source tool for monitoring databases. You can use it with either MongoDB and MySQL databases.

PMM requires the installation of a server and client component on each database server to be monitored. You can install the server component on a local or remote server, and monitor any MySQL or MongoDB instance (including Amazon RDS environments).

What is it?

PMM provides a graphical view of the status of monitored databases. You can use it to perform query …

Percona announces the availability of Percona Toolkit 3.0.1 on February 20, 2017. This is the first general availability (GA) release in the 3.0 series with a focus on padding MongoDB tools:

• pt-mongodb-summary
• pt-mongodb-query-digest

Downloads are available from the Percona Software Repositories.

NOTE: If you are upgrading using Percona’s yum repositories, make sure that the you enable the basearch repo, because …

Percona announces the release of Percona Monitoring and Management 1.1.1 on February 20, 2017. This is the first general availability (GA) release in the PMM 1.1 series with a focus on providing alternative deployment options for PMM Server:

• OVA image for VirtualBox is available from the testing download area at https://www.percona.com/redir/downloads/TESTING/pmm/.
• Public Amazon Machine Images (AMI):
  • US East (N. Virginia)
  • US East (Ohio)
  …

In this blog, we’ll look at how we plan to represent MariaDB at Percona Live.

The MariaDB Corporation is organizing a conference called M17 on the East Coast in April. Some Perconians (Peter Zaitsev, Vadim Tkachenko, Sveta Smirnova, Alex Rubin, Colin Charles) decided to submit some interesting talks for that conference. Percona also offered to sponsor the conference.

As of this post, the talks haven’t been accepted, and we were politely told that we couldn’t sponsor.

Some of the proposed talks were:

• MariaDB Backup with Percona XtraBackup (Vadim Tkachenko)
• Managing MariaDB Server operations with Percona Toolkit (Colin Charles)
• MariaDB Server Monitoring with Percona Monitoring and Management (Peter Zaitsev)
• Securing your MariaDB Server/MySQL data (Colin Charles, …

The Percona Live Open Source Database Conference 2017 will once again host crash courses on MySQL and MongoDB. Read below to get an outstanding discount on either the MySQL or MongoDB crash course (or both).

The database community constantly tells us how hard it is to find someone with MySQL and MongoDB DBA skills who can help with the day-to-day management of their databases. This is especially difficult when companies don’t have a full-time requirement for a DBA. Developers, system administrators and IT staff spend too much time trying to solve basic database problems that keep them from doing their other job duties. Eventually, the little problems or performance inefficiencies that start to pile up lead to big problems.

In answer to this …

Thank you everyone who attended our Webinar on “Become better at monitoring MySQL & MariaDB using Monyog”.

The webinar witnessed insights into the best monitoring practices for MySQL & MariaDB. We also talked about how Monyog can help increase the productivity of people who use and manage MySQL & MariaDB. Here’s the complete video for all those who couldn’t attend the webinar.

We hope you found the webinar useful. We ensure we will conduct more webinars in upcoming weeks. To keep yourself updated, subscribe to our blogs.

Download a free trial of Monyog here.

The post Highlights: Become better at monitoring MySQL & MariaDB using Monyog appeared first on …