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 |
When MySQL is replicating across the internet, others can steal information about MySQL's replication, which is plaintext, so there is no security, where the replicated information is encrypted via SSL. When the client does not have a fixed IP to
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.
MySQL: SSL remote login bitsCN.com
MySQL: SSL remote loginEnvironment: linux mint 15Install openssl:1Sudo apt-get install opensslCheck whether mysql ssl is enabled (in the mysql command line ):1Show variables like '% ssl % ';If not, the values of
Master-Slave replication principle
As master server master, each of its changes will be recorded into the binary log binarylog. (The server I/O thread is responsible for reading the master binary log, then writing itself to the relay log
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.