Exploring the Database System Architecture for Microservices World

Containers and container management

Still, systems such as Docker and Kubernetes changed how we deploy and manage applications, democratizing the whole process with more features and tooling only a few years ago. The idea of microservices comes from the service-oriented architecture world. The concept of SOA is an enterprise-level concept, whereas microservices is an architectural concept.

Microservices offer several advantages

While there has been a lot of emphasis on tooling and professional support for microservices, the database space has largely been ignored and not talked about. In this article, we will see why approaching database design from a microservices perspective is wrong and how best to design our databases and particularly about how to split our database systems for horizontal scaling. The majority of this article is focused on traditional database systems such as PostgreSQL, MySQL, Maria DB, etc. However, the concepts do extend to other database systems, including NoSQL.

#microservices #database

What is GEEK

Buddha Community

Exploring the Database System Architecture for Microservices World

Ruth Nabimanya

1620633584

System Databases in SQL Server

Introduction

In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server.

System Database

Fig. 1 System Databases

There are five system databases, these databases are created while installing SQL Server.

Master
Model
MSDB
Tempdb
Resource

Master

This database contains all the System level Information in SQL Server. The Information in form of Meta data.
Because of this master database, we are able to access the SQL Server (On premise SQL Server)

Model

This database is used as a template for new databases.
Whenever a new database is created, initially a copy of model database is what created as new database.

MSDB

This database is where a service called SQL Server Agent stores its data.
SQL server Agent is in charge of automation, which includes entities such as jobs, schedules, and alerts.

TempDB

The Tempdb is where SQL Server stores temporary data such as work tables, sort space, row versioning information and etc.
User can create their own version of temporary tables and those are stored in Tempdb.
But this database is destroyed and recreated every time when we restart the instance of SQL Server.

Resource

The resource database is a hidden, read only database that holds the definitions of all system objects.
When we query system object in a database, they appear to reside in the sys schema of the local database, but in actually their definitions reside in the resource db.

#sql server #master system database #model system database #msdb system database #sql server system databases #ssms #system database #system databases in sql server #tempdb system database

Destiny Volkman

1600088400

Serverless Vs Microservices Architecture - A Deep Dive

Companies need to be thinking long-term before even starting a software development project. These needs are solved at the level of architecture: business owners want to assure agility, scalability, and performance.

The top contenders for scalable solutions are serverless and microservices. Both architectures prioritize security but approach it in their own ways. Let’s take a look at how businesses can benefit from the adoption of serverless architecture vs microservices, examine their differences, advantages, and use cases.

#serverless #microservices #architecture #software-architecture #serverless-architecture #microservice-architecture #serverless-vs-microservices #hackernoon-top-story

Arlo McLaughlin

1600034400

The Service Mesh in the Microservices World - DZone Microservices

The software industry has come a long journey and throughout this journey, Software Architecture has evolved a lot. Starting with 1-tier (Single-node), 2-tier (Client/ Server), 3-tier, and Distributed are some of the Software Architectural patterns we saw in this journey.

The Problem

The majority of software companies are moving from Monolithic architecture to Microservices architecture, and Microservices architecture is taking over the software industry day-by-day. While monolithic architecture has many benefits, it also has so many shortcomings when catering to modern software development needs. With those shortcomings of monolithic architecture, it is very difficult to meet the demand of the modern-world software requirements and as a result, microservices architecture is taking control of the software development aggressively. The Microservices architecture enables us to deploy our applications more frequently, independently, and reliably meeting modern-day software application development requirements.

#microservice architecture #istio #microservice best practices #linkerd #microservice communication #microservice design #envoy proxy #kubernetes architecture #api gateways #service mesh architecture

Ruth Nabimanya

1620640920

How to Efficiently Choose the Right Database for Your Applications

Finding the right database solution for your application is not easy. Learn how to efficiently find a database for your applications.

Finding the right database solution for your application is not easy. At iQIYI, one of the largest online video sites in the world, we’re experienced in database selection across several fields: Online Transactional Processing (OLTP), Online Analytical Processing (OLAP), Hybrid Transaction/Analytical Processing (HTAP), SQL, and NoSQL.

Today, I’ll share with you:

What criteria to use for selecting a database.
What databases we use at iQIYI.
Some decision models to help you efficiently pick a database.
Tips for choosing your database.

I hope this post can help you easily find the right database for your applications.

#database architecture #database application #database choice #database management system #database management tool

Ruth Nabimanya

1635013920