Databases

How to Access MySQL Error Logs — step-by-step Linux tutorial on Progressive Robot

How to Access MySQL Error Logs

Oftentimes, the root cause of slowdowns, crashes, or other unexpected behavior in MySQL can be determined by analyzing its error logs. On Ubuntu systems, the default location for the MySQL is /var/log/mysql/error.log. In many cases, the error logs are most easily read with the less program, a…

Read more
How To Troubleshoot Socket Errors in MySQL — step-by-step Linux tutorial on Progressive Robot

How To Troubleshoot Socket Errors in MySQL

MySQL manages connections to the database server through the use of a socket file, a special kind of file that facilitates communications between different processes. The MySQL server’s socket file is named mysqld.sock and on Ubuntu systems it’s usually stored in the /var/run/mysqld/…

Read more
Databases Checkpoint — step-by-step Databases tutorial on Progressive Robot

Databases Checkpoint

This checkpoint is intended to help you assess what you learned from our introductory articles to Databases, where we defined databases and introduced common database management systems.

Read more
How To Migrate Redis Data to a managed databases — step-by-step Linux tutorial on Progressive Robot

How To Migrate Redis Data to a managed databases

Redis provides a number of methods one can use to migrate data from one instance to another, like replication and snapshotting. However, migrations can get complicated when you’re moving data to a Redis instance managed by a cloud provider, as managed databases tend to limit how much control you have over the database’s configuration. This tutorial outlines one method you can use to migrate data to a Redis instance managed by the cloud provider using Redis’s internal MIGRATE command.

Read more
CHAT