Grails Version 3.0 and above configure multiple data sources

grails has been upgraded to version 3.0.9 due to work needs, and needs to configure multiple data sources. grails 2.1's multi-source configuration is relatively simple, but more than 3.0 version of the database configuration changes to application.yml for configuration, how to configure multi-source, Baidu and bing search no answer (forgive me ...

Posted by kingbeastie on Sat, 25 May 2019 15:21:02 -0700

Vue+Express+Mysql Full Stack Initial Experience

Preface Original Address Once, did you think about the future of a front-end engineer?Did you think of the word "Front End Architect" at this point, so a qualified front end architecture will only have a Front End OK?Of course not. You must have the full stack of abilities to expand your personal image, to get a promotion and pay rais ...

Posted by dkruythoff on Sat, 25 May 2019 12:02:08 -0700

Mysql Introduction and Practice Summary

This paper first introduces the installation and basic use of mysql, advanced operation, import and export of MySQL and automatic backup, then introduces the security mode modification password and full text search function of mysql, and finally records the problem set encountered in personal use of mysql. Start installation: sudo apt-get in ...

Posted by nikko50 on Sat, 25 May 2019 12:01:13 -0700

mysql foreign key constraint

-- drop table p_table; -- drop table c_table; CREATE TABLE p_table ( -- Parent table id int(11) NOT NULL auto_increment, p_name varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB char set = utf8 ; CREATE TABLE `c_table` ( -- Child table `id` int(11) NOT NULL auto_increment, `c_name` varchar(20) DEFAULT NULL, `p_id` i ...

Posted by Agtronic on Fri, 24 May 2019 16:28:01 -0700

Visualizing iOS code quality with SonarQube

We usually use OCLint tools to generate static code analysis reports and Slather to generate unit test coverage reports, but these reports are relatively simple. Sonar Qube shows the problems in the code in a visual way. This article will show how to use Sonar Qube to show O. CLint scanned report. Installation software This article takes Ubuntu ...

Posted by dzelenika on Fri, 24 May 2019 12:41:55 -0700

Mysql -- Basic Configuration, Authorization and Delete Permissions

Start or stop Start Mysql Server sudo /usr/local/mysql/support-files/mysql.server start Start the Mysql client sudo /usr/local/mysql/support-files/mysql.server stop mac preference settings start or close Configuration file settings Copy cnf files cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf //Copy the default mysql conf ...

Posted by WinnieThePujols on Fri, 24 May 2019 11:31:12 -0700

Server Development Series 2

title: Server Development Series 2 date: 2017-9-13 11:27:46 After three weeks of crazy overtime, the pace of server development can finally be put on hold, and there is time to take a good look at the project from an "external" perspective. Write tcp server naked using swoole In the absence of the Swiss Army Knife (familiar framework) ...

Posted by FireDrake on Thu, 23 May 2019 16:57:22 -0700

Two Temporary Tables in MySQL

Change from: http://mysql.taobao.org/monthly/2016/06/07/ External Temporary Table Through CREATE TEMPORARY TABLE Create temporary tables, which are called external temporary tables. This temporary table is only visible to the current user and closes automatically at the end of the current session. This temporary table can be named with the ...

Posted by lucidpc on Thu, 23 May 2019 12:37:24 -0700

Upgrade mysql 5.5.19 to 5.6.33 (architecture: mysql dual master replication + keepalive)

First: experimental environment Operating System: CentOS release 6.5 (Final) mysql dual master replication + keepalive achieves high availability: master1:10.192.203.201 master2:10.192.203.202 vip 10.192.203.203 Virtual ip is currently on master 1. The program writes vip.   2. Experimental steps 2.1 Upgrade Mas ...

Posted by Sindarin on Thu, 23 May 2019 11:21:34 -0700

Execution Order of SQL Logical Query Statements

The first condition for efficient index use is to know what queries will be used in the index. This problem is related to the "Leftmost Prefix Principle" in B+Tree. Here is an example to illustrate the Leftmost Prefix Principle. Let's start with the concept of joint indexing. In the above, we all assume that the index refers to only ...

Posted by garygay on Wed, 22 May 2019 17:26:16 -0700