MySQL 5.7 SSL configuration and enable

1, Start SSL on installation [root@linux-node local]# /usr/local/mysql5.7/bin/mysqld --initialize --basedir=/usr/local/mysql5.7 --datadir=/usr/local/mysql5.7/data/ --user=mysql [root@linux-node local]# /usr/local/mysql5.7/bin/mysql_ssl_rsa_setup After running this command, the following pem files will be generated in the data directory by ...

Posted by matty on Mon, 04 May 2020 06:00:33 +0200

java socket realizes the server, and the client has simple network communication. Chat

There are some serious bug s in the code written before to realize simple network communication. Write in detail later. According to the last code, mainly increased the user registration, login page, and realized the real-time display of the current login status of the number of people. And solve some bug s not found last time. (refer to previo ...

Posted by Byron on Mon, 04 May 2020 03:09:22 +0200

Using rundeck scheduler to set up sending mail

1. Configure QQ mailbox to send mail 1.1 enable the SMTP service and obtain the authorization code 1.2 select account Start related services and generate authorization code 2. Enable sendmail service and postfile service [root@zydatahadoop001 rundeck]# service sendmail stop [root@zydatahadoop001 rundeck]# chkconfig sendmail off [r ...

Posted by shivangp on Sun, 03 May 2020 23:51:10 +0200

Force sql to use an index

SQL HINT (SQL HINT) is an important means to optimize the database, which is to add some hints in sql to optimize the effect. Let's learn about use index, ignore index, and force index; 1. Add use index after the query statement. You can suggest indexes to MySQL for reference, so that MySQL does not consider other indexes. explain select co ...

Posted by daniel244rock on Sat, 02 May 2020 20:40:36 +0200

MySql Foundation - Building MySql Database: Installing MySql-server, MySql-client

1 Build MySQL Server1.1 Question This case requires familiarity with the use of MySQL's official installation package to quickly build a database server: Install MySQL-server, MySQl-client packagesModify the password of the database user rootConfirm MySQL service program is running and root is controllable 1.2 Program This course will use the ...

Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200

Index analysis of union primary key (Union index) in SQL Server (MySql)

Recently, someone asked this question in the interview. Before that, they had not studied the specific use logic of the joint index, consulted several articles, and came to some conclusions after testing Test environment: SQL Server 2008 R2 The test results are similar to the query mechanism of MySql joint index. We can think that MySql is the ...

Posted by kathas on Fri, 01 May 2020 08:02:06 +0200

Issue 03: column non empty and self increasing

There are many attributes of fields in MySQL, and the impact on performance can be large or small, so it's necessary to explore the attributes. 1, NULL / NOT NULL For external programs, NULL is an unknown, imprecise, and indescribable value. Therefore, it is clearly stipulated in the development specifications of many companies that it must be ...

Posted by dayo on Wed, 29 Apr 2020 10:59:26 +0200

Case analysis: python operation database project

According to an example of a project, this paper records and shares the process and relevant settings of python's displaying the content of database to the program interface, and explores the usage of python's operating database. Main contents to be shared: 1. Displays the database contents. 2. Modify database content. 3. The table control spec ...

Posted by andrewgk on Wed, 29 Apr 2020 08:50:53 +0200

Installation and configuration of big data platform CDH5.16.2

Tags (space separated): building big data platform 1: Environment initialization 2: Installation of CDH5.16.2 1.1: introduction to system environment System: RHEL7.7X64 cat /etc/hosts --- 192.168.100.21 rhel01.flyfish 192.168.100.22 rhel02.flyfish 192.168.100.23 rhel03.flyfish 192.168.100.24 rhel04.flyfish ----- Only three ...

Posted by Berone on Sun, 26 Apr 2020 17:47:28 +0200

Talk about my SqlConnection of canal

order This paper focuses on my SQL connection of canal ErosaConnection canal-1.1.4/parse/src/main/java/com/alibaba/otter/canal/parse/inbound/ErosaConnection.java public interface ErosaConnection { public void connect() throws IOException; public void reconnect() throws IOException; public void disconnect() throws IOException; ...

Posted by DuFF on Sat, 25 Apr 2020 16:47:49 +0200