Category: Administration

Data backup using FreeFileSync and 7-zip

The background, so to speak: Fujitsu rx300 s6 server, RAID6 made of 6 1TB disks, running XenServer 6.2, hosting several servers, including Ubuntu with multiple shares, 3.5 million files, 1.5TB of data, all gradually growing and bloating. The task: to set up data backup from the file server, partly on a daily basis, partly weekly. We have a Windows machine for backup with RAID5 […]

HighLoad++, Mikhail Makurov, Maxim Chernytsov (Interconnection): Zabbix, 100kNVPS on a single server

The next HighLoad++ conference will take place on April 6-7, 2020, in Saint Petersburg. Details and tickets can be found at the link. HighLoad++ Moscow 2018. Hall 'Moscow'. November 9, 15:00. Theses and presentation. * Monitoring — online and analytics. * Main limitations of the ZABBIX platform. * Solutions for scaling the analytics storage. * Optimization of the ZABBIX server. * UI optimization. * Operational experience […]

The inevitability of FPGA penetration into data centers

You don’t have to be a chip developer to program for FPGA, just as you don’t need to be a C++ programmer to write Java code. However, in both cases, it might be beneficial. The goal of commercializing both technologies, Java and FPGA, is to refute the last statement. The good news for FPGA is that with the right levels of abstraction and a set of […]

Fundamentals of PostgreSQL Monitoring. Alexey Lesovsky

Let's take a look at the report by Alexey Lesovsky from Data Egret titled 'Fundamentals of PostgreSQL Monitoring'. In this report, Alexey Lesovsky will discuss the key aspects of PostgreSQL statistics, what they mean, and why they should be included in monitoring; which graphs should be part of monitoring, how to add them, and how to interpret them. This report will be valuable for database administrators, system […]

Docker Compose: simplifying tasks using Makefile

Every few years, the software development industry experiences a paradigm shift. One such phenomenon is the increasing interest in the microservices concept. Although microservices are not a new technology, their popularity has soared recently. Large monolithic services are now being replaced by independent, autonomous microservices. A microservice can be seen as an application that […]

SQL HowTo: Writing a while-loop directly in a query, or 'An Elementary Three-Way'

There is periodically a task to search for related data by a set of keys until we accumulate the required total number of records. The most 'realistic' example is to display the 20 oldest tasks listed for employees (for instance, within a single department). This topic is often required for various management dashboards with brief overviews of work areas. In this article, we will discuss the implementation in PostgreSQL […]

VPN WireGuard included in the Linux kernel 5.6

Today, Linus transferred the net-next branch with WireGuard VPN interfaces to himself. This event was reported on the WireGuard mailing list. Currently, the code collection for the new Linux kernel 5.6 is ongoing. WireGuard is a fast next-generation VPN that implements modern cryptography. It was originally developed as a simpler and more user-friendly alternative to existing VPNs. The author is a Canadian expert in […]

Setting up a simple VPN with WireGuard and Raspberry Pi as the server

Since WireGuard will become part of the future Linux kernel 5.6, I decided to see how to best integrate this VPN with my LTE router/access point on the Raspberry Pi. The hardware is a Raspberry Pi 3 with an LTE module and a public IP address. Here will be the VPN server (referred to in the text as edgewalker). An Android phone that will use the VPN for all communications. A Linux laptop, […]

Tips and information sources for building serverless applications

Although serverless technologies have rapidly gained popularity in recent years, there are still many misconceptions and concerns associated with them. Vendor lock-in, toolsets, cost management, cold start, monitoring, and development lifecycle — all these topics are actively discussed when it comes to serverless technologies. In this article, we will look at some of the mentioned topics and also share […]

Introduction to the wal-g PostgreSQL Backup System

WAL-G is a simple and effective tool for backing up PostgreSQL to the cloud. In terms of its core functionality, it is a successor to the popular WAL-E tool, but rewritten in Go. However, WAL-G has one important new feature — delta backups. WAL-G delta backups store the file pages that have changed since the previous backup version. WAL-G implements a lot of technologies for parallel processing […]

Calico for networking in Kubernetes: an introduction and some experiences

The goal of this article is to introduce the reader to the basics of network interaction and network policy management in Kubernetes, as well as to the Calico third-party plugin that enhances standard capabilities. Convenience of configuration and some features will be demonstrated through real examples from our experience. A Quick Introduction to Kubernetes Networking It is impossible to imagine a Kubernetes cluster without a network. We have already published materials […]

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