F
F
fatummaker2017-10-19 10:32:50
MySQL
fatummaker, 2017-10-19 10:32:50

What is the most efficient way to encrypt a mysql connection?

Due to 50% performance loss when using ssl encryption between the mysql client and the base, on the advice of percona, I switched to openvpn between the client and the base, unfortunately, this gave about the same performance results as using ssl about 6500 per sec per read. All the cars on the tests did not exactly rest on resources. Can you please tell me the best way to protect mysql connection without significant performance loss?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
F
fatummaker, 2017-11-01
@fatummaker

as tests have shown, the use of ssl between the client and the base or openvpn is almost the same in terms of results, the most productive (almost 1.5 times more) was the use of ipsec

R
Roman Mirilaczvili, 2017-10-19
@2ord

The most productive cipher will be the one that is usually the weakest and relatively easy to break.
You can choose with a smaller key length, but this will be at the expense of security.
Computational performance may also depend on hardware support for certain processor instructions.
It is best to experiment before the final choice:
openssl speed

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question