Organizing a Server for unity?

Question

Android

Good afternoon!
I want to make an online game on the unity for android:
Uniiii graphical shell, Logic on the server.
At the moment I am doing logic in PHP, communicating with the unit via POST in JSON format, MYSQL database.
I spent two days on the forums and after reading, I realized that the implementation is not the best.
Please tell me what can be used.
And support a connection via a websocket?
Ira 2d, without physics and rooms, like a strategy. The server has to handle getting resources, calculating battles, building buildings in prearranged places, player inventory, and the like. In the future, I plan to PVP 1x1 in the form (5 heroes against 5 enemy heroes).

Answer 1

I can offer you the following, since you are still making a game in Unity, which means you are using C #, I suggest you, the server part - the database, also write in C # using Azure technology.
https://azure.microsoft.com/ru-ru/
In our work on the project, we use just such a solution.
There is a lot of documentation on it, so you will figure it out quickly, I think.
Plus a small video, for example, a very rough example, but still.
https://www.youtube.com/watch?v=R8adpelztJA

Answer 2

I spent two days on the forums and after reading, I realized that the implementation is not the best.

They write anything on the forums, use what you know, otherwise the game will never come out)
In general, if it’s super easy to do, then nodejs with socket io, as a mongo database. The node is better than php in terms of the socket, the js syntax is closer to java, you can write typescript, it’s almost like java, it will be easier to switch from language to language, the database schema will allow you to save a lot of time due to the fact that you don’t have to climb back and forth and add fields or write migrations.