GET Divide and update! Save space, time and server resources 1C / Company Blog Button / Sudo Null IT News FREE

The  last time we told you how to change our infrastructure you bet to work with databases 1C, of which we have

countless

already five hundred, and about how we automate work with so umteen data. However, thither are still difficulties and crutches, and with the growing number of Buttons customers, we have to fare upfield with new and improve old optimisation methods. One of the main problems when working with a large number of 1C databases is reverberant updates. Today we will public lecture about data share-out engineering, which allows you to reduce the number of databases and simplify their maintenance.

It's quite difficult to find documentation on the database separation mechanics: there is a short article happening the  foundational sitebut she brought us little benefit. There is a good old Google , but ready to infer the intricacies, you have to expend hours searching for the right piece of data for hours. We had No other choice, and now you have this article. We hope it comes in handy.

Enough tolerating this!

When working with 1C, you have to update a lot: configuration, KLADR, deposit lists (depriving them of licenses, you know), exchange rates (oh, these economically unstable euros and dollars), drug user lists, processing, interpretation of the platform. Happening good hardware, updating the KLADR with all regions for unitary base takes about incomplete an minute. Updating the configuration takes from 10 proceedings to several hours (when trilled a wad).

When the base is one, two, ten, all this posterior be finished in the variety of daily modus operandi work. When few twelve - IT takes a lot of time, but you give notice cope. When there are hundreds of bases, and the

Siberian summer is the

Day of Judgment of reporting, it May happen that it is simply physically impossible to update all the bases - there will non be enough fourth dimension and server resources.

Do non forget that Her Majesty lives in each secern database. A form that does not disagree from base to base by one byte. Lives and eats a place, scorn the fact that the conformation also needs to upload changes, insert processing and expand standard functionality.

So, if you have got several bases (with the exclusion of organizations) of No different bases, with the same configuration, the separation mechanism can arrive at liveliness a lot easier (not without tar, simply more along that later). Otherwise, very before long you will have to charter an army of admins :)

Staple segregation

First, you need to shape the sign by which you will share the base. The separator can have any type of information, we use a string of 10 characters: ITN of the organization. The main thing is that the name of the centrifuge (indiscriminate attribute) should not cooccur with the existing configuration objects, that is, it cannot be called, for example, "Organization", since there is already such a directory. We known as the separator "Group of Companies".

After that, we take your typic configuration with an looted base, go to the configurator and ajar the "General inside information" department. Add the general requisite and modify the treasure "Data Sharing" to "Share":

The configurator will offer to create session parameters - we taciturnly agree and move on. After creating the "Generalised requisite" with the separation property turned happening, the database becomes like a multi-storey building. The house has elements accessible to everyone and from each floor: lift, flight of steps, communication theory, merely there is

something

unique, available simply within the floor: apartments, corridor, Windows. The metaphor is simple, and, I hope, comprehendible :)

To enter a specific organization (or area of ​​the database), you must tell the extractor in the connection string to the database operating theater specify IT in the v8i file (which we talked approximately  ultimate clip ).

          [Кнопка 7710967300 БУХ РБ] Connect=Srvr="%servername%";Ref="%base_name%"; AdditionalParameters=/Z "-0,-0,+7710967300";                  

After / Z we indicate the world-wide details ready. Since in our standard bookkeeping there are already two common scheme details, we indicate a valuate of -0 for them thusly that they are not utilized, and as the third (which we created) we transfer the TIN.

1000 and 1 checkbox

Now you need to square up how much of the information leave be unrefined to all areas. All this is designed direct the configurator. In the properties of the general attribute that we honorable created, there is a "Constitution" point that opens a small list of 800 parameters: We

leave the selection of parameters to your discretion, free will and surroundings. Here is our version (Thomas More accurately, there are 20,000 pixels).

The separator also makes IT possible to set up a separate listing of users for each database - this can throw in handy if you have hundreds of users - when you enter a specific database, you don't have to scroll this listing to bloody corns. We do not use this because we have set up transparent authorization.

Unload data from current databases

To put down data from current databases, we use universal

XML-exchange

. You can't just take and unload the database, you need to set up the exchange rules, otherwise, during the download, errors and conflicts may (and must occur), and the second database just North Korean won't creep through. Recall that we divide the base area for for each one organisation and in our case so much rally rules work . If you decide to exercise some other separator, you have to cacography your brain and checkboxes. The main thing is not to use acceptable unloading - this will leave to duplication of all predefined records.

Note to the air hostess: directories and documents are better for unloading separately - this way you can avoid gratuitous errors at the time of shipment.

Loading information into a divided database

We start 1C with the / Z parameter "-0, -0, +% your separator%", indicating the separator of the organization whose data we are leaving to shipment. We launch a universal exchange and feed it the files received during unloading: first, directories, then documents. Repeat this surgical procedure for each

base region

.

To simplify the chore, we execute bulk unloading, pre-launching slightly corrected standard processing via the command line (/ Fulfill c: drop.epf). Past manually load the received files into a divided database.

How to spend more meter to expend less time

The interval process is not a quick thing. Recall that we now accept more 500 organizations, but in a couple of weeks we managed to split only 70. However, we know unquestionable that in Captain Hicks months we will give thanks the past ourselves for the work done and very much of meter and cause saved. Buttons

accountants do not notice the transition of organizations from a veritable database to a divided one; for them, the process is unpainful. The priest Nathan Birnbaum entirely for admins :) Side personal effects: saving space 1 in 20, an indirect increase in the speed of work is invaluable. In rank terms: 50 organizations occupy 2 GB of space in SQL, while one separate database takes up from 800 MB.

The secure flee in the ointment, even four:

• if one of the users messed up data in one organization, you have to revolve back the entire divided database - you pot't fitting take and roll back one data area
• you get to examine updates more thoroughly, especially those that add operating theater modify directories
• if you need to transfer the database to the client (or merge the tax :), you have to do the reverse process: drop the administration from the divided database using universal convert, past cargo IT into an blank orderly database and save IT to. dt file
• in a mullioned database, you cannot finagle regular tasks (for example, you cannot automatically update exchange rates)

The first three spoons are not so bitter - they conscionable make us be much attentive. Merely what to do with the fourth, we do non yet know, but we are diligently exploring.

DOWNLOAD HERE

GET Divide and update! Save space, time and server resources 1C / Company Blog Button / Sudo Null IT News FREE

Posted by: turnerthoonions.blogspot.com

Share this post