[loiraolhosazul]

I have a server where I use external 'MySQL', my server suffers a lot of 'ddos' attacks and when there is an attack the server cannot connect with 'MySQL' and some people lose data.

I put it to save in the 'disconnected' and then reset the variables.

Does it have a solution?

[Napoleon_be]

Use a VPN?

[CrazY.]

Set a task with the flag "b". The time shouldn't be too short, otherwise it will consume too much from the machine. I believe something between 30.0 and 240.0 should be okay, that will depend on the frequency of attacks. In the task, loop through all connected players and save their data just like you do in client_disconnected.

[loiraolhosazul]

Originally Posted by CrazY. Set a task with the flag "b". The time shouldn't be too short, otherwise it will consume too much from the machine. I believe something between 30.0 and 240.0 should be okay, that will depend on the frequency of attacks. In the task, loop through all connected players and save their data just like you do in client_disconnected.

[EN]
what I think happens is the following, the guy enters the game, loads the data normally, then he is in the game the attack happens, he leaves the server and does not save, he tries to enter again but he will not log into the account and their data is 0, most of all mysql comes back and when it exits it will save the data as 0.

[BR]
o'que eu acho que acontece é o seguinte, o cara entra no jogo, carrega os dados normalmente, ai ele está dentro do jogo acontece o ataque, ele sai do server e não salva, ele tenta entrar denovo mais não vai logar na conta e os dados deles estão 0, mais do nada o mysql volta e quando ele sai vai salvar os dados como 0.

[Napoleon_be]

You could just save everything more often, each round for instance? That's not how you should prevent getting ddos'd tho

[loiraolhosazul]

Originally Posted by Napoleon_be You could just save everything more often, each round for instance? That's not how you should prevent getting ddos'd tho

I don't know if it would be the best thing to do, I was thinking about using SQLITE and doing some type of SYNC for MYSQL

[Napoleon_be]

Originally Posted by loiraolhosazul I don't know if it would be the best thing to do, I was thinking about using SQLITE and doing some type of SYNC for MYSQL

You could just simply hire an anti-ddos company that does this for you and you wouldn't have to worry anymore about a single ddos attack. Shouldn't cost you too much.

U might wanna read this: https://stackoverflow.com/questions/...ugh-url-string

and this: https://serverfault.com/questions/21...how-to-prevent

Just do some research man, it's not hard. This is what i've found within 2 minutes of search.

[loiraolhosazul]

Originally Posted by Napoleon_be You could just simply hire an anti-ddos company that does this for you and you wouldn't have to worry anymore about a single ddos attack. Shouldn't cost you too much. U might wanna read this: https://stackoverflow.com/questions/...ugh-url-string and this: https://serverfault.com/questions/21...how-to-prevent Just do some research man, it's not hard. This is what i've found within 2 minutes of search.

You must be a beginner, the type of attack that occurs is a specific protocol, there is no way to block it.

[Napoleon_be]

Originally Posted by loiraolhosazul You must be a beginner, the type of attack that occurs is a specific protocol, there is no way to block it.

Beginner or not, for every problem there's a solution.

[loiraolhosazul]

Originally Posted by Napoleon_be Beginner or not, for every problem there's a solution.

You can hire any company, not even OVH can handle it, the problem is not in the mitigation of DDOS, the problem is in HALF-LIFE.