Database Backups can take several formats. Backup size, backup time, and restore time will vary for each of these formats. In this post, we will use a 13 GB database with a total of 66 million rows to compare and evaluate the backup and restore time...
The common scenario for using Amazon RDS is to be connected to application servers. An example for this is a solution introduced by Amazon:
Elastic Load Balancer is a service provided by Amazon Web Services. ELB handles all incoming traffic, distributes all requests across multiple EC2 instances that actually fulfill the requests, fetches the responses, and sends it back to the client. There are many load balancing algorithms supported by...
Introducing Amazon RDS Amazon Relational Database service, or as it's known RDS, is a pre-packaged version of MySQL on Amazon services. Unlike it may seem, it's not just an EC2 instance with MySQL installed on it. The difference between RDS and EC2 with MySQL is that,...
CloudFront is a CDN (Content Delivery Network) Service offered by Amazon Web Services. CloudFront distribute web content (html, css, images, php, etc.) over more than 52 edge locations around the world to deliver the content more quickly. CloudFront serve the original content from the origin servers;...
The general idea behind using a load balancer is that it allows you to distribute the HTTP traffic across many nodes, i.e. Nginx is conncted to multiple backend servers (application servers ). Nginx handles all incoming requests, distributes them across the backend servers that actually...
When it comes to web server applications, there are two particular names that rise strongly; Apache and Nginx. So, what are the differences between these well-known web servers? and which one to pick? Introducing Apache The Apache HTTP Server is the most popular Linux-based web server. It was first...
Recently, a vulnerability in the design of SSLv3 was discovered by Google team. POODLE or "Padding Oracle On Downgraded Legacy Encryption" allows a man-in-the-middle attacker to trigger the downgrade to SSLv3, decrypting the HTTP secure connection and extracting important information. The issue was disclosed on Tuesday...
Before Mysql 5.6 indexes had some limitations like the range comparisons, if the part of the index used in a range comparison the part of the index after the range scans cannot be used by where conditions so mysql retrieves all rows which met only...
One of the main methods of optimization is web caching, which is simply a method to store a copy of the web content to accelerate the serving it to the client. The most famous caching method is setting up a reverse proxy in-front of the web server...
