Categories
General Sotfware & DevOps Storage Tools & HowTo

Load Balance MySQL Using HAProxy

HAProxy or High Availability Proxy is a high performance open-source TCP/HTTP load balancer. software that has several product choices. We can use community version as load balancer software on our servers. Discussing Load Balance with MySQL will be the key theme for this post. Load Balancers power the uptime of organizations with large infrastructures and […]

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.

Categories
Cloud Products

Cloud storage & Cloud Computing

All you need to know Cloud computing has revolutionized the way we do everything. We keep our photos, music files, and other important documents on Cloud storage systems that are globally distributed for easy access anywhere in the world! Cloud computing is a system of storing data on the internet. Instead of storing your files […]

Categories
General Sotfware & DevOps Tools & HowTo

How To Write MySQL CRUD Queries in Python

We will be using MySQL for the purposes of this post and connecting it with Python to write CRUD queries– you can use whatever flavor of SQL you are comfortable in (if you’re unsure which to pick, check out our post on How to Pick a SQL Flavor. By the end of this post, you will have found the answer to the question: “How To Write MySQL CRUD Queries In Python”.

Categories
Cloud Entrepreneurship General Sotfware & DevOps Storage Tools & HowTo

Picking the SQL Database For You

A Comparison of SQL Database Flavors: How To Pick The Right SQL Database Flavor For You? SQL, or Structured Query Language, is a database that has widespread uses with many flavors– which we will explore. As such, in our data-driven world, SQL is fast becoming an essential skill. Therefore, in this article, we will look […]

Categories
Cloud Entrepreneurship NiHao Cloud Documentation Products Sotfware & DevOps Storage Tools & HowTo

Active Directory AD and OpenLDAP for Security and SSO

You might be please to know that the Sesame Disk by Nihao Cloud storage now supports AD and OpenLDAP for Security and SSO. The idea is for you to be able to bring your own LDAP users from your server and thus secure your accounts using the same credentials as the ones people regularly use […]

Categories
Cloud Management and Projects Sotfware & DevOps Tools & HowTo

MySQL master-slave replication with docker

This post “MySQL master-slave replication with docker” was updated by Syed Umar Bukhari on August 26, 2021. As you may already know MySQL replication is a process to enable automatic copying of database(s) from one instance of MySQL to the other. Then docker and docker compose are orchestration tools. In this case, we will look […]

LinkedIn
LinkedIn
Share
WeChat
WhatsApp