How to test database integrity?

Question

MySQL

Please tell me where you can read information about testing data integrity and system fault tolerance for a client-server application written with Java and using mySQL server.
It is necessary to make such tests in which it would be possible to simulate a server crash during operations interacting with the database and which would guarantee the correct behavior of the server in such situations (the absence of invalid objects in the database that were partially written to the database), that is, it is necessary to test the correctness all transactions.
I don’t know how it is possible to make such a server crash at a calculated point in time (execution of some method).

Answer 1

If the DBMS partially committed the record to the database, then such a
Java DBMS has nothing to do with it. You need to get into the code of your DBMS and see how everything is implemented there
PS it’s better to switch to postgres now so as not to kill yourself with facepalms

Answer 2

the absence in the database of non-valid objects that were partially written to the database

this is possible only when you make one entry in several transactions. Otherwise, the transaction completion flag will not be set (it is set after all the fields are already in place) and there will be no record in the database.
dev.mysql.com/doc/refman/5.7/en/commit.html