Categories
General Sotfware & DevOps Storage Tools & HowTo

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 […]

Categories
Sotfware & DevOps Tools & HowTo

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, […]

Categories
Sotfware & DevOps Tools & HowTo

Relational Database Design: ER Modelling

In this article, we’ll explore the steps of ER modelling for database design. By the end, you will know what database design is and how to create an entity-relationship diagram (ER). In addition, you will also learn how to translate an ER from a case study.