by Matthew Boehm | May 16, 2024 | Insight for DBAs, Insight for Developers, Open Source
As we’ve been introducing Valkey/Redis these past few weeks, let’s depart from the norm and talk about a few “things you should not do” in Valkey. No password By default, Valkey/Redis uses no authentication. This means anyone can connect to... by Matthew Boehm | May 15, 2024 | Insight for DBAs, Insight for Developers, Open Source
In a few of our previous blog posts, we’ve seen how to get started with Valkey/Redis by running a simple docker container and how to persist some configuration settings to disk. In this post, let’s take a step back and go over a few configuration best... by Matthew Boehm | May 14, 2024 | Insight for DBAs, Insight for Developers, Open Source
In our previous blogs, we discussed the basic data types available in Valkey/Redis: Strings, Lists, Sets, and Sorted Sets. In this blog, we introduce a more complex data type, Hashes.You can think of these much like dictionaries from Python, associative arrays from... by Matthew Boehm | May 9, 2024 | Insight for DBAs, Insight for Developers, Open Source
In our previous post, we welcomed Valkey (an open source fork of Redis) to the Percona family. We also learned how to get Valkey up and running using docker, along with understanding some of the basic data types, string and list. In this post, we will continue working... by Matthew Boehm | May 7, 2024 | Insight for DBAs, Insight for Developers, Open Source
Welcome Valkey to the Percona family! We are excited to have you join our team of MySQL, PostgreSQL, and MongoDB database experts.Hang on. What is Valkey? In short, Valkey is a fork of Redis which maintains the original open source BSD license[1]. If you’re new... by Matthew Boehm | Jul 19, 2023 | Insight for DBAs, Insight for Developers, MySQL
by Matthew Boehm | Apr 17, 2023 | Insight for DBAs, MySQL, Percona Services
If you have not been keeping up with MySQL news, MySQL 5.7 reaches end of life in October 2023. This means no more bug fixes or security updates for MySQL 5.7. Users will be effectively forced to upgrade to MySQL 8.Upgrading to MySQL 8 from 5.7 is nowhere near as... by Matthew Boehm | Sep 27, 2022 | Insight for DBAs, MySQL
Geo locations are a cornerstone of modern applications. Whether you’re a food delivery business or a family photographer, knowing the closest “something” to you or your clients can be a great feature.In our ‘Scaling and Optimization’... by Matthew Boehm | Nov 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
So you’ve just added some more memory to your MySQL server; now what? If you’ve been around the MySQL block for a while, you know that nothing is automatically changed to take advantage of this new system RAM. Let’s have a look at a few parameters... by Matthew Boehm | May 27, 2020 | MySQL, Percona Services, Percona Software
Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups.... by Matthew Boehm | May 21, 2020 | Database Trends, MySQL, Open Source, Percona Services
Percona Training Is Here for You! Percona’s Training and Education Department wants you! For the past three years, Percona has quietly been delivering world-class training all over the globe, to companies large and small. We are in full force and ready to spread... by Matthew Boehm | Aug 27, 2019 | Cloud, Open Source
Here at Percona’s Training and Education department, we are always at work with trying to keep our materials up-to-date and relevant to current technologies. In addition, we keep an eye out for what topics are “hot” and are generating a lot of... by Matthew Boehm | Apr 25, 2019 | Benchmarks, Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Services
Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8. Sysbench comes with several pre-defined benchmarking tests.... by Matthew Boehm | Oct 18, 2017 | Insight for DBAs, MySQL, Open Source, Webinars
Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register NowProper indexing is key to database performance.... by Matthew Boehm | Jun 28, 2017 | MySQL, Security
Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption.At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL... by Matthew Boehm | Jun 6, 2017 | MySQL, Security
In this first of a series of blog posts, we’ll look at MySQL encryption at rest.At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at... by Matthew Boehm | Jun 9, 2015 | MongoDB, MySQL, Percona Software
Greetings everyone! Let’s discuss a 3rd Party auditing solution to MySQL and how we can leverage MongoDB® to make sense out of all of that data.The McAfee MySQL Audit plugin does a great job of capturing, at low level, activities within a MySQL server.... by Matthew Boehm | Oct 16, 2014 | MySQL, Percona Software
I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be... by Matthew Boehm | Jul 7, 2014 | Insight for DBAs, MySQL