by Dave Avery | Jan 26, 2017 | Insight for DBAs, MySQL, Percona Live
Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your...
by Sveta Smirnova | Jan 26, 2017 | MySQL, Open Source
In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had...
by Ramesh Sivaraman | Jan 25, 2017 | Percona Software, ProxySQL
ProxySQL Admin (proxysql-admin) is a powerful tool for configuring Percona XtraDB Cluster nodes into ProxySQL. The proxysql-admin tool comes with the ProxySQL package from Percona apt/yum repositories. ProxySQL 1.3.2-1 is now available from the Percona repositories....
by Dave Avery | Jan 24, 2017 | MySQL, Webinars
Please join Percona’s Jon Tobin, Director of Solution Engineering at Percona, and Rob Masson, Solutions Architect Manager at ScaleArc, on Thursday, January 26, 2017, at 9:00 am PST / 12:00 pm EST (UTC-8) for their webinar “Overcoming the Challenges of...
by Dave Avery | Jan 23, 2017 | MySQL, Webinars
Please join Laurynas Biveinis, Percona’s Technical Director – Engineering, on January 25, 2017, at 7 am EST (UTC-8) as he discusses “Percona Server for MySQL 5.7: Key Performance Algorithms.” In this webinar, Laurynas will discuss selected areas of InnoDB...
by Barrett Chambers | Jan 23, 2017 | MySQL
This blog post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana. As a Solutions Engineer at Percona, I get to speak with a lot of the early adopters of Percona’s new PMM software. One of the frequent...
by Evgeniy Patlan | Jan 20, 2017 | Insight for Developers, MySQL
In this blog, we’ll look at how to manually build Percona Server for MySQL RPM packages. Several customers and other people from the open source community have asked us how they could make their own Percona Server for MySQL RPM binaries from scratch. This...
by Marco Tusa | Jan 19, 2017 | Insight for DBAs, MySQL, ProxySQL
In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting...
by Sveta Smirnova | Jan 19, 2017 | Open Source
In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is READ COMMITTED, and is known to...
by Dave Avery | Jan 18, 2017 | Insight for DBAs
In this blog post, we’ll look at a new Elasticsearch ransomware outbreak and what you can do to prevent it happening to you. Mere weeks after reports of MongoDB servers getting hacked and infected with ransomware, Elasticsearch clusters are experiencing the same...
by Dave Avery | Jan 17, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Chief Evangelist Colin Charles on Wednesday, January 18, 2017, at 7:00 am (PST) / 10:00 am (EST) (UTC-8) as he presents “Lessons from Database Failures.” MySQL failures at scale can teach a great deal. MySQL failures can lead to a...
by Dave Avery | Jan 16, 2017 | MySQL, Percona Live
Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your...
by Miguel Angel Nieto | Jan 16, 2017 | Insight for DBAs, MySQL
In this blog post, I am going to show how we can use mysqlshell to run ad-hoc data visualizations and use machine learning to predict new outcomes from the data. Some time ago Oracle released MySQL Shell, a command line client to connect to MySQL using the X protocol....
by Adamo Tonete | Jan 13, 2017 | Insight for DBAs, MongoDB
This blog post covers MongoDB 3.4 views, one of the more recent MongoDB features. Views are often used in relational databases to achieve both data security and a high level of abstraction, making it easier to retrieve data. Unlike regular tables, views neither have a...
by Peter Zaitsev | Jan 13, 2017 | Insight for DBAs, MySQL
In this blog, I’ll look at the impact of swapping on MySQL performance. It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in...
by David Busby | Jan 12, 2017 | MySQL, Security
If you are using Percona XtraBackup with xbcrypt to create encrypted backups, and are using versions older than 2.3.6 or 2.4.5, we advise that you upgrade Percona XtraBackup. Note: this does not affect encryption of encrypted InnoDB tables. CVE-2016-6225 Percona...
by Dave Avery | Jan 12, 2017 | MongoDB, MySQL, Percona Services
We are proud to announce the new Percona online store! Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping...
by Manjot Singh | Jan 11, 2017 | Hardware and Storage, MySQL, Percona Software
In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos...
by Peter Zaitsev | Jan 11, 2017 | Insight for DBAs, MySQL
In this blog post, we’ll look at how to preserve all MySQL grants and users after reinstalling MySQL. Every so often, I need to reinstall a MySQL version from scratch and preserve all the user accounts and their permissions (or move the same users and privileges...
by Dave Avery | Jan 10, 2017 | MongoDB, MySQL, Percona Services, Percona Software, Webinars
Please join Percona CEO Peter Zaitsev for a webinar on Thursday, January 12, 2017 at 11 am PST/ 2 pm EST (UTC-8) for a discussion on the Percona Software News and Roadmap Update for Q1 2017. In this webinar, Peter will discuss what’s new in Percona open source...
