• Guest
HabraHabr
  • Main
  • Users

  • Development
    • Programming
    • Information Security
    • Website development
    • JavaScript
    • Game development
    • Open source
    • Developed for Android
    • Machine learning
    • Abnormal programming
    • Java
    • Python
    • Development of mobile applications
    • Analysis and design of systems
    • .NET
    • Mathematics
    • Algorithms
    • C#
    • System Programming
    • C++
    • C
    • Go
    • PHP
    • Reverse engineering
    • Assembler
    • Development under Linux
    • Big Data
    • Rust
    • Cryptography
    • Entertaining problems
    • Testing of IT systems
    • Testing Web Services
    • HTML
    • Programming microcontrollers
    • API
    • High performance
    • Developed for iOS
    • CSS
    • Industrial Programming
    • Development under Windows
    • Image processing
    • Compilers
    • FPGA
    • Professional literature
    • OpenStreetMap
    • Google Chrome
    • Data Mining
    • PostgreSQL
    • Development of robotics
    • Visualization of data
    • Angular
    • ReactJS
    • Search technologies
    • Debugging
    • Test mobile applications
    • Browsers
    • Designing and refactoring
    • IT Standards
    • Solidity
    • Node.JS
    • Git
    • LaTeX
    • SQL
    • Haskell
    • Unreal Engine
    • Unity3D
    • Development for the Internet of things
    • Functional Programming
    • Amazon Web Services
    • Google Cloud Platform
    • Development under AR and VR
    • Assembly systems
    • Version control systems
    • Kotlin
    • R
    • CAD/CAM
    • Customer Optimization
    • Development of communication systems
    • Microsoft Azure
    • Perfect code
    • Atlassian
    • Visual Studio
    • NoSQL
    • Yii
    • Mono и Moonlight
    • Parallel Programming
    • Asterisk
    • Yandex API
    • WordPress
    • Sports programming
    • Lua
    • Microsoft SQL Server
    • Payment systems
    • TypeScript
    • Scala
    • Google API
    • Development of data transmission systems
    • XML
    • Regular expressions
    • Development under Tizen
    • Swift
    • MySQL
    • Geoinformation services
    • Global Positioning Systems
    • Qt
    • Dart
    • Django
    • Development for Office 365
    • Erlang/OTP
    • GPGPU
    • Eclipse
    • Maps API
    • Testing games
    • Browser Extensions
    • 1C-Bitrix
    • Development under e-commerce
    • Xamarin
    • Xcode
    • Development under Windows Phone
    • Semantics
    • CMS
    • VueJS
    • GitHub
    • Open data
    • Sphinx
    • Ruby on Rails
    • Ruby
    • Symfony
    • Drupal
    • Messaging Systems
    • CTF
    • SaaS / S+S
    • SharePoint
    • jQuery
    • Puppet
    • Firefox
    • Elm
    • MODX
    • Billing systems
    • Graphical shells
    • Kodobred
    • MongoDB
    • SCADA
    • Hadoop
    • Gradle
    • Clojure
    • F#
    • CoffeeScript
    • Matlab
    • Phalcon
    • Development under Sailfish OS
    • Magento
    • Elixir/Phoenix
    • Microsoft Edge
    • Layout of letters
    • Development for OS X
    • Forth
    • Smalltalk
    • Julia
    • Laravel
    • WebGL
    • Meteor.JS
    • Firebird/Interbase
    • SQLite
    • D
    • Mesh-networks
    • I2P
    • Derby.js
    • Emacs
    • Development under Bada
    • Mercurial
    • UML Design
    • Objective C
    • Fortran
    • Cocoa
    • Cobol
    • Apache Flex
    • Action Script
    • Joomla
    • IIS
    • Twitter API
    • Vkontakte API
    • Facebook API
    • Microsoft Access
    • PDF
    • Prolog
    • GTK+
    • LabVIEW
    • Brainfuck
    • Cubrid
    • Canvas
    • Doctrine ORM
    • Google App Engine
    • Twisted
    • XSLT
    • TDD
    • Small Basic
    • Kohana
    • Development for Java ME
    • LiveStreet
    • MooTools
    • Adobe Flash
    • GreaseMonkey
    • INFOLUST
    • Groovy & Grails
    • Lisp
    • Delphi
    • Zend Framework
    • ExtJS / Sencha Library
    • Internet Explorer
    • CodeIgniter
    • Silverlight
    • Google Web Toolkit
    • CakePHP
    • Safari
    • Opera
    • Microformats
    • Ajax
    • VIM
  • Administration
    • System administration
    • IT Infrastructure
    • *nix
    • Network technologies
    • DevOps
    • Server Administration
    • Cloud computing
    • Configuring Linux
    • Wireless technologies
    • Virtualization
    • Hosting
    • Data storage
    • Decentralized networks
    • Database Administration
    • Data Warehousing
    • Communication standards
    • PowerShell
    • Backup
    • Cisco
    • Nginx
    • Antivirus protection
    • DNS
    • Server Optimization
    • Data recovery
    • Apache
    • Spam and antispam
    • Data Compression
    • SAN
    • IPv6
    • Fidonet
    • IPTV
    • Shells
    • Administering domain names
  • Design
    • Interfaces
    • Web design
    • Working with sound
    • Usability
    • Graphic design
    • Design Games
    • Mobile App Design
    • Working with 3D-graphics
    • Typography
    • Working with video
    • Work with vector graphics
    • Accessibility
    • Prototyping
    • CGI (graphics)
    • Computer Animation
    • Working with icons
  • Control
    • Careers in the IT industry
    • Project management
    • Development Management
    • Personnel Management
    • Product Management
    • Start-up development
    • Managing the community
    • Service Desk
    • GTD
    • IT Terminology
    • Agile
    • Business Models
    • Legislation and IT-business
    • Sales management
    • CRM-systems
    • Product localization
    • ECM / EDS
    • Freelance
    • Venture investments
    • ERP-systems
    • Help Desk Software
    • Media management
    • Patenting
    • E-commerce management
    • Creative Commons
  • Marketing
    • Conferences
    • Promotion of games
    • Internet Marketing
    • Search Engine Optimization
    • Web Analytics
    • Monetize Web services
    • Content marketing
    • Monetization of IT systems
    • Monetize mobile apps
    • Mobile App Analytics
    • Growth Hacking
    • Branding
    • Monetize Games
    • Display ads
    • Contextual advertising
    • Increase Conversion Rate
  • Sundry
    • Reading room
    • Educational process in IT
    • Research and forecasts in IT
    • Finance in IT
    • Hakatonas
    • IT emigration
    • Education abroad
    • Lumber room
    • I'm on my way

