[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, |
| 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. |