Articles tagged with: centos

How to enable HAProxy logs on CentOS 8
How to enable HAProxy logs on CentOS 8
Published Jan 6, 20202 min read0 comments
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
Install MySQL Community Server on CentOS 8
Published Jan 14, 20205 min read0 comments
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?
Where does MariaDB save output from SELECT INTO OUTFILE on CentOS 8?
Published Feb 1, 20203 min read0 comments
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 →
Copyright © 2017-2023   Mark Brody | Blog