Overview replication is usually used to create a copy of the master node to ensure high availability by adding redundant nodes. Of course, replication can also be used for other purposes, such as reading and analyzing data on the slave node. In
See if SSL is supported
First, execute the following command on MySQL to query whether MySQL supports SSL:
Mysql> show VARIABLES like ' Have_ssl ';+---------------+-------+| variable_name | Value |+---------------+-------+| Have_ssl |
See if SSL is supported
First, execute the following command on MySQL to query whether MySQL supports SSL:
Mysql> show VARIABLES like ' Have_ssl ';
+---------------+-------+
| variable_name | Value |
+---------------+-------+
| Have_ssl |
Detailed tutorial on MySQL master-slave Replication Based on the SSL protocol,
When mysql is replicated across the Internet, others can steal the mysql replication information, which is in plain text and therefore insecure. Here, the copied
Stunnel is a program that can use SSL to encrypt any TCP connection. It can run on a variety of UNIX and Windows operating systems. In this way, it effectively solves the problem that SSL cannot encrypt the data transmitted by existing applications.
This article mainly introduces a variety of different SSL configurations for MySQL, a very good article, and very practical. if you need it, you can refer to the post in this blog, I will describe different SSL configuration methods for using the
Multiple MySQL SSL configurations and mysqlssl configurations
In this blog post, I will describe different SSL configuration methods for using the MySQL database.
What does SSL give you?
You can use the replication feature of MySQL over the Internet
SSL (SecureSocketsLayer Secure Sockets Layer) is a security protocol that provides security and data integrity for network communication. It uses Encryption technology, ensure that data is not intercepted or eavesdropped during network transmission.
I. node information:Master1: 192.168.80.143/24 + CaMaster2: 192.168.80.144/24
The two nodes are the same as the master node and the slave of the other node.
Ii. Basic Configuration:
(1) MySQL is installed on both servers.
# pvcreate /dev/sda5
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.