Administration Section
How to translate business requirements into specific data structures using the example of designing a database for a messenger from scratch. Part 1: Designing the Database Framework Part 2: Live Partitioning Our database won't be as large and distributed as VKontakte or Badoo, but it should be functional, fast, and fit on a single PostgreSQL server — so that […]
We successfully designed the structure of our PostgreSQL database for storing messages, a year has passed, users are actively filling it, there are already millions of records, and... something has started to lag. Part 1: Designing the Database Framework Part 2: Live Partitioning The fact is that as the volume of the table increases, the 'depth' of the indexes also grows — albeit logarithmically. But over time, this […]
Other articles in the series: History of relays The "fast information transfer" method, or The birth of the relay Long-distance writer Galvanism Entrepreneurs And finally, the relay Talking telegraph Just connect Forgotten generation of relay computers Electronic era History of electronic computers Prologue Colossus ENIAC The electronic revolution History of the transistor Groping in the dark From the crucible of war Multiple reinventions History of the Internet Backbone network Dissolution, […]
Other articles in the series: History of relays The "fast information transfer" method, or The birth of the relay Long-distance writer Galvanism Entrepreneurs And finally, the relay Talking telegraph Just connect Forgotten generation of relay computers Electronic era History of electronic computers Prologue Colossus ENIAC The electronic revolution History of the transistor Groping in the dark From the crucible of war Multiple reinventions History of the Internet Backbone network Dissolution, […]
This post will describe the setup of HotFix automation in Maven projects using TeamCity. Typically, a lot of manual actions are required to implement a HotFix: creating a branch for the release where you want to deploy the HotFix, fixing the bug in the release, changing the bugfix version in the release branch, and deploying the bugfix version tag. Points 1, 3, and 4 can be automated. Before we proceed to […]
The holidays are over, and we are back with our second post in the Istio Service Mesh series. Today's topic is Circuit Breaker, which in electrical engineering terms means 'automatic switch' and colloquially refers to 'circuit protection switch'. However, in Istio, this switch disables not a shorted or overloaded circuit, but faulty containers. How this should ideally work When […]
Start the new year with a new PBX! However, there's not always time or desire to delve into the intricacies of transitioning between versions, gathering information from various sources. In this article, we have gathered all the information necessary for a simple and quick update to 3CX v16 Update 4 from older versions. There are many reasons to upgrade — we will cover all the features that have appeared in […]
Note: I apologize for the serious typo in the first version of the note. Thank you to all readers who reported the typo. God Mode is a convenient way to access Windows commands in a single window. Let's look at how to use this mode. God Mode is a special option that has long been available in Windows, giving you quick access to most […]
Clickhouse is a columnar database management system for online analytical processing (OLAP) with open source, developed by Yandex. It is used by Yandex, CloudFlare, VK.com, Badoo, and other services worldwide to store truly large amounts of data (inserting thousands of rows per second or petabytes of data stored on disk). In a typical 'row-based' DBMS, examples include […]
This article was written several years ago, when the blocking of the Telegram messenger was actively discussed within the community, and contains my thoughts on the matter. Although this topic is now almost forgotten, I hope it might still be of interest to someone. This text emerged from my reflections on digital security, and I hesitated for a long time on whether […]
An article about how I managed to launch a VPN server behind my home provider’s NAT (without a public IP address). I would like to clarify right away: the functionality of this implementation directly depends on the type of NAT used by your provider as well as your router. So, I found myself needing to connect from my Android smartphone to my home computer, both devices connected to the Internet through provider NATs, and additionally, the computer is connected […]
In this article, I present my thoughts on the history and prospects of the development of the internet, centralized and decentralized networks, and ultimately — the possible architecture of the next-generation decentralized network. Something is wrong with the internet. I first encountered the Internet in 2000. Of course, this is far from the very beginning — the Network had already existed before this, but […]