• Home
  • About Us
  • Contact
  • Privacy Policy

LinuxAdmin.io

  • Home
  • Tutorials
    • System Administration
    • Linux Tutorials
    • Web Hosting
    • WordPress
    • Virtualization
    • Troubleshooting
    • OpenStack

MySQL 10

Tutorials, tricks and tips for Linux system administration relating to  mysql, Covering various topics on how to install, configure, manage, replication and performance tuning.
 

How To Check And Repair MyISAM Tables In MySQL

MySQL tables can become corrupt for a variety for reasons such as incomplete writes, running out of space, the MySQL daemon  being killed or crashing, power failures.  If MySQL detects a crashed or corrupt table it will need to be repaired before it can be used again. This guide will walk you through detecting crashed […]

7 years ago More
 

How To Reset A MySQL Root Password

MySQL contains it own ‘root’ password independent of the system root password, this is a guide on how to reset the MySQL root password. To reset it you will need root access on the server that has the MySQL instance. The same process applies to percona and mariadb servers as well, the only differences will […]

7 years ago More
 

How To Use Percona Xtrabackup To Create A MySQL Slave

Percona Xtrabackup can be used to create “hot backups” of MySQL servers fairly quickly and can avoid some of the pitfalls of mysqldump. Xtrabackup can be setup to use backup locks instead of read locks which is much less invasive, this is available on innodb tables. MyISAM and other tables will still need to be […]

7 years ago 2 More
 

Galera Cluster MariaDB Configuration On CentOS 7

Galera cluster is a true multi-master MySQL cluster using synchronous replication.   It allows for any of the nodes to be used as a master or all of them as well as providing automatic node joining and node removal. The multi-master configuration is very different from the typical master-slave configuration done with MySQL  servers and […]

7 years ago 4 More
 

MariaDB 10 Upgrade From MySQL 5.1 on CentOS 6

MariaDB is a fork of MySQL that was created from some of the original developers of mysql after MySQL was purchased by Oracle. Upgrading to MariaDB offers a range of benefits and is a relatively simple upgrade. It has more active development then MySQL currently and is just developed by Oracle support as MySQL is. […]

8 years ago More
 

MySQL Replication Master Slave Setup

MySQL Replication allows you to synchronize slave copies of a MySQL server. You can then use the slave to perform backups and a recovery option if the master should go offline for any reason. MySQL needs to be installed on both servers. Install MySQL on both servers: yum install -y mysql-server mysql-client mysql-devel Edit /etc/my.cnf […]

8 years ago 3 More
 

Disable WordPress Crontab and Run it Manually

By default WordPress runs wp-cron.php every time  someone visits your site. This causes increased load on the server each time a page is requested. On low traffic sites this really isnt noticeable but on higher traffic sites this can become problematic and cause increased load and resource consumption on the server. Turn off the WordPress […]

8 years ago More
Page 1 of 212»
Recent Posts
  • Configuring Firewalld to Work Seamlessly with Docker on CentOS
  • Mastering NGINX Tuning: Optimizing Web Server Performance
  • Exploring eBPF: Revolutionizing Network and System Monitoring
  • Kubernetes: Installation and Overview on CentOS 8
  • Install Docker on Centos 8
Most Commented
Hot Clone Linux Server with Rsync
Hot Clone A CentOS Server With Rsync
14 Comments
ngx_cache_purge module
Install The ngx_cache_purge Module In Nginx
8 Comments
piwik-nginx
Piwik Analytics on Nginx
8 Comments
Tags
linuxcentosLinux Performance Tuningsysadminkvmnetworkingmemcachedanalyticssystemd
About

We love Linux and are dedicated to creating Linux administration tutorials for System Administrators since 2016.

Most Viewed
Default Gateway
How To Configure A Default Gateway on CentOS
76,228 views
Zend Opcache
Setup and Optimize Zend OpCache
47,113 views
Install ffmpeg
FFMpeg Install On CentOS 7
21,687 views
Archives
Email subscription

Sign up for our newsletter to receive the latest news and event postings.

2018 © LinuxAdmin.io