How to scale down databases in Yandex. Cloud without downtime. An example with three hosts is

[i] The post was prepared by the members of the Yandex.Oblaka team: Ivan Vettsov - architect, Leonid Klyuev - editor 3r-38. 3r311.
 
How to scale down databases in Yandex. Cloud without downtime. An example with three hosts is Recently, we are told r3r366. about architecture 3r350. Yandex. Cloud 3r3r666. . Now let's move from theory to practice. There are several services in the Cloud for automated DBMS control: Managed Service for ClickHouse, Managed Service for PostgreSQL and Managed Service for MongoDB. All of them are platform and allow you to focus on the task of storing data, and not on the administration of the infrastructure. But sometimes it is important to control the cluster virtual machines as well. For example, a scaling problem may arise in response to an increase or decrease in load. Usually this scenario is one of the most time consuming from a practical point of view. Today we will tell how Yandex.Oblako allows you to automate complex scaling tasks, and make sure that the database remains available during the process of changing the size of the cluster.
 
3r366.

Task setting 3r33252.
 
When creating a cluster of each service, the user can determine the number of cluster hosts and the availability zone (availability zone, AZ), which corresponds to the physical data center. Yandex.Oblako now uses three Yandex data centers located in the central region of Russia. Therefore, the recommended configuration is a cluster of a DBMS with three hosts - as the most consistent with the principles of building a fault-tolerant and disaster-resistant architecture.
 
 
So, let us imagine a situation where the load on the database cluster has exceeded the capabilities of the base and it is time to add computing resources. This can be done both horizontally - by adding hosts to the cluster, and vertically - by adding resources to each cluster machine. Consider the second option, as the most time-consuming and at risk of errors. Why is this option laborious? Because in the general case, the procedure for adding resources will look like this: switching the role of the host; if necessary, stop the DBMS; turn off the virtual machine; change its configuration; we start; change the parameters of the DBMS; run the DBMS; waiting for the synchronization of accumulated data changes. And so for all three hosts in turn. Many steps - the risk of a mistake is high. You can automate this process - only before starting the selected automation solution must be tested. Usually, there is not enough time for testing, but in Yandex. Cloud it runs quickly and without unnecessary actions on your part. Let's get started
 
 
Preliminary steps and testing process 3r33252.
 
