Thu, 16 May 2024 15:26:13 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/valkey-redis-not-so-good-practices/ https://www.percona.com/blog/valkey-redis-not-so-good-practices/#respond Thu, 16 May 2024 15:26:13 +0000 https://www.percona.com/blog/?p=96325 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 passwordBy default, Valkey/Redis uses no authentication. This means anyone can connect to your Valkey server and start writing and reading data. Worst yet, no password while binding to all […]]]> https://www.percona.com/blog/valkey-redis-not-so-good-practices/feed/ 0 96325 https://www.percona.com/blog/valkey-redis-configuration-best-practices/ https://www.percona.com/blog/valkey-redis-configuration-best-practices/#respond Wed, 15 May 2024 13:05:27 +0000 https://www.percona.com/blog/?p=96276 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 practices.ConnectionsThe Valkey/Redis config file is typically located at /etc/valkey/valkey.conf, but […]]]> https://www.percona.com/blog/valkey-redis-configuration-best-practices/feed/ 0 96276 https://www.percona.com/blog/valkey-redis-the-hash-datatype/ https://www.percona.com/blog/valkey-redis-the-hash-datatype/#respond Tue, 14 May 2024 13:21:54 +0000 https://www.percona.com/blog/?p=96278 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 PHP, etc. Normally in Valkey/Redis, you store one value associated with one key. […]]]> https://www.percona.com/blog/valkey-redis-the-hash-datatype/feed/ 0 96278 https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/ https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/#respond Thu, 09 May 2024 15:09:10 +0000 https://www.percona.com/blog/?p=96208 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 with Valkey/Redis and learn about sets and […]]]> https://www.percona.com/blog/valkey-redis-sets-and-sorted-sets/feed/ 0 96208 https://www.percona.com/blog/hello-valkey-lets-get-started/ https://www.percona.com/blog/hello-valkey-lets-get-started/#respond Tue, 07 May 2024 13:17:59 +0000 https://www.percona.com/blog/?p=96199 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 to Redis/Valkey, then this ‘getting started’ post is just for […]]]> https://www.percona.com/blog/hello-valkey-lets-get-started/feed/ 0 96199 https://www.percona.com/blog/extensibility-in-mysql-is-easy https://www.percona.com/blog/extensibility-in-mysql-is-easy#respond Wed, 19 Jul 2023 10:38:23 +0000 https://www.percona.com/blog/?p=89436 Well, “easy” if you know just a tiny bit of C++.MySQL is well known for its ease of use, being easy to install, easy to configure, and easy to maintain. What if there is something more that you’d like MySQL to do? How would you integrate some new fancy processing library into MySQL without having […]]]> https://www.percona.com/blog/extensibility-in-mysql-is-easy/feed/ 0 89436 https://www.percona.com/blog/mysql-8-doesnt-like-your-groups/ https://www.percona.com/blog/mysql-8-doesnt-like-your-groups/#respond Mon, 17 Apr 2023 12:04:24 +0000 https://www.percona.com/blog/?p=86995 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 painless as the transition from […]]]> https://www.percona.com/blog/mysql-8-doesnt-like-your-groups/feed/ 0 86995 https://www.percona.com/blog/give-me-some-latitude-and-longitude/ https://www.percona.com/blog/give-me-some-latitude-and-longitude/#respond Tue, 27 Sep 2022 12:11:37 +0000 https://www.percona.com/blog/?p=82849 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’ training class for MySQL, one of the things we discuss is column types. The spatial types are only mentioned […]]]> https://www.percona.com/blog/give-me-some-latitude-and-longitude/feed/ 0 82849 https://www.percona.com/blog/adjusting-mysql-8-0-memory-parameters/ Tue, 03 Nov 2020 16:36:03 +0000 https://www.percona.com/blog/?p=68494 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 you would want to adjust.InnoDB Parametersinnodb_buffer_pool_sizeThe InnoDB buffer pool […]]]> 68494 https://www.percona.com/blog/best-practices-for-mysql-backups/ https://www.percona.com/blog/best-practices-for-mysql-backups/#comments Wed, 27 May 2020 14:33:42 +0000 https://www.percona.com/blog/?p=68189 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. Let’s dive in and discuss some of the basics and best practices around backups for MySQL.Logical MySQL BackupsIn […]]]> https://www.percona.com/blog/best-practices-for-mysql-backups/feed/ 2 68189 https://www.percona.com/blog/mysql-training-and-education-is-here-for-you/ https://www.percona.com/blog/mysql-training-and-education-is-here-for-you/#comments Thu, 21 May 2020 17:09:46 +0000 https://www.percona.com/blog/?p=51201 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 our knowledge directly to your organization to make your staff the absolute best […]]]> https://www.percona.com/blog/mysql-training-and-education-is-here-for-you/feed/ 1 51201 https://www.percona.com/blog/kubernetes-introduction-to-containers/ https://www.percona.com/blog/kubernetes-introduction-to-containers/#comments Tue, 27 Aug 2019 16:35:45 +0000 https://www.percona.com/blog/?p=61588 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 buzz.  Unless you’ve been living under a rock for the past year, Kubernetes […]]]> https://www.percona.com/blog/kubernetes-introduction-to-containers/feed/ 1 61588 https://www.percona.com/blog/creating-custom-sysbench-scripts/ Thu, 25 Apr 2019 11:44:46 +0000 https://www.percona.com/blog/?p=56329 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. These tests are written in an easy-to-understand scripting language called Lua. Some of […]]]> 56329 https://www.percona.com/blog/webinar-thursday-october-19-2017-need-get-indexes-part-2/ Wed, 18 Oct 2017 18:46:42 +0000 https://www.percona.com/blog/?p=45772 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. Finely tune your query writing and database performance with tips from […]]]> 45772 https://www.percona.com/blog/mysql-encryption-rest-part-2-innodb/ https://www.percona.com/blog/mysql-encryption-rest-part-2-innodb/#comments Wed, 28 Jun 2017 20:51:23 +0000 https://www.percona.com/blog/?p=43117 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 needs to be encrypted “at rest.” As with all things […]]]> https://www.percona.com/blog/mysql-encryption-rest-part-2-innodb/feed/ 7 43117 https://www.percona.com/blog/mysql-encryption-at-rest-part-1-luks/ https://www.percona.com/blog/mysql-encryption-at-rest-part-1-luks/#comments Tue, 06 Jun 2017 19:00:41 +0000 https://www.percona.com/blog/?p=43115 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 rest.” As with all things open source, there several options for […]]]> https://www.percona.com/blog/mysql-encryption-at-rest-part-1-luks/feed/ 4 43115 https://www.percona.com/blog/auditing-mysql-with-mcafee-and-mongodb/ https://www.percona.com/blog/auditing-mysql-with-mcafee-and-mongodb/#comments Tue, 09 Jun 2015 13:00:54 +0000 https://www.percona.com/blog/?p=30235 https://www.percona.com/blog/auditing-mysql-with-mcafee-and-mongodb/feed/ 4 30235 https://www.percona.com/blog/percona-toolkit-for-mysql-with-mysql-ssl-connections/ https://www.percona.com/blog/percona-toolkit-for-mysql-with-mysql-ssl-connections/#comments Thu, 16 Oct 2014 13:06:07 +0000 https://www.percona.com/blog/?p=26235 https://www.percona.com/blog/percona-toolkit-for-mysql-with-mysql-ssl-connections/feed/ 3 26235 https://www.percona.com/blog/looking-out-for-max-values-in-integer-based-columns-in-mysql/ https://www.percona.com/blog/looking-out-for-max-values-in-integer-based-columns-in-mysql/#comments Mon, 07 Jul 2014 10:00:54 +0000 https://www.percona.com/blog/?p=24354 https://www.percona.com/blog/looking-out-for-max-values-in-integer-based-columns-in-mysql/feed/ 12 24354