Thumb rule to choose Percona-Server ssl Linux-Generic package
Here below are my thumb rules to choose which ssl linux-generic
package, you should download for your system.
Like here we can see if we need to download Percona-Server
Linux-Generic package then We can see here we have couple of
packages available with different ssl(100/101/102)
versions.
https://www.percona.com/downloads/Percona-Server-5.7/LATEST/binary/tarball/
Here you should choose below package based on your operating
system.
Debian …
Generally you have much bigger benefit with dim_STAT
when you're collecting and analyzing your data live (online).
However, there maybe still many situations when this is simply
not possible (due security restrictions, wide remote distance, or
simply externally inaccessible hosts, etc.) -- for such cases
dim_STAT
has special tool EasySTAT
allowing you to collect all the needed stats locally on the given
machine, and then later to upload them to your
dim_STAT
server for post-analyze. To simplify
overall setup, EasySTAT
is integrated into
STAT-service
of dim_STAT
and can be
directly involved from there, also following the same rules for
MySQL access and so on (e.g. if your STAT-service
is
already operational, then your EasySTAT
will be too
;-))
The following article is explaining how to deploy and start
EasySTAT
…
In Generic binary Installation method, we are extracting compressed tar files of MySQL and later we can do customization for MySQL setup as per our requirement. Like having different data directory, log directory etc.
MySQL Generic Binaries can be used to install MySQL on Unix/Linux platforms.
MySQL Installation has a dependency on the libaio library. Make sure that is there on a server before mysql install.
-
Create a mysql user and group, which we will use as a service account for the mysql server.
shell> groupadd mysql
shell> useradd -r -g mysql -s /bin/false mysql
-
Extract MySQL binaries TAR to mysql base directory for example in /mysql dir
-
Create require directories and set appropriate permissions.
shell> cd mysql
…
[Read more]I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work, Hope it will help other beginners as well. This Blog will cover the following sections.
-
Introduction to Log-rotate
-
Issues Faced
-
Solutions (Fix for the above issues)
-
Best practices
-
How to configure the Log-rotate
-
Operation of Log-rotate
-
Files responsible for the Log_rotate utility.
-
1.0. Introduction to Log-rotate:
-
Log-rotate is a utility and …
Do you need to modify the metrics collected from Linux by Percona Monitoring and Management (PMM)? In this blog post we will see how to enable, disable, and update collected metrics on PMM’s linux:metrics exporter.
We will assume that the PMM client packages are installed, and they are configured already.
Using a custom list of metrics
Let’s now suppose we are not yet collecting any metrics on our desired client server, and we want to enable only the following: diskstats, meminfo, netdev and vmstat. We can use the following …
[Read more]In this tutorial, we will show step-by-step how to install and configure Ghost as a Docker container. We will install and configure Ghost under the latest Docker CE version, use the MySQL as a database and use the Traefik as a Reverse Proxy.
In our earlier stage of Ansible, we just wrote simple playbook and ad-hoc command with very long ansible hosts file. When we plan to use Ansible extensively in our daily production use case, we understand that simple playbooks don’t help to scale up to our expectation.
Even though we had options for separate variables, handlers and template files according to our requirements, this un-organized way didn’t help. It looked very messy and made me unhappy when I saw the code too. That’s the place we decided to use Ansible Role.
My understanding of Ansible Roles?
The role is the primary mechanism for breaking a playbook into multiple files, we can simply refer to the Python Package. Roles help to group multiple tasks, Jinja2 template file, variable file and handlers into a clean directory structure. This will help us to reduce the syntax error while developing and also …
[Read more]
After installing MySQL 5.7.22 and PHP 7.1.17 on Fedora 27, you
need to install the mysqli
library. You need to
verify if the mysqli
library is installed. You can
do that with the following mysqli_check.php
program:
Check mysqli Install<?php if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) { print 'mysqli not installed.'; } else { print 'mysqli installed.'; } ?>
You test preceding PHP program with the following URL in a browser:
http://localhost/mysqli_check.php
If the mysqli
program isn’t installed, you can
install it as follows by opening the yum
interactive
shell:
[root@localhost html]# yum shell Last metadata expiration check: 1:26:46 ago on Wed 22 Aug 2018 08:05:50 PM MDT. > remove php-mysql No match for argument: php-mysql Error: No packages marked for removal. > install php-mysqlnd > …[Read more]
In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 Performance Tuning Immediately After Installation. That post remains highly relevant for the latest versions of MySQL, 5.7 and 8.0. Here we will focus more on the Linux operating system parameters that can affect database performance.
Server and Operating System
Here are some Linux parameters that you should check and consider modifying if you need to improve database performance.
…
[Read more]Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as:
- General, slow, audit, binary, error log files
- Performance Schema
- Information Schema
- System …