Programmer Group

Compile and install Nginx and Mysql http://blog.csdn.net/qq_36294875/article/details/79352522 [MySQL5.7.11 Compilation and installation] http://blog.csdn.net/qq_36294875/article/details/79344943 [Nginx And simple configuration] Compile installed environment The host is 172.25.23.6 hostname:server6.com K ...

1. Set the relevant database connection statements in the jdbc.properties file jdbc_url=jdbc:mysql://ip address: port / database name? Characterencoding = utf8 & zerodatetimebehavior = round jdbc_username=User name jdbc_password=User password 2. Read the modified properties file in applicationContext.xml <context:pr ...

1. Convert URL: from string to hyperlink If you're developing a forum, a blog, or a regular form submission, you often need users to visit a website. With this function, the URL string can be automatically converted to a hyperlink. function makeClickableLinks($text) { $text = eregi_replace('(((f|ht){1}tp://)[-a-zA-Z0-9@:%_+.~#?&//=]+)' ...

Reprint https://blog.csdn.net/yejiyueshang/article/details/78745664 Linux version: CentOS 6.5 64 bit 1. Download MySQL wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-1.el6.x86_64.rpm-bundle.tar 1 2. decompression mkdir mysql cd mysql [root@localhost mysql]# tar -xvf mysql-5.7.20-1.el6.x86_64.rpm-bundle. ...

Group concat is an aggregation function in mysql, but PostgreSql does not have this function, but it can be implemented with string AGG function Source: https://blog.csdn.net/u011944141/article/details/78902678 array_agg(expression) To change an expression into an array is generally used in conjunction with the array ...

CentOS 6.5 192.168.1.84 host CentOS 6.5 192.168.1.83 slave 1, Primary server configuration: Create synchronization user and specify server address [root@node04 ~]# mysql -u root -p111111 mysql>use mysql; mysql>grant replication slave on *.* to 'tongbu'@'192.168.1.84' identified by '123456'; mysql>flush privileges # ...

Not finished yet... To be edited To ensure that there is no other parameter configuration impact, a CentOS7 virtual machine with minimized installation is reinstalled 1. Install mysql5.6 database https://my.oschina.net/sgmder/blog/1631045 2. Configure mysql, enable binlog, and change binlog mode to Row Level mode vi /etc/my.cnf  Modify the ...

Table structure modification background In general, you should try to design well at the beginning, because once the database design is completed, it is better not to make major changes. However, no one can guarantee that my watch will always be sufficient and may need to be changed at any time. Therefore, we still need t ...

Introduction: PT online schema change is a member of percona toolkit. It can modify the table structure online without locking the table by improving the native ddl. Working process of Pt OSC 1. Create a new empty table structure (the structure before the alter) just like the table to perform the alter operation 1. Exec ...

1. Requirements: from 10:00 p.m. to 5:00 a.m. every day, execute the stored procedure regularly every 10 minutes. 2. Implementation mode: there are two ways to achieve it: One is more conventional. Using mysql event timing task, first introduce the related commands of event timing task in mysql, To see if event is enabled: ...