MySQL Forums
Forum List  »  Security

Each instance with diferrent ssl CA and cert and key, while use jdbc:mysql:loadbalance protocol, how to hot swap ca info for each query?
Posted by: NOT_FOUND NOT_FOUND
Date: October 11, 2017 08:42PM

I build a database with single master node and mulit slave nodes, and each node with different ssl CA and cert and key. I used datasource like c3p0 to create connection and jdbc url like: jdbc:mysql:loadbalance//slave1:port,slave2:port/mydatabase?usessl=true, due to different ca of slave1 and slave2, i have no idea how to hot swap ca while mysql loadbalance strategy change physical slave host for each query action.
I know that if all nodes use same ca can resolve this issue, but for security, we do not want use this way.
May any one tell me how to do? Thanks a lot!

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.