HAProxy is an open-source, high availability load balancer that quietly sits in front of any TCP/HTTP service. It's well-known for its efficiency and reliability, and often used to manage the traffic of high-volume and distributed systems. If you're using HAProxy, you may have come across a situation where you're looking through application logs only to realize that you can't find the information you're looking for. For example, maybe you're looking in apache logs trying to isolate the IP of a web…

CentOS distributes MariaDB 10.3, a drop-in replacement for MySQL Server 5.7. If you require MySQL 8, there are a few new steps on CentOS 8 that differ from past versions. All steps should be performed as the root user. bash sudo su Code snippets that start with a # prompt contain sample output and should not be copied verbatim. Start by downloading the GPG key and saving it in /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql bash wget -O /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql…

SELECT INTO OUTFILE is used to export query results to file and can be formatted using additional export options. By default, columns are separated by tabs ( \t ) while rows are separated by newlines ( \n ). From the MariaDB documentation, [https://mariadb.com/kb/en/select-into-outfile/](https://mariadb.com/kb/en/select-into-outfile/) sql SELECT ... INTO OUTFILE 'file_name' CHARACTER SET charset_name] export_options] export_options: FIELDS | COLUMNS} TERMINATED BY 'string'] OPTIONALLY]…