Мой новый домашний сервер, часть 4: использование unraid

Для тех, кому лень читать предыдущие части — я переходил с HP Microserver Gen8/Windows Server на самосборный сервер с Unraid в качестве базовой ОС. Unraid — это коммерческая ОС для NAS/домашнего сервера на базе ядра Linux. Основные возможности — гибкое управление массивом дисков, удобная установка докер-контейнеров из своего каталога и возможность запуска виртуальных машин. Почему выбрал именно unraid — написано во второй части.

Я не буду здесь расписывать установку и настройку unraid. Это делается элементарно — просто закидываются файлы на флэшку, флэшка вставляется в сервер — можно пользоваться. Всё понятно расписано у них на сайте, плюс много полезной информации есть на youtube-канале Spaceinvader One. Какие-то ранние вещи там уже устарели, потому, если видите несколько видео на одну тему, выбирайте более свежее. Ещё понятные доки на эту тему у ibracorp, есть и youtube-канал, если буквы не любите.
А я лучше просто опишу, как выглядят теперь перечисленные во второй части сервисы.
* Мой новый домашний сервер, часть 3: немного о сборке
* Мой новый домашний сервер, часть 2: выбор софта
* Мой новый домашний сервер, часть 1: выбор железа


Читать: https://habr.com/ru/post/649903/

MariaDB Xpand Crunches Cockroach with Sysbench

Read: https://mariadb.com/?p=30579

Keep an eye on these Next-Gen databases

Introduction
While I'm a sucker for a good Postgres instance, I do like to keep my finger on the pulse of new technologies to see what is out there. In this article, I'll play a little bit of a devils advocate against standard SQL databases while exp...

Read: https://pythondev.hashnode.dev/keep-an-eye-on-these-next-gen-databases

Как спроектировать базу данных, чтобы в будущем не пришлось её переписывать — базовые советы

Если вы работаете с базами данных, мало просто выучить SQL — нужно ещё и правильно спроектировать БД. Рассказываем о базовых правилах и возможных ошибках.

Читать: «Как спроектировать базу данных, чтобы в будущем не пришлось её переписывать — базовые советы»

11 задач по SQL с собеседований на позицию Data Engineer

Небольшие задачи на знание SQL с собеседований. Некоторые из них заставляют серьёзно задуматься даже опытных разработчиков баз данных.

Читать: «11 задач по SQL с собеседований на позицию Data Engineer»

Разбираемся в типах NoSQL СУБД

В этой статье мы познакомимся с 4 основными типами NoSQL баз данных: ключ-значение, документоориентированной, колоночной и графовой.

Читать: «Разбираемся в типах NoSQL СУБД»

Introduction to NoSQL

What is NoSQL?
NoSQL Database is a non-social information the executives framework that doesn't need a decent outline. Stay away from alternate ways and it's not difficult to climb. The fundamental objective of utilizing a NoSQL information base is t...

Read: https://kithminiii.hashnode.dev/introduction-to-nosql

Wiring up a database in the API service

Today I'll talk about how I set up the database for the API server of reread.to. It was a bit of a hassle and there were tons of things I didn't know. However, I think I've figured out the basics now and I'll tell you how I did it. In this article, I...

Read: https://stackdiving.com/wiring-up-a-database-in-the-api-service

How to integrate event streaming into your applications

Fauna's event streaming gives applications the ability to access and subscribe to real-time data. In this article, you learn how to integrate event streaming into your application.
We created a sample react app for you to follow along and explore ev...

Read: https://fauna.hashnode.dev/how-to-integrate-event-streaming-into-your-applications-cl0wi5qdq0593j6nvfmpp7row

How Kubernetes and Database Operators Drive the Data Revolution

Originally published at The New Stack.
These are challenging days for IT. The amount of data our systems need to process grows exponentially. This challenge is further amplified by the growing complexity of data. Information is useless without its co...

Read: https://chedim.com/how-kubernetes-and-database-operators-drive-the-data-revolution

Understanding SQL Server Common Table Expression - CTE

Common Table Expressions shortly called CTE or WITH clauses are named subqueries returning the data set. With CTE, we can break a long query into smaller parts making it simpler to understand and readable, and also supporting recursive implementation...

Read: https://mssqlserver.dev/understanding-sql-server-common-table-expression-cte

SQL Server Nested CTE with examples

After understanding the basics of CTE, multiple CTEs, and explanation in the previous post, in this post we will be exploring Nested CTEs in this post.
AS discussed, we can say that CTE is a named temporary set of rows similar to subqueries. Like sub...

Read: https://mssqlserver.dev/sql-server-nested-cte-with-examples

Recursive CTE in SQL Server with examples

After understanding the basics of CTE, Multiple CTEs, and Nested CTEs in the previous post of this CTE series, we will be exploring Recursive CTE in this post.
Recursion takes place when we invoke the block of code inside itself to perform repeated p...

Read: https://mssqlserver.dev/recursive-cte-in-sql-server-with-examples

Switchover And Failover

In today’s article we will talk about Switchover And Failover. Databases in Data Guard Environment can be in Primary and Standby (Physical, Logical & Snapshot) roles. With Role Management Services we can dynamically switch between these roles. We can change roles in two ways. One is Switchover and the other is Failover. Switchover 1.There is …

Read: Switchover And Failover.

REDIS, A cache database

If you are in the tech industry, working as a developer, or learning how to build a full-stack application. You must encounter the term REDIS.
Today, this article is based on the basics of REDIS.
What is REDIS?
Redis [Remote Dictionary Server] is a p...

Read: https://ayushak18.hashnode.dev/redis-a-cache-database

Table background/text color based on value table/database

Just to make it simple!
HTML tables allow you to arrange data into rows and columns. Generally having a HTML table with static data, you always have the possibility to decorate your table using the CSS colors of your choice. This article demonstrates...

Read: https://opere.hashnode.dev/table-backgroundtext-color-based-on-value-tabledatabase

Bo Peng: Installing Pgpool-II on Debian/Ubuntu

Read: https://postgr.es/p/5hN

SQL Queries For Mere Mortal Chapter 4: Creating a Simple Query

Simple Select Statment:

Don't write SQL Query immediately after reading the problem statement:

Search for nouns in the problem statement as it may be a table name or a column name.
Map the extracted nouns with the suitable table and column names.
...

Read: https://samra.hashnode.dev/sql-queries-for-mere-mortal-chapter-4-creating-a-simple-query

Compare and Find Row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), HASHBYTES()

In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary like when a ...

Read: https://mssqlserver.dev/compare-and-find-row-changes-in-sql-server-with-checksum-binarychecksum-hashbytes

CFGFWK-60850: Test Failed! Error

The topic of today’s article is CFGFWK-60850: Test Failed! Error. If you get CFGFWK-60850: Test Failed! Error during weblogic domain creation while installing Oracle middleware products, it means that the Wizard cannot communicate with the database. This may come up with messages such as version incompatibility or user name and password error in different ways, …

Read: CFGFWK-60850: Test Failed! Error.

9. Consistency and Consensus

This chapter is all about building fault tolerant distributed systems. We will look at tow measures for these - Consistency and consensus.
Consensus means all nodes of a distributed system agree on something(leader election, state of data etc.).
Con...

Read: https://rparthas.hashnode.dev/9-consistency-and-consensus-cl0zf26o404gisynv5rvdh8wz