Send changes from one database to another

Hello,

I propose the architecture:

A) Direct connection to the remote database (minimum code and budget)
The admin panel on VDS-1 reads/writes the balance and reads the order count directly in the database on VDS-2.
Technically: a separate database user with minimal rights, IP-whitelist through the firewall, TLS, prepared queries.

B) Lightweight API on VDS-2 (slightly more expensive, but more flexible and secure)
… On VDS-2, we will set up a mini-service (PHP/NGINX), endpoints:
GET /user/{tg_id} → balance, orders; PATCH /user/{tg_id}/balance; HMAC signature + IP whitelist.
The admin panel on VDS-1 accesses this API, the database remains closed to the outside.

What I will do:
1. The balance and the number of orders in the user card will always come from VDS-2 (single source).
2. In the admin panel on VDS-1, editing the balance writes to the database on VDS-2 (with change logs).
3. Protection: IP whitelist, accounts with minimal rights, prepared queries, optionally TLS.
4. Documentation on integration points and rollback.

Option A (direct connection to the database on VDS-2)
19 hours → $285, deadline 2–3 working days
1. Code audit, access, data schema — 2 hours / $30
2. Network connection: firewall, database role, TLS — 3 hours / $45
3. Admin panel modification: reading balance/orders from VDS-2 — 4 hours / $60
4. Admin panel modification: writing balance to VDS-2 + logs — 5 hours / $75
5. e2e tests, bot regression, fixes — 3 hours / $45
6. Documentation, rollback checklist — 2 hours / $30

Option B (mini-API on VDS-2):
25 hours → $375, deadline 3–4 working days
(items from option A are replaced with API development: GET/PATCH routes, HMAC signature, validation, PHP client in the admin panel)

We will start with the most budget-friendly A. If security/policies require an API — we switch to B without redesigning the data model.

1. What database is on VDS-2 (MySQL/MariaDB/Postgres) and its version?
2. Where are the balance and orders_count currently stored (table/field names)? Do the schemas differ on VDS-1 and VDS-2?
3. Is it necessary to keep a history of balance changes and comments on edits in the admin panel?
4. Are there any requirements for channel encryption (TLS to the database) or is VPN/firewall + localhost proxy sufficient?
5. Do we limit access by IP from VDS-1 or will multiple addresses be needed (staging)?
6. Can SSH/PhpMyAdmin/config access be provided for a short audit (read-only)?
7. Are notifications in logs/Telegram needed when the balance changes?

I work through a safe.

Show original

Translate

Hello! I see that you need to ensure synchronization and editing of user order balances and quantities between two servers with Telegram bots on PHP. For this, a reliable data exchange between the databases on the servers can be implemented through an API or direct connection to the remote database, so the admin panel always retrieves up-to-date information from the main server. I have experience integrating Telegram bots with external databases and building connections between distributed systems. I am ready to discuss the details, propose a solution architecture, and quickly get to work for correct data exchange between your VDS and bots.

Show original

Translate

Hello, perhaps a good option would be to make a request from one side to obtain this invoice, and on the other end there will be an API that will accept this request, so in the future it will be possible to connect these two bots.

Show original

Translate

Hello Andriy, I can help you solve your problem, let's discuss the details in private messages.

Show original

Translate

Good day,

I can implement the connection of the admin panel to the server with the database via API to retrieve data from the database, not from the bot.

I would be happy to collaborate!

Show original

Translate

Good afternoon.
I can help you with your problem.
Feel free to reach out.

Show original

Translate

Good day.
The task is clear, I can implement it quickly.
I have experience with php, mysql, vds.
We can discuss the details and implement data duplication, or change the direction in another database.

Show original

Translate

Good day. Contact me, I will do it.
++++++++++++++++++++++++++++++

Show original

Translate

Good afternoon.
I understand that you need to add a new API that will allow pulling the necessary information between servers.
I will do it in the best way, as an addition that will not interfere with the code update of the bots themselves.

Show original

Translate