julien-duponchelle / julien-duponchelle/python-mysql-replication

[QA]: How to set SSL/TLS certificates when connecting to MySQL server as a replica?

Open
#622 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
2.4k
Forks
690
PR merge metrics
No merged PRs in 30d

Description

This is what we do when connecting to MySQL server as a client:

```python
# https://github.com/PyMySQL/PyMySQL/issues/430#issuecomment-464837266
conn = pymysql.connect(
host='127.0.0.1',
port=3306,
user='repl',
password='123456',
ssl={
'ca': 'ssl/ca-cert.pem',
'cert': 'ssl/client-cert.pem',
'key': 'ssl/client-key.pem',
# Effectively equals to --ssl-mode=VERIFY_CA
'check_hostname': False,
}
)
```

Just wonder how to set SSL/TLS certificates when connecting to MySQL server as a replica?

Contributor guide

Open the contributing guide

Research direction

Start by reviewing the replica connection path and the PyMySQL SSL options shown in the issue. Determine whether CA, client certificate, and key settings can be supplied when connecting as a replica; done means the supported configuration is documented or the limitation is clearly identified.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, python
Domain
databases, security
Issue type
Documentation
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.