For the preparation we need:
 
 
Access to the platform. Now anyone can set up a trial period on the site 3r350. on the site Yandex. Cloud 3r3666. .
 
The cloud network (I will call it testvpc in my example) and three subnets located in different AZ. The address ranges of subnets in this case are not important.
 
Bastion host. Despite the fact that in Yandex. Oblak you can open external access to the database through a public IP, publishing a publicly accessible database is not the right solution. Therefore, we will add to the scheme a bastion host, from which we will open connections to the hosts. As such a host, you can use a machine with a partial (5 percent) use of the kernel. You need to install
on the virtual machine. clickhouse-client
. In addition, according to 3r360. Connection instructions 3r3666. to the service, you need to download the SSL certificate.
 
CLI. We will work with Yandex. Oblakom not via the console, but through the command line utility, which must also be installed and initiated according to 3r3365. 3r366 documentation. .
 
 
The test script will be simple: we open three sessions connecting the bastion host to each host of the database cluster, run a SQL query in a loop with a period of, say, 1 second, after which we send the command to scale the cluster and look at the behavior of the system.
 
The moment of truth


 
Since the scaling process is approximately the same in the case of all three DBMS, for example, take one of them - ClickHouse.
 
Let's create an experiment object - a cluster consisting of three hosts located in different virtual subnets. To do this, enter the command
 
3r3162. yc managed-clickhouse cluster create with the necessary arguments. The order of the arguments corresponds to their listing in the “yc --help” output. The essence of the command is simple: we create a ch-to-resize cluster in the production environment with the testvpc virtual network, set the name and password, the disk space is 10 gigabytes and the minimum class is s1.nano. The following characteristics correspond to this class: 1 CPU, 4 GB RAM. In the future, for scaling, we move on to the class s1.micro so that the number of CPU and RAM doubled. To find out what other classes of hosts you can assign, just enter the command 3r-3260.  
3r3162. yc managed-clickhouse resource-preset list .
 
Thus, the team to create a cluster should be as follows: 3r326565.
 
3r3173. 3r3174. yc managed-clickhouse cluster create --name ch-to-resize --environment production --network-name testvpc --host zone-id = ru-central1-a, subnet-id = e9bfnjacigdo9p6j7j2s, assign-public-ip = false , type = clickhouse - host zone-id = ru-central1-b, subnet-id = e2l8iamol3b9mrtskb8q, assign-public-ip = false, type = clickhouse -host zone-id = ru-central1-c, subnet-id = b0c6qit7u9e8r0egedvj, assign-public-ip = false, type = clickhouse --user name = test, password = test123123 --database name = testdb --clickhouse-disk-size 10 --clickhouse-resource-preset s1.nano - clickhouse-disk-type network-nvme –async
 
In response, we get the cluster ID and the list of hostnames of its hosts:
 
