Tag: Database Optimization

Load Balance MySQL Using HAProxy

Post author By Budi Santoso
Post date January 4, 2022
No Comments on Load Balance MySQL Using HAProxy

Load Balance HA MySQL with HAProxy. HAProxy or High Availability Proxy is a high performance open-source load balancer created to work (load balance) over TCP/HTTP. This is a Software that has several use cases you can chose, but it’s great for a MySQL load balancer. The company who makes HAProxy also develops many more products […]

Tags Database, Database Optimization, Databases, Docker, Docker Compose, haproxy mysql, High Availability (HA), Linux, MySQL, Project Management, Relational database design, SQL, SQL database, sql server

Sotfware & DevOps Tools & HowTo

Normalization of SQL Database: Remove Redundancy

Post author By Syed Umar Bukhari
Post date November 12, 2021
No Comments on Normalization of SQL Database: Remove Redundancy

Normalization of database is an essential skill to know as a database designer and developer. I still remember being intimidated by what it would bring on– back when I took a SQL database course. It was scary hearing about it. Let me assure you: it is easier than you might imagine. What is important though, […]

Tags Database, Database Optimization, Databases, Normal Forms, Normalization, Relational database design, SQL, SQL database