I think the most commonly used one is MySQL. My point of view is one-sided since I have never used anything else, but if you're interested in speed more than anything, each intermediate release of MySQL (e.g. 5.5 -> 5.6 -> 5.7 etc.) has gained a substantial speed increase over the years. I would recommend going with MySQL 5.7. The next version that came out after 5.7 is version 8.0 (currently 8.0.12). Yes, they skipped a few numbers. Version 8.0 is much faster than 5.7, however, the latest version of
phpMyAdmin doesn't work with it yet. It only works with 5.7 and earlier. The bug was reported
here. They're working on it.
Something else to consider regarding speed is
Litespeed,
Nginx or
Apache. By far, the absolute fastest is Litespeed. Nginx is also blazing fast and is incredibly light and efficient (that's what I use). If you need a crap ton of functionality, go for Apache, but be warned, it is the slowest one when compared.
Moving on to PHP: The latest and greatest version is 7.2. It's super fast. In terms of speed, it isn't much faster than 7.1. Regarding 7.0, it's almost at
EOL and isn't worth considering anymore. As for 5.6, it's slower than the other two and approaching EOL as well, so avoid that.
Your website should have
http/2 enabled in the configuration file for even more speed. Using
https would be required, along with certificates for encryption.
And for more speed, enable TLS 1.2 and TLS 1.3
only. Do not enable or allow anything lower than those two specific versions. Regarding the
ssl_ciphers, these are the ones I recommend using for TLS 1.2 and 1.3 for the highest security:
Code: Select all
ssl_ciphers TLS13-AES-128-GCM-SHA256:TLS13-AES-256-GCM-SHA384:TLS13-CHACHA20-POLY1305-SHA256:EECDH+CHACHA20:EECDH+AESGCM:EECDH+AES+SHA384:EECDH+AES+SHA256;
And finally, use these sites to increase the security of your website:
I hope that helps. Good luck with your website!