Once I created a raid, mounted it as a disk system partition and transferred the MySQL directory directly to it, but in this case there were drawbacks, the lost+found directory could appear, it could not be used for other data, etc., after that I began to transfer the MySQL directory not directly to the partition, but created a directory on it and transferred it to it.
Continue reading “Migrating MySQL Directory”Author Archives: Vyacheslav
How to update BIOS U30 on HPE DL380 Gen10
For example, I will update the BIOS U30 on the HPE ProLiant DL380 Gen10 server.
Continue reading “How to update BIOS U30 on HPE DL380 Gen10”Manual update of cPanel
In this article, I will provide examples of updating cPanel and WHM.
Continue reading “Manual update of cPanel”Installing NetBox on Ubuntu
NetBox is a web application for documenting and management of computer networks.
With a large number of networks, devices, it allows you to visually place it in racks, maintain a database, etc.
For example, I will perform a test installation of NetBox on Ubuntu 18.04.
Description of DNS Amplification Attacks
In this article, I will briefly describe the principle of DDoS DNS Amplification attacks.
Continue reading “Description of DNS Amplification Attacks”How to change innodb_io_capacity in MySQL
innodb_io_capacity – determines the number of write IOPS for background InnoDB tasks, such as flushing pages from a buffer pool, etc. If the cleanup operation is lagging, then InnoDB can perform cleanup more aggressively at a higher IOPS, which is defined in the innodb_io_capacity_max variable.
Continue reading “How to change innodb_io_capacity in MySQL”Configuring OSPF in Quagga
I will give a simple example of setting up OSPF in Quagga, for the test I will use Hyper-V with a virtual switch and virtual machines running Ubuntu Server 18.04.
Continue reading “Configuring OSPF in Quagga”Installing and configuring xt_NAT
I will give an example of installing and configuring xt_NAT on Ubuntu Server 14.04 with kernel version 4.4.0-142. xt_NAT may not work on newer kernel versions. According to the developer, it should work on Linux Kernel 3.18 and 4.1. To make it work on newer versions of the kernel, you can find patches.
Continue reading “Installing and configuring xt_NAT”Partitioning tables in MySQL
Partitioning tables in MySQL is splitting a large table into parts according to the specified criteria, which will speed up reading and writing data to it if this table contains a very large amount of data.
Continue reading “Partitioning tables in MySQL”How to change innodb_stats_on_metadata in MySQL
innodb_stats_on_metadata – Lets you collect statistics on metadata operations such as SHOW TABLE STATUS when accessing INFORMATION_SCHEMA.TABLES or INFORMATION_SCHEMA.STATISTICS tables.
In newer versions of MySQL, the innodb_stats_on_metadata parameter is disabled by default, which makes working with these tables faster.