What is the best way to plan a network for shops with unstable connection?

Question

VPN

Good evening, gentlemen experts.
I ask for advice.

Available at the moment:
A network of stores in the amount of 5 pieces + the central office.
At the central office, there is a Windows server with 1C and RDP, where the accountant and her assistant come in for an RDP session, open a file base there, and do their own thing.

Each branch has Internet from different providers, from optics to 3G modems. Wasps on computers - Windows, this is a must. You definitely need iTunes, which does not plow under Linux. IPs in stores are gray, in the central office - white.

Databases are synchronized via e-mail (in 1C there is such a synchronization option - databases send mail to each other and synchronize shift data).

What would you like:
Have one LAN via L2TP, raised on the server, and routers, mainly Zyxel, would connect to the server via L2TP and unite into a LAN. This is necessary to manage my specific software for managing LED screens with video ads. Now I do it with Ammy Admin, distracting sellers with requests to open Ammy Admin.

Question: How to proceed? On the one hand, when exchanging 1C via mail, each point of sale does not depend on the Internet at the Central Office and on its own Internet, since the database is file everywhere. On the other hand, it would be possible to organize a 1C server on Debian with PostgreSQL databases, and access even through a browser - but then the ability to write out the goods when the connection is broken is lost. And at the same time, I want to see all the points in my local area, so that I can do all the manipulations with the software from the office and not use AmmyAdmin's crutches.

Or am I bothering in vain, and the current "device" in quotes, our network, is normal?

UPD:
As one of the solutions I see, for example, leave the 1C synchronization the same as it is, but still raise L2TP for management, it’s just that at the points the provider’s gateway will remain the main gateway and not the Central Office server. Then nothing will suffer, and the pluses for management will definitely appear.

I just do not exclude the fact that 1C has some other tricky ways to work with the server. I am not a 1C administrator, and I do not know all the subtleties.

Answer 1

Wasps on computers - Windows, this is a must. You need iTunes

Have fun. ITunes is actually a program from the world of the appletate, its native environment is Mac :) It
's better not to transfer bases to a server if the connection is unstable - no connection - no base - no sales :( And the LAN, which is built by a connection to the center, is a normal phenomenon.

Answer 2

The problem here is not in technology but in the head. What is the benefit of such an improvement for the business? That's right, zero benefit. What are the disadvantages - labor costs for implementation, loss of customers and blocking points of sale when the connection is broken. Stopping the business completely when the central server crashes.
It can be concluded that for this it is necessary to tear off your hands)

Answer 3

One obvious solution is to provide all outlets with stable communication channels with good bandwidth. If this is technically impossible or the business is not ready to spend money on it, then you can write an application, the client parts of which will cling to the server part in the office once a minute from store networks, take screen management tasks from there and execute them.

Answer 4

Everything will depend on what specific level of centralization you want and how much you are willing to spend on it.
In one 1C database, they work if you need online access to all data, or there is no money / opportunity / desire to raise the base at each point, but it is more profitable to keep everyone in one. If they arrange an exchange once / twice per shift, then you can "do not touch it."
With LED, well, raise your L2TP, configure routing so that what you need goes into the tunnel, what you don’t need outside.
And so you can start bothering with the reservation of communication channels, etc. but this is beneficial only when you need to have online access to all data, in other cases, a locally distributed database is enough.

Answer 5

you need to sit down and calculate how much it costs to find a normal admin who understands what and how to do, at least for the project and how much the network loses by asking questions on the Internet. If it turns out that it is more profitable to do nothing, this question does not make sense. and if it is more profitable to hire a specialist - you need to hire.
be careful when reading the answers - someone wants to show that he is a cool microt specialist and he will shove microts into every answer, someone is not at all in the subject but does not know about it and will confidently give recommendations, someone will just write for fun . and the author of the question will have to rake and bear responsibility;)

Answer 6

1c while working - it's better not to touch it. Until the business has a new task that requires changes in 1s. Now there seems to be many options for synchronizing with remote offices. But one should be puzzled by these tasks.
The network on L2TP must probably be raised, why not. So it is more convenient for users to provide technical support. Maintain fleet of vehicles and other equipment. You cut subnets for each branch and forward. The need for ammy disappears, there are many other options. The only thing is to make sure that when the vpn channel drops, the exchange does not stop. So as not to be extreme later if synchronization does not work on a certain day.

Answer 7

Chain of stores in the amount of 5 pieces

Options:
1. web client - works even on 3g. here, too, there are options for how to enable this client
2. local copies with a periodic exchange, as now ... From the category It works untouched , it can change a more "stable" exchange.
And the most important question: Why change, for what?