Category: MySQL & MariaDB

Feed: Puppet.com Blog RSS Feed. Author: ; If your daily language isn't English, you've probably noticed that the output from supported Puppet modules is displayed in English — and only in English. That's about to change. We are now making changes so that other languages can be available on the Forge. This is part of our internationalization effort to support end users whose first language is not English.If you're writing a module and you want to make it available in multiple languages, you need to decorate strings that are externalized — that is, displayed to the person using the module ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; May and June were busy months for Puppet modules and Puppet Forge activity, with 34 module releases! Included among the many releases was the newly supported IIS module, which boasts improvements to performance, the API and features for easier management of IIS. puppetlabs-stdlib-4.17.1Standard library of resources for Puppet modules.2017-06-16puppetlabs-mount_iso-1.0.0Mount ISO images and ensure the drive letter they are mounted to2017-06-14puppetlabs-puppet_agent-1.4.0Upgrades Puppet 3.7+ and All-In-One Puppet Agents2017-06-14puppetlabs-concat-4.0.1Construct files from multiple fragments.2017-06-14puppetlabs-windows-5.0.0Collection of Puppet modules for managing Microsoft Windows.2017-06-13puppetlabs-rsync-1.0.0Manages rsync clients, repositories, and servers, & providies defines to easily grab data via rsync.2017-06-09puppetlabs-lumogon-0.4.0Provides a Puppet ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I'd like to continue reviewing MySQL bug reports from Community users that I considered interesting and subscribed to. Unlike in the previous post in this series, I am not going to check test cases on any competitor product, but will use only recently released MySQL 5.7.29 and 8.0.19 for checks, if any. This time I'll concentrate on bugs reported in November 2019.As usual, I mostly care about optimizer, InnoDB and replication related bugs. Here is the list:Bug #97476 - "Range optimizer skips rows". This bug reported by Ilya Raudsepp looks like a clear regression in ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; In this post we're going to spotlight an under-the-hood feature of the Puppet configuration management platform that doesn't often get a lot of exposure: a process called pluginsync. Having a variety of tricks and hacks on hand is important when writing your own Puppet modules — but there's more to those modules than just manifests and code. By further building out your modules with your own custom facts, resources, and functions, you can greatly expand the versatility of your modules, and by extension, your entire business infrastructure. We call these custom facts, resources ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; One of the best ways to ensure good, solid security on systems across your organization is to establish baselines defining a minimum set of standards for access, firewalls and services. Puppet can help you define, build, and maintain those configuration management baselines in a straightforward way that’s just not possible when working at scale.In this blog post, I cover a few basic steps you can take with Puppet to improve your security by building in some basic assertions about the state of your servers. We'll start with defining manifests that limit access to ... Read More

Feed: Planet MySQL; Author: Percona Community; Wayne Leutwyler  | January 17, 2020 |  Posted In: MySQL, Open Source Databases, Percona Server for MySQLIn my last blog post I showed you how to get the entire Percona “Stack” up and running on a Raspberry Pi. This time around, I would like to show the impact on performance between using an SSD hard disk and a standard hard disk.Disk performance is a key factor in Percona Server for MySQL (or any RDB platform) performance on a Raspberry Pi 4.Test set upEach test below was run three times per Hard Disk and I took the best ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations.For this I planned to use three bare metal nodes, SSD drives, and a 10Gb network available for in-between nodes communication, but later I also added tests on three bare metal nodes with NVMe drives and 2x10Gb network cards.To simplify deployment, I created simple ansible scripts.Load DataThe first initial logical step is to load data into an empty cluster, ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features. However, this release includes some significant changes: Fixes for bugs in the schema definition:  Cascading keys in multi-primary mode. Introduction of InnoDB ReplicaSet. These changes required updates to the metadata schema definition, some of which incompatible with previous versions. InnoDB Cluster and ReplicaSet deployments that are created using MySQL Shell 8.0.19 will automatically use the new version of the metadata schema. However, to use InnoDB Cluster deployments created in older Shell versions (8.0.18 or earlier) with ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; According to the National Vulnerability Database (NVD) maintained by the U.S. National Institute for Standards and Technology (NIST), 92 percent of reported vulnerabilities are in applications, and not due to insecure networks. That’s 11 out of 12. But this doesn’t mean you can throw away your firewall or go back to using telnet for your remote logins. Considering the NIST NVD contains over 86,000 known vulnerabilities, that still leaves around 7,000 reported network vulnerabilities. Using a layered approach to security is still the best approach.This does mean, however, that your quality assurance team ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; Whether you’re edging toward a full DevOps initiative or simply looking for ways to better communicate and collaborate across functions, you and your IT organization can take advantage of a wide variety of free and proprietary DevOps tools to help you along.DevOps tools are those that promote sharing and collaboration, and they're so widely used, you may already be familiar with some of the ones described below. The key to expanding DevOps culture and practices is to think about how they might be used beyond your IT department, and shared in new ways ... Read More