MariaDB on a Small VPS

So I am in the process of migrating from a CentOS 5 VPS to a CentOS 7 one. I run various services on my VPS, most of the services are light on resources. I am running MariaDB for this blog, and only for this blog. I am not using MyISAM tables, meaning I can disable InnoDB. This will free up some RAM on the box.

  1. Modify ‘/etc/my.cnf’ by adding the following lines:
    skip-innodb
    default-storage-engine=MyISAM
    

    Modified file:

    [mysqld]
    skip-innodb
    default-storage-engine=MyISAM
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    # Settings user and group are ignored when systemd is used.
    # If you need to run mysqld under a different user or group,
    # customize your systemd unit file for mariadb according to the
    # instructions in http://fedoraproject.org/wiki/Systemd
    
    [mysqld_safe]
    log-error=/var/log/mariadb/mariadb.log
    pid-file=/var/run/mariadb/mariadb.pid
    
    #
    # include all files from the config directory
    #
    !includedir /etc/my.cnf.d
  2. The restarted MariaDB
    systemctl restart mariadb
    

 

This entry was posted in CentOS, Linux and tagged , . Bookmark the permalink.