ProxySQL is a very powerful tool for the MySQL database. In simple words, it can tweak your MySQL when you have problems with slow queries or even it can be some kind of bridge between your MySQL databases placed in different localizations. Like in the name, it is a proxy, it’s placed between MySQL and application.
Varnish and HTTPS
Why doesn’t Varnish support SSL/TSL? This is a fact and there are many ways to handle this issue. If you want, it can be handled with NginX (as a TSL Terminatoin Proxy), in my opinion, Pound is a very good choice but not the only one. There are well-documended tutorials how to do this but I want to write about another problem witch, in my opinion, is not documented at all. How to redirect all requests to HTTP without an infinite loop?
What is Redis and what is Memcached? Why use Redis and when Memcached? Way we can call Redis a NoSQL database? Today I want to present my conclusions about which cache engine to use? Redis versus Memcached.