MySQL

How To Install MySQL on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Install MySQL on CentOS 8

MySQL is an open-source database management system, commonly installed as part of the popular LEMP (Linux, Nginx, MySQL/MariaDB, PHP/Python/Perl) stack. It implements the relational model and Structured Query Language (SQL) to manage and query data. This tutorial explains how to install MySQL version 8 on a CentOS 8 server.

Read more
How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04

ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database to create a caching layer to optimize MySQL queries. In this tutorial, you will use ProxySQL to set up transparent caching for a MySQL server on Ubuntu 16.04. You will then test its performance using mysqlslap with and without caching to demonstrate the effect of caching and how much time it can save when executing many similar queries.

Read more
CHAT