MySQL master-slave replication is a procedure that allows database files to be replicated or copied across one or more nodes in a network. This setup provides redundancy and fault tolerance such that in the event of a failure in the Master node, the databases can still be recovered in the Slave node. This gives users
MySQL is a widely used open source relational database management system (RDMS) owned by Oracle. It has over the years been the default choice for web-based applications and still remains popular in comparison to other database engines. Read Also: How to Install Latest MySQL on RHEL/CentOS and Fedora MySQL was designed and optimized for web
Brief: Learn to use basic SQL commands in the open source database management system MySQL. MySQL is the most commonly used relational database manager. Its ease of use and open source license have greatly contributed to this popularity. Last week, I covered installing and configuring MySQL in Ubuntu. In this article I’ll be presenting to
Transferring or Migrating a MySQL/MariaDB database between servers usually takes only few easy steps, but data transfer can take some time depending on the volume of data you would like to transfer. In this article, you will learn how to transfer or migrate all your MySQL/MariaDB databases from old Linux server to a new server,
Most of the time, you can easily manage your database with web-based tools such as phpMyAdmin. Unfortunately, there are times when you need to restore a large amount of data. This can’t be accomplished through phpMyAdmin because of PHP’s limits (either the maximum time a PHP script can use or the maximum file size upload). Using the MySQL
Mytop is a free and open source command line monitoring software for MySQL databases. Its similar in look to “top” command in Linux/Unix. Mytop monitors MySQL threads and the database’s overall performance, allowing system administrators or developers to get some insight on how applications are interacting with a database. Install Mytop on RHEL/CentOS and Fedora
