Articles tagged with: centos
How to enable HAProxy logs on CentOS 8
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…
Read More →
Install MySQL Community Server on CentOS 8
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…
Read More →
Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
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]…
Read More →