Designing scalable systems – Part 1: The Basics
What to consider when designing scaling strategies for your web application to handle millions of users.
How to setup multiple WordPress on Ubuntu 16.04
In this tutorial, we will demonstrate how to setup multiple Wordpress websites on a same Ubuntu 16.04 server. The setup includes nginx, MySQL, PHP, and WordPress itself.
How to setup Linux, Nginx, MySQL, PHP (LEMP stack) on Ubuntu 16.04
In this guide, we will demonstrate how to install Nginx, MySQL and PHP (LEMP stack) on an Ubuntu 16.04 server.
How to type math notations using LaTex syntax in your WordPress
How to get those beautiful math notations in your Wordpress using Jetpack’s plugin and MathJax.
HA Proxy using VIP and keepalived
How to leverage keepalived features to proxy request(s) (both internal and external) with only 2 proxy servers, without forfeiting high availability.
Nginx security vulnerabilities and hardening best practices – part I
Nginx default configurations are vulnerable to multiple security exploits: slowloris, logjam, etc – just to name a few. Here are some best practices to harden your nginx server configurations.
Troubleshooting long transaction and failed transaction in SQL Server
When a transaction runs for too long, it may block other queries to your database. Here’s how we can find and kill it.
SQL Server – Log file too big and disk is full, now what?
Have you ever faced the problem when your transaction log grows too big and your disk is full?
You cannot shrink the transaction log file unless you do transaction log backup first. You cannot do the transaction log backup because your disk doesn’t have enough free space. The transaction log is getting bigger every minute. The clock is ticking. What will you do?
How to clear database cache in SQL Server
SQL Server is pretty smart when it comes to caching queries. However, for example, during optimizing query performance, we don’t want SQL Server to cache the query, so that we can see how well or how badly the query performs.
Troubleshooting Transaction Log in SQL Server
Dealing with SQL Server’s transaction log can be very troublesome.
Let’s take a look at some common use cases when dealing with transaction log in SQL Server.