3r3173. 3r3174. yc managed-clickhouse cluster list
+ ---------------------- + -------------- + ----------- ------------------ + -------- + --------- +
| ID | NAME | CREATED AT | HEALTH | STATUS |
+ ---------------------- + -------------- + ----------- ------------------ + -------- + --------- +
| c9q7cr4ji2fe462qej8p | ch-to-resize | 2018-12-10T08: 59: ???Z | ALIVE | RUNNING |
+ ---------------------- + -------------- + ----------- ------------------ + -------- + --------- +
yc managed-clickhouse host list --cluster-id c9q7cr4ji2fe462qej8p
+ ------------------------------------------- + ----- ----------------- + --------- + --------------- +
| NAME | CLUSTER ID | HEALTH | ZONE ID |
+ ------------------------------------------- + ----- ----------------- + --------- + --------------- +
| rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | ALIVE | ru-central1-a |
| rc1a-sgxazra54xv6lhni.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | UNKNOWN | ru-central1-a |
| rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | ALIVE | ru-central1-b |
| rc1b-j1rtvsuz6t8x6ev2.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | UNKNOWN | ru-central1-b |
| rc1c-emo0f2990povj7ie.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | UNKNOWN | ru-central1-c |
| rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net | c9q7cr4ji2fe462qej8p | ALIVE | ru-central1-c |
+ ------------------------------------------- + ----- ----------------- + --------- + --------------- +
 
Open a connection to each host and run a query to the database:
 
3r3173. 3r3174. clickhouse-client - host rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net --secure --user test --password test123123 --database testdb --port 9440 -q "select concat (host_name, 'is alive!') from system .clusters where replica_num = 1 "
clickhouse-client - host rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net --secure --user test --password test123123 --database testdb --port 9440 -q "select concat (host_name, 'is alive!') from system .clusters where replica_num = 2 "
clickhouse-client - host rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net --secure --user test --password test123123 --database testdb --port 9440 -q "select concat (host_name, 'is alive!') from system .clusters where replica_num = 3 "
 
Finally, send a request to increase the cluster:
 
3r3173. 3r3174. yc managed-clickhouse cluster update --id c9q7cr4ji2fe462qej8p --clickhouse-resource-preset s1.micro-–async
 
Explanation of the case of a reduced cluster [/b] 3r3158.
If we want to reduce rather than increase the amount of resources, then we need to specify a smaller class, referring to conclusion 3r-3260.  
3r3162. yc managed-clickhouse resource-preset list - for example, s1.nano. In this case, the structure of the team itself remains the same.
 
I redirected requests to the file. Here is an abbreviated listing:
 
