Programming VIP

Get ready I use docker deployment on CentOS, so I need to prepare docker related operations in advance docker CentOS installation To configure mapping A host has multiple virtual machines, so it needs to use different named configuration folders, such as / etc/mysql/my.cnf.d/master01, to distingu ...

PHP5 Installation download wget http://cn2.php.net/distributions/php-5.6.32.tar.bz2 decompression Tip: Can't exec: No file or directory The reason is that the bzip2 package is missing yum install -y bzip2 decompression tar -jxvf php-5.6.32.tar.bz2 To configure 1. Need to be installed first xml2 yum install -y libxml2-devel 2 Install ...

1, Python 2. X migration to 3.x problem 1. torndb does not support 3.x. error reporting solution in 3.x environment The torndb module does not support Python 3. X, so you need to modify part of the torndb source code to use it normally Source code modification: 1. Modify the import module import ...

1, Task scheduling overview 1. Why workflow scheduling system is needed 1) A complete data analysis system is usually composed of a large number of task units:shell script program, java program, mapreduce program, hive script, etc. 2) There are time sequence and pre and post dependence relationships ...

Get mysql image ➜ ~ docker pull mysql ➜ ~ docker images REPOSITORY TAG IMAGE ID CREATED SIZE mysql latest d435eee2caa5 3 weeks ago 456MB mysql ...

1.JDBC introduction jdbc(java database connectivity) provides a unified programming interface for java developers to use the database. It consists of a set of java classes and interfaces. The classes and interfaces needed for JDBC are: DriverManager,Connection,Statement,ResultSet            2. Download MySQL connector Java The mysql version of ...

3.3 build ES environment3.3.1 ES installationThe development environment uses the ES stand-alone environment to start the ES server.  Note: for the old ES environment, you can delete elasticsearch-6.2.1\data\nodes directory to completely clean up the ES environment.  Install elasticsearch h ...

The major version number of the test is 5.7, and the minor version is 5.7.24. binlog is not enabled by default Modify my.ini and add two new configurations: # Open bin log server-id=1 log-bin=mysql-bin Table and data tested: create table T(ID int primary key, c int); update T set c=c+1 where ID=2; Restart MySQL and find two more MySQL bin. ...

Recently, when a group sorting query is encountered in mysql, it is suddenly found that there is no group sorting such as row_number() over(partition by colname) in MySQL.And since there is no ranking function similar to row u number(), rank(), deny u rank() in SQL Server in MySQL, all of the following implementation methods are found. Here is ...

Custom functions, like scalar subqueries, when the result set (row number N) returned by the main query is huge, the query in the custom function will be accessed N times The only applicable scenario of user-defined function is paging query. Other scenarios basically have potential risks and need to be rewritten. SELECT rrs.o ...