Vathsa's- Linux - SysOps and DevOps

Things you need to know: MySQL/MariaDB configuration file is located in  /etc/my.cnf . Every time you modify this file you will need to restart the MySQL service so the new changes can take effect. For writing this article MySQL version  5.6  has been used as template. 1. Enable InnoDB file-per-table First it is important to explain that  InnoDB  is a storage engine. MySQL and MariaDB use InnoDB as default storage engine. In the past MySQL used to keep database tables and indexes in a system tablespace. This approach was meant for servers which sole purpose is database processing and their storage disk is not used for any other purposes. The InnoDB provides more flexible approach and each database information is kept in a  .ibd  data file. Each .ibd  file represents a tablespace of its own. That way database operations such as “ TRUNCATE ” can be completed faster and you may also reclaim unused space when dropping or truncating a datab...

How do I migrate from RHEL5 to RHEL7? Contents 1.      Upgrade support restrictions 2.      Hardware requirements and support 3.      Subscription management 4.      Kernel, boot, and init 5.      Basic administration 6.      File systems and storage 7.      Networking 8.      Security and access control 9.      Clustering 10.    Desktop 11.    Command changes for common tasks This article covers the major differences between version 5 and version 7 of Red Hat Enterprise Linux, to assist customers who have recently moved versions, or are planning to move versions soon. Upgrade support restrictions Red Hat does not support upgrading directly from RHEL 5 to RHEL 7. However, if you intend to move from RHEL 5 to RHEL 7 by backing up your data and restoring data...