3r3173. 3r3174. rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net
Mon Dec ???:47:35 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:47:36 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:47:37 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:47:38 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:47:39 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:47:40 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.7:9440: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:47:51 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.7:9440: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:02 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.7:9440: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:11 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:12 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:13 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:14 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:15 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:16 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:17 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net:944? ???.7)
Mon Dec ???:48:18 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:48:19 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
Mon Dec ???:48:20 UTC 2018 rc1c-wcxq53lq096m0o6h.mdb.yandexcloud.net is alive!
rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:
Mon Dec ???:50:58 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
Mon Dec ???:50:59 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
Mon Dec ???:51:00 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
Mon Dec ???:51:01 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.6:9440: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:12 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.6:9440: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:23 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.6:9440: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:34 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.6:9440: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:35 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:36 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:37 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:38 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:39 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6) 3r33232. Mon Dec ???:51:40 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:41 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:42 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:43 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net:944? ???.6)
Mon Dec ???:51:44 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
Mon Dec ???:51:45 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
Mon Dec ???:51:46 UTC 2018 rc1a-qysm9t78x5ybdb78.mdb.yandexcloud.net is alive!
rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:
Mon Dec ???:49:15 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:49:16 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:49:17 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:49:18 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:49:19 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.8:9440: (rc1b-2t82xtpsccr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:30 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.8:9440: (rc1b-2t82xtpsccr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:41 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.8:9440: (rc1b-2t82xtpsccr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:52 UTC 2018 Code: 209. DB :: NetException: Timeout: connect timed out: ???.8:9440: (rc1b-2t82xtpsccr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:56 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:57 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:58 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:49:59 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:50:00 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:50:01 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:50:03 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:50:04 UTC 2018 Code: 210. DB :: NetException: Connection refused: (rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net:944? ???.8)
Mon Dec ???:50:05 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:50:06 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
Mon Dec ???:50:07 UTC 2018 rc1b-2t82xtpscgr4gi6j.mdb.yandexcloud.net is alive!
 
Listing shows the moments when each host of the cluster is turned off (when connect time out starts), the moments when the host is turned on and ClickHouse starts loading (when the connection refused starts), as well as moments when the host returns to the system. The most important thing is the separation of time periods when the hosts were unavailable. As long as the scaling went on, at least two hosts were available for querying. This can be seen on the chart:
 

 

Conclusions and best practices


 
At first glance, the development of projects with databases includes a large amount of routine work. The database must be maintained, that is, backed up, adjusted to the process of regularly updating the DBMS, etc. Cloud management services appeared first of all in order to remove these labor-consuming functions from you. However, in a real production-environment, it is useful that the systems are not only manageable from the point of view of maintenance, but also flexible - responsive to the rise and fall of the load. We told how to increase the performance of the database in Yandex.Oblak, while preserving the performance of the project for users. If the base is configured correctly, then with the growth of traffic there is an increase in the volume of available resources, and during a recession - a multiple decrease, which also saves your costs.
 
 
What approaches, tools, or technologies on a cloud topic would you like to know? Suggest in the comments topic for the following posts Yandeks.Oblaka.

It may be interesting

  • Comments
  • About article
  • Similar news
veronicasegura 31 January 2020 10:29
I am very much eager to reveal this page. I have to thank you for ones time for this especially incredible read !! I unquestionably truly enjoyed all aspects of it and I likewise have you spared to fav to take a gander at new data in your site. This articles causes me more.Thanks for your sharing,I will pay more considerations to your blog. Anticipating your better and better articles.See you next time. Look into my website write my essay, if you are in search of writing tips.
Ed Gentry 5 November 2020 16:14
Nice blog! Found a useful site recently. I am a student, and often, there is no time to solve difficult problems. I usually order my homework here. 
  Show/hide text
https://domyhomeworkfor.me/chemistry-homework-help



So, here you can find good specialists for doing your homework https://domyhomeworkfor.me/chemistry-homework-help
Alex Harris 20 November 2020 18:31
Essays, especially creative ones, help students develop their minds and help them create their own ideas. Writing an essay is the same as writing a personal statement. A personal statement is no different from a creative essay do my homework for me. The only difference is that in a personal statement, the details must be factual, whereas in a creative essay, stories may not be factual if they are interesting.

weber

Author

21-12-2018, 11:37

Publication Date

IT Infrastructure / Database Administration / Yandex API

Category
  • Comments: 3
  • Views: 3 435
Evolution of Backend as a Service: The
Yandex opens the Cloud. The
Express performance review of
MongoDB is changing its open source
Working with Veeam Availability
How IaaS helps develop the car market
Write a comment
Name:*
E-Mail:


Comments
Visit Our website If You Need Custom thanksgiving couple shirts, Shirts For Your Company, Family Or Friends & We’ll Cook Something Special for you!
Yesterday, 21:10

raymond weber

Inursing test bank was very pleased  to find this site.I wanted to thank you for this great read!! I definitely  enjoying every little bit of it and I have you bookmarked to check out new  stuff you post.  
Yesterday, 18:20

taxiseo2

You completed certain  reliable points there. I did a search on the subject and found nearly all  persons will agree with your blog.  
nursing test bank
Yesterday, 18:04

taxiseo2

Great post i must say  and thanks for the information. Education is definitely a sticky subject.  However, is still among the leading topics of our time. I appreciate your  post and look forward to more.
nursing test bank
Yesterday, 17:29

taxiseo2

So good! This web post provides knowledge, knowledge, good news, and is very useful. Thank you for everything Taxi Driver Jacket
Yesterday, 15:35

MalenaMorgan

Adv
Website for web developers. New scripts, best ideas, programming tips. How to write a script for you here, we have a lot of information about various programming languages. You are a webmaster or a beginner programmer, it does not matter, useful articles will help to make your favorite business faster.

Login

Registration Forgot password