Category: Administration

Understanding Message Brokers. Exploring the mechanics of messaging with ActiveMQ and Kafka. Chapter 1

Hello everyone! I've started translating a small book: 'Understanding Message Brokers', by Jakub Korab, published by O'Reilly Media, Inc., publication date: June 2017, ISBN: 9781492049296. From the introduction to the book: '… This book will teach you to think about message exchange systems using brokers by comparing and contrasting two popular broker technologies: Apache ActiveMQ and Apache Kafka. Here, use cases will be discussed […]

How to explain the difference between SQL and NoSQL to your grandma

One of the most important decisions a developer makes is which database to use. For many years, options were limited to various types of relational databases that supported Structured Query Language (SQL). These include MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, and many others. In the last 15 years, many new […]

Cross-replication between PostgreSQL and MySQL

I will broadly discuss cross-replication between PostgreSQL and MySQL, as well as methods for configuring cross-replication between these two database servers. Typically, databases in cross-replication are referred to as homogeneous, and this is a convenient method for transitioning from one relational DBMS server to another. PostgreSQL and MySQL databases are considered relational, but […]

pg_stat_statements + pg_stat_activity + loq_query = pg_ash?

As a brief addition to the article Attempt to Create an ASH Analog for PostgreSQL. Task: It is necessary to link the history of pg_stat_statements and pg_stat_activity. As a result, using the execution plan history from the service table log_query, you can obtain a wealth of useful information for resolving performance incidents and optimizing queries. Warning: Due to ongoing testing and development, the article is not […]

Kubecost Review for Kubernetes Cost Savings in the Cloud

More and more companies are currently transitioning their infrastructure from physical servers and their own virtual machines to the cloud. This decision is easy to explain: there is no need to worry about hardware, clusters can be easily configured in many different ways... and most importantly, existing technologies (like Kubernetes) allow for straightforward scaling of computing power based on load. The financial aspect is always important. The tool […]

DPI (SSL inspection) contradicts the essence of cryptography, yet companies are implementing it

Chain of trust. CC BY-SA 4.0 Yanpas SSL traffic inspection (SSL/TLS decryption, SSL analysis, or DPI) is becoming an increasingly hot topic of discussion in the corporate sector. The idea of decrypting traffic seemingly contradicts the very concept of cryptography. However, the fact is that more and more companies are using DPI technologies, explaining it by the need to check content for malware, data leaks, and other […]

CacheBrowser Experiment: Bypassing the Chinese Firewall without a proxy using content caching

Image: Unsplash Today, a significant portion of all content on the Internet is distributed using CDN networks. Studies have also explored how various censors exert their influence over such networks. Researchers from the University of Massachusetts analyzed possible methods of blocking CDN content, using practices of the Chinese authorities as an example, and developed a tool to bypass such blocks. We have prepared an overview containing the main findings and […]

We are raising our DNS-over-HTTPS server

The author has repeatedly addressed various aspects of DNS operations in a number of articles published on the blog. Throughout, the main focus has always been on enhancing the security of this critical Internet service. Until recently, despite the clear vulnerabilities of DNS traffic, which largely remains unencrypted, malicious actions from […]

Active session history in PostgreSQL — a new pgsentinel extension

The company pgsentinel has released its namesake extension pgsentinel (GitHub repository), which adds the pg_active_session_history view to PostgreSQL — a history of active sessions (similar to Oracle's v$active_session_history). Essentially, this is simply snapshots from pg_stat_activity taken every second, but there are important points: All accumulated information is stored only in memory, and the amount of memory consumed is regulated by the number of recent records stored. A queryid field is added — […]

Best Practices for Kubernetes Containers: Health Checks

TL;DR To achieve high observability of containers and microservices, as well as logs and primary metrics, it is not enough. To restore more quickly and enhance application resilience, the High Observability Principle (HOP) must be applied. At the application level, HOP requires proper logging, thorough monitoring, health checks, and performance/tracing checks. For HOP, use readinessProbe and livenessProbe checks in Kubernetes as an element. […]

How to migrate to the cloud in two hours thanks to Kubernetes and automation

The company 'URUS' experimented with Kubernetes in various forms: standalone deployment on bare metal, in Google Cloud, and then migrated its platform to Mail.ru Cloud Solutions (MCS). Igor Shishkin (t3ran), Senior Systems Administrator at 'URUS', explains how they chose their new cloud provider and managed to migrate to it in a record two hours. What 'URUS' does There are many ways […]

Ensuring reliable operation of Zextras Team in complex corporate networks

In the previous article, we introduced Zextras Team — a solution that adds corporate text and video chat functionality to Zimbra Collaboration Suite Open-Source Edition, as well as the ability to conduct video conferences with a large number of participants, without the need for third-party services and without transferring any data externally. This use case is ideal for companies with strict […]

Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster