[MXS-651] SSL for backend connections Created: 2016-03-30  Updated: 2016-08-11  Resolved: 2016-06-14

Status: Closed
Project: MariaDB MaxScale
Component/s: mariadbbackend
Affects Version/s: 2.0.0
Fix Version/s: 2.0.0

Type: New Feature Priority: Major
Reporter: martin brampton (Inactive) Assignee: martin brampton (Inactive)
Resolution: Done Votes: 1
Labels: None
Environment:

All


Sprint: 2016-8, 2016-9, 2016-10, 2016-11

 Description   

Support for configuring SSL for the connections to backend database servers using the MySQL protocol.



 Comments   
Comment by martin brampton (Inactive) [ 2016-04-19 ]

Preparatory work is done to handle the configuration details. The next step is to discuss the way the MySQL backend protocol interfaces to database servers so as to allow for requesting a SSL connection.

Comment by Dipti Joshi (Inactive) [ 2016-05-17 ]

johan.wikman martin brampton Is this task going to be complete in current sprint ?

Thanks,
Dipti

Comment by Johan Wikman [ 2016-05-18 ]

That is the goal.

Comment by martin brampton (Inactive) [ 2016-05-18 ]

On a straghtforward setup, backend SSL is working correctly. Tests on different configurations are to be done, and some code tidying. Certainly, the hope is that it will be complete for the next major release, as planned.

Comment by martin brampton (Inactive) [ 2016-05-26 ]

This could be facing delays. The SSL to backend database processing works fine for small amounts of data (up to 10K or maybe more) but frequently hangs on larger requests. Resolving this is likely to require deeper investigation into the workings of OpenSSL and epoll processing of non-blocking socket I/O. That could be time consuming.

Comment by martin brampton (Inactive) [ 2016-05-26 ]

Unfortunately, a check on the released client side SSL shows that it too fails on large data sends (test used a table dump about 0.5 MB in size, 10,000 rows). Many applications will run without ever sending very long queries, but if they do, the connection will hang. This demonstrates that the problem is to do with SSL implementation generally, rather than the logic of the MySQL protocols, mysql_client.c and mysql_backend.c. The previous comment is therefore confirmed, at least until we know more.

Comment by martin brampton (Inactive) [ 2016-05-29 ]

I am hopeful that the problems are now resolved.

Comment by martin brampton (Inactive) [ 2016-05-31 ]

The code has passed tests, and the specific faults referred to above are resolved. The code is merged into the develop branch. Work is needed to amend the documentation to describe back end SSL.

Comment by martin brampton (Inactive) [ 2016-06-14 ]

Documentation has been completed.

Generated at Thu Feb 08 04:00:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.