In the comments to one of the previous articles about the choice of server 1C raised an interesting question about the rationality of the configuration "for growth". I decided to cover this issue in more detail, taking into account several options for acquiring a server and renting resources in a public cloud. We will try to spend the budget with maximum benefit for the cause.

For clarity, let's imagine that we choose iron for a small abstract company.

Meet - LLC "UFO"

The UFO limited liability company employs about 20 people and it needs three 1C bases of the following configurations:

1. Salary and Personnel Management;

   
   

2. Accounting;

   
   
3. Trade management.

The platform is a classic based on Microsoft Windows Server and Microsoft SQL. Since 1C runs on the same machine as SQL, you can use the added benefit of Shared Memory .

In my practice, administrators sometimes forget about setting Shared Memory, and this alone increases the speed by 10-15%

A thin client is suitable for access to the databases, which will make it possible not to depend on the performance of the user computers and not to raise the terminal server.

For estimating the size of bases, I mainly used my past experience:

• 2 GB, Salary and Personnel Management, the user - one personnel officer;

  
  

• 1 GB, Accounting - two accountants;

  
  
• 5 GB, Trade Management - nineteen users, including accountants.

Selection of the server configuration for 1C is a creative process, so we arm ourselves with useful articles on this subject , recall the previous publication of the Server Mall and get the following requirements:

• Processor: 4 cores;

  
  

• RAM: from 16 GB;

  
  
• Disk system: RAID1, at least 200 GB.

But the minimum recommended configuration does not take into account periodic bursts of reporting periods and all-in-one hands-on. In addition, after a year, such a server may not be enough for a comfortable work of the increased number of users.

In general, I added SSD disks to these requirements and counted a new server in the vendor configurator Supermicro :

Remember this figure and return to the planning.

And what will happen next year?

Small companies tend to grow, so let's imagine that the state has almost doubled. Now the size of the bases and the number of users looks like this:

• 4 GB is occupied by the Salary and Personnel Management , the number of personnel officers is two;

  
  

• 2 GB - Accounting , four accountants;

  
  
• 40 GB - Trade Management , thirty-eight employees work with it.

The base "Management of Trade" is growing faster, because usually it is the organization's document flow

A greater number of users and an increased volume of databases inevitably lead to problems with speed. Within the framework of the article, we will not consider diagnostics and studying the causes of such a situation, but simply add 1C resources.

There are several options:

• Upgrade an existing server;

  
  
• Rent a part of the resources in the cloud.

If the performance slipped without a significant increase in the number of users, then it is still worth doing diagnostics. As a rule, the reasons are intricate processing and reports that are found even in typical configurations. Or blocking SQL, low memory and insufficient cache in SQL. I recommend the materials of Gilev ; they helped me more than once.

In the spirit of the times, first consider the intricate cloud option.

Scalable to the cloud

In the case of the UFO LLC scenario, two popular cloud types are suitable for scaling the service:

• SaaS (rental application). You can transfer two small bases to the cloud and free up resources for third base.

  
  

• IaaS (rent virtual machines). There are several options:

  
  

  • Deliver two bases to a cloud-based virtual machine by installing a second 1C-enterprise server and getting something similar to SaaS, but with full control over the system;

    
    

  • Transfer to the cloud application server 1C, at the same time losing the benefits of working through shared memory ;

    
    
  • Make SQL readonly replica. It can be useful if some users only generate complex reports that block tables and prevent others from working. But finalization of the 1C configuration and user training in this mode will be needed.
  
  

If we evaluate SaaS, then we need two databases with a total volume of 6 GB per six users. For evaluation, I used the calculator of the first SaaS provider found in the search. It turned out 5 700 ₽ per month.

Migrating some databases to the cloud will unload the server, but if users complain about the speed of a certain database, this may not solve the problem. In addition to the obvious disadvantages of the cloud solution, you will have to redo the database exchange scheme, since the provider can block the work of the main exchange methods (COM, SMB, FTP). Also, using them outside the intranet is not secure.

Now let's estimate the cost of a cloud-based virtual machine with a calculator from one of the VPS providers issued by the search engine, which would fit all the above scenarios:

• 80 GB of space for the base and the system on fast drives;

  
  

• 4 processor cores;

  
  
• At least 8 GB of RAM;

Total $ 6 400 per month.

In one of my past companies, it was necessary to repost all documents in four years in the main working base. In order not to paralyze the rest of this work, it was decided to rent a server in the cloud. They deployed a copy of the database on it, set up a night exchange, and literally within a month, all the postings were made without affecting the production

In terms of a year, renting resources in the IaaS-cloud will cost the company $ 76,800, which is even less interesting in the long run. But this option is suitable for solving a temporary performance problem with peak loads.

We will now descend from the clouds to the ground and consider the traditional option of saving the "User Experience".

Upgrade or purchase immediately "in reserve"

Performance problems are often not associated with the processor, but with the disk system and memory. Therefore, we will double the memory of the UFO LLC server and move from RAID1 to RAID10.

Using RAID10 will improve read / write speed and add reliability. This is one of the most successful options when using four disks. In addition, when replacing any of them with the subsequent reassembly of the array, the performance will not be that bad (compared to the same RAID5)

As for the upgrade price in the future, it is difficult to build forecasts. But in our basic version, fresh iron is used, so for a rough estimate, it is permissible to use the actual price.

To exclude from the cost of the assembly service and the warranty on the server, we calculate the components at the average price of Yandex Market :

• RAM: 2 pcs . Kingston KVR21E15D8 / 8 - $ 612

  
  
• Disk system: 2 pcs . Intel SSDSC2BB240G601 - $ 27,200

Total 33 600 ₽ .

Now let's calculate the cost of the server "in a year", adding up the price of the basic configuration and upgrade:

136 694 + 33,600 = 170 $ 294

Even with the hypothetical price reduction of outdated components, an updated server is unlikely to cost less than $ 150,000 . It turns out that to lay the upgrade of the new equipment in the original estimate is quite expensive. At least for a business it looks like an unnecessary waste of money.

Using the restored server

Since we are considering economically viable options to buy more server for less money, then we estimate the version of the restored (refurbished) branded server. We already know the configuration and its changes in the future, so let's turn to the green button for the price on the Server Mall website .

After studying the price list and consulting with the company's sales department, I found one interesting option based on IBM. Immediately bring the original version of the Supermicro and the new IBM on the plate:

The restored server resembles the option "Supermicro after upgrade", with the same 4 SSD drives and a similar processor with a speed of 129 000 ₽ . The difference in price with the original version, you can even increase the amount of RAM up to 32 GB.

If you discard the stereotypes of “yes, this is the same / used” and compare the facts, then a budget server comes up with a considerable margin of performance, a three-year warranty and IBM proprietary management software. There are also two power supply units , which gives greater fault tolerance and the ability not to shut down the server even when moving to another rack.

There are also disadvantages:

• Memory obsolete type;

  
  

• The processor supports no more than 32 GB of RAM;

  
  
• Lower system bus.

Despite this, the server will cope with the maintenance of 1C.

What chooses UFO LLC

The choice of the fictional company "UFO" may not coincide with yours, so there is no sense in voicing it. I will simply compare the ways to improve performance in the table:

* The cost of acquiring the basis of the solution is a physical server.

** Paid monthly during the entire rental period.

If you have your own examples of real use of the 1C and SQL bundles in the hybrid infrastructure with the cloud - tell us in the comments, it is very interesting to read.