Server Optimization

How To Configure Periodic TRIM for SSD Storage on Linux Servers — step-by-step Linux tutorial on Progressive Robot

How To Configure Periodic TRIM for SSD Storage on Linux Servers

Continuous use of SSDs results in degraded performance if not accounted for and mitigated. The TRIM command is an operation that allows the operating system to propagate information down to the SSD about which blocks of data are no longer in use. This allows the SSD’s internal systems to better manage wear leveling and prepare the device for future writes. Continuous TRIM is possible, but can negatively impact performance. Scheduled, periodic TRIM is a good alternative in most cases.

Read more
How To Install Apache mod_spdy on a Debian 7 VPS — step-by-step Linux tutorial on Progressive Robot

How To Install Apache mod_spdy on a Debian 7 VPS

Apache mod_spdy is an open source Apache module that allows Apache web servers to serve HTTPS requests using the SPDY protocol. SPDY (pronounced as “SPeeDY”) is a new protocol created to address speed related problems with the HTTP protocol; it allows the client and server to pass multiple requests over a single connection, compress request and response headers, and all the server to push site resources to the client without the client requesting them.

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
How To Use HAProxy to Set Up MySQL Load Balancing — step-by-step Linux tutorial on Progressive Robot

How To Use HAProxy to Set Up MySQL Load Balancing

HAProxy is an open source software which can load balance HTTP and TCP servers. In the previous article on HAProxy we configured load balancing for HTTP and in this one we’ll do the same for MySQL. All your MySQL servers have to be configured to perform Master-Master replication as load balancing involves both reading and writing to all the backends.

Read more
How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04 — step-by-step Linux tutorial on Progressive Robot

How To Add NoSQL Queries to MySQL with memcached on Ubuntu 14.04

Memcached as a standalone server works as an intermediary in front of the MySQL client access layer and manages information only in the memory without an option to store it persistently. This makes it suitable for tasks such as caching the results of duplicate MySQL queries. In this article, memcached will be installed as a MySQL plugin and tightly integrated into MySQL. It will provide a NoSQL style access layer for managing information directly in regular MySQL InnoDB tables.

Read more
How To Optimize MySQL with Query Cache on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Optimize MySQL with Query Cache on Ubuntu 18.04

Query cache is a prominent MySQL feature that speeds up data retrieval from a database. In this tutorial, you will first configure MySQL without query cache and run queries to see the duration results. Then you’ll set up query cache and test your MySQL server with it enabled to show the difference in performance.

Read more
CHAT