Posts

Showing posts with the label AWS Load Balancer Types

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Load Balancers in AWS: Choosing the Right Option for Your Application

Image
The load balancer's purpose is to balance the incoming traffic. It allocates the incoming traffic to the available healthy servers. Here are the top AWS load balancers. AWS Load balancers These are Application Load Balancer, Gateway Load Balancer, and Network Load Balancer. Application Load Balancers Gateway Load Balancers Network Load Balancers   1. Application Load Balancers (ALB) A Load balancer contains two parts - Listeners and Target groups. The listener then connects to a target group. The listener first checks the availability of connection according to the IP address and Port you did configure. Adopted from Amazon AWS   2. Gateway Load Balancers (GWLB) A Gateway Load Balancer receives traffic from the source and sends the traffic to targets. It sends requests to multiple virtual appliances. It's the prime difference between ALB and GWLB. 3. Network Load Balancers (NLB) A Network Load Balancer functions at the fourth layer of the Open Systems Interconnection (OSI) model