Holding You Back As I Breath You In

Mysql 数据库表数据的快速迁移

发表于 2019-09-18 | 分类于 Mysql |

表数据迁移 (前提:目标数据库和源数据库含有相同数据库名和表)


mysql> ALTER TABLE t_app_banner DISCARD TABLESPACE;  //目标数据库.ibd文件与原先的.frm文件解除绑定 

$ cd /var/lib/mysql  //mysql数据库文件存放位置 在/etc/mysql/mysql.conf.d中查看

$ ls
auto.cnf  test  debian-5.7.flag  ib_buffer_pool  ibdata1  ib_logfile0  ib_logfile1  ibtmp1  mysql  performance_schema  sys

$ls -lht
total 144K
-rw-r----- 1 mysql  mysql  9.1K Sep 18 08:00 t_app_banner.frm
-rw-r----- 1 mysql  mysql    67 Sep 18 03:00 db.opt
-rw-rw-r-- 1 mysql mysql 128K Sep 16 06:50 t_app_banner.ibd

$ 复制要恢复表的.ibd文件 至目标数据库的相同目录下进行覆盖

$cd /var/lib/mysql/test
$ ls -lht
total 144K
-rw-r----- 1 mysql  mysql  9.1K Sep 18 08:00 t_app_banner.frm
-rw-r----- 1 mysql  mysql    67 Sep 18 03:00 db.opt
-rw-rw-r-- 1 ubuntu ubuntu 128K Sep 16 06:50 t_app_banner.ibd  //如果该文件使用者为ubuntu需要进行权限更改

$ chown mysql:mysql /var/lib/mysql/test -R  //修改t_app_banner.ibd的授权用户

$mysql> ALTER TABLE t_app_banner IMPORT TABLESPACE; //恢复ibd和frm文件的关联

Linux 安装Jenkins、Linux启动多个Tomcat、安装JDK

发表于 2019-08-30 | 更新于 2019-10-30 | 分类于 Jenkins |

安装Java(略)


$ tar zxvf  jdk-8u231-linux-x64.tar.gz   //下载  jdk-8u231-linux-x64.tar.gz  解压到/usr/local/java

$ vim /etc/profile 

配置环境变量 
export JAVA_HOME=/usr/local/java
export JRE_HOME=${JAVA_HOME}/jre    
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib    
export PATH=${JAVA_HOME}/bin:$PATH

$ source /etc/profile

$ java -version
java version "1.8.0_45"
Java(TM) SE Runtime Environment (build 1.8.0_45-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)

$ echo $JAVA_HOME   ##输出Java安装目录
/usr/local/jdk

Linux启动多个Tomcat

$ vim /etx/profile

##########first tomcat###########
CATALINA_BASE=/home/tomcat-1
CATALINA_HOME=/home/tomcat-1
TOMCAT_HOME=/home/tomcat-1
export CATALINA_BASE CATALINA_HOME TOMCAT_HOME
##########first tomcat###########

##########second tomcat##########
CATALINA2_BASE=/home/tomcat-2
CATALINA2_HOME=/home/tomcat-2
TOMCAT2_HOME=/home/tomcat-2
export CATALINA2_BASE CATALINA2_HOME TOMCAT2_HOME
##########second tomcat##########


$  vim /home/tomcat-data/bin/catalina.sh  //找到OS specific support 在下面添加
# OS specific support.  $var _must_ be set to either true or false.
export CATALINA_BASE=$CATALINA2_BASE
export CATALINA_HOME=$CATALINA2_HOME


$  vim /home/tomcat-2/conf/server.xml   // 修改 conf/server.xml 修改关闭端口 监听端口 访问端口

Ubuntu 安装jenkins

$ wget -q -O - https://pkg.jenkins.io/debian/jenkins.io.key | sudo apt-key add -
$ sudo sh -c 'echo deb http://pkg.jenkins.io/debian-stable binary/ > /etc/apt/sources.list.d/jenkins.list'
$ sudo apt-get update
$ sudo apt-get install jenkins
$ service jenkins status  //jenkins服务状态
$ service jenkins stop    //启动jenkins
$ service jenkins start  //停止jenkins
$ service jenkins restart //重启jenkins
$  vim /etc/default/jenkins  //修改以下属性为root 
# user and group to be invoked as (default to jenkins)
JENKINS_USER=root
JENKINS_GROUP=root
$ find / -name "jenkins" //查找jenkins目录 进行root授权
$ chown -R root:root /usr/share/jenkins
$ chown -R root:root /usr/share/doc/jenkins
$ chown -R root:root /etc/init.d/jenkins
$ chown -R root:root /etc/default/jenkins
$ chown -R root:root /etc/logrotate.d/jenkins
$ chown -R root:root /var/lib/jenkins
$ chown -R root:root /var/cache/jenkins
$ chown -R root:root /var/log/jenkins
$ service jenkins stop //重启jenkins
如果你的`/etc/init.d/jenkins`文件无法启动Jenkins，编辑`/etc/default/jenkins`， 修改 ----HTTP_PORT=8080----`为----HTTP_PORT=8081----` 在这里，“8081”也可被换为其他可用端口。
ln -s /opt/jdk1.8.0_201/bin/java /usr/bin/java //创建java软连接

centos版本安装Jenkins

$ sudo wget -O /etc/yum.repos.d/jenkins.repo https://pkg.jenkins.io/redhat-stable/jenkins.repo
$ sudo rpm --import https://pkg.jenkins.io/redhat-stable/jenkins.io.key
$ yum install jenkins
Loaded plugins: fastestmirror
Setting up Install Process
Loading mirror speeds from cached hostfile
jenkins                                                                                                                             | 2.9 kB     00:00     
jenkins/primary_db                                                                                                                  |  29 kB     00:00     
Resolving Dependencies
--> Running transaction check
---> Package jenkins.noarch 0:2.176.3-1.1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================================
 Package                             Arch                               Version                                  Repository                           Size
===========================================================================================================================================================
Installing:
 jenkins                             noarch                             2.176.3-1.1                              jenkins                              74 M

Transaction Summary
===========================================================================================================================================================
Install       1 Package(s)

Total download size: 74 M
Installed size: 74 M
Is this ok [y/N]: y
Downloading Packages:
jenkins-2.176.3-1.1.noarch.rpm                                                                                                      |  74 MB     00:26     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : jenkins-2.176.3-1.1.noarch                                                                                                              1/1 
  Verifying  : jenkins-2.176.3-1.1.noarch                                                                                                              1/1 

Installed:
  jenkins.noarch 0:2.176.3-1.1                                                                                                                             

Complete!


$ service jenkins start //启动Jenkins
Starting Jenkins bash: /usr/bin/java: No such file or directory
                                                           [FAILED]
说明该目录下没有配置Java                                                               
$  vi /etc/sysconfig/jenkins      //修改一下默认端口(8080)和启动用户
JENKINS_USER="root"
JENKINS_PORT="8081"
$  echo $JAVA_HOME   ##输出Java安装目录
/usr/local/jdk
$  vim  /etc/init.d/jenkins 
candidates=
/etc/alternatives/java
/usr/lib/jvm/java-1.8.0/bin/java
/usr/lib/jvm/jre-1.8.0/bin/java
/usr/lib/jvm/java-1.7.0/bin/java
/usr/lib/jvm/jre-1.7.0/bin/java
/usr/lib/jvm/java-11.0/bin/java
/usr/lib/jvm/jre-11.0/bin/java
/usr/lib/jvm/java-11-openjdk-amd64
/usr/bin/java
/usr/local/jdk/bin/java   //增加Java安装目录

$ service jenkins start  //启动jenkins 成功
Starting Jenkins              
                                                    [  OK  ]
$ cat /var/lib/jenkins/secrets/initialAdminPassword
62ce0816e3c24d9aa3fac37a9a39fb4r

在浏览器输入ip:8080进入Jenkins登录页面。如图：

出现一下情况

解决方法： http://ip:8080/pluginManager/advanced  Update Site 下的 http://updates.jenkins.io/update-center.json 修改为 https://mirrors.tuna.tsinghua.edu.cn/jenkins/updates/update-center.json 
之后 在浏览器输入  http://ip:8080/restart 再进入 http://ip:8080登陆即可正常

$  service jenkins start  //如果还不行 进行重启

如果出现登陆成功卡在空白页面输入http://ip:8080/restart 进行重启或 service jenkins start

Linux 安装Maven

发表于 2019-08-30 | 更新于 2019-12-20 | 分类于 Maven |

Maven官网下载地址

######安装 Java

$ sudo apt-get update

$ sudo apt-get install openjdk-8-jdk

$ java -version
openjdk version "1.8.0_232"
OpenJDK Runtime Environment (build 1.8.0_232-8u232-b09-0ubuntu1~18.04.1-b09)
OpenJDK 64-Bit Server VM (build 25.232-b09, mixed mode)

$ wget http://mirrors.tuna.tsinghua.edu.cn/apache/maven/maven-3/3.6.2/binaries/apache-maven-3.6.2-bin.tar.gz
--2019-09-06 16:35:40--  http://mirrors.tuna.tsinghua.edu.cn/apache/maven/maven-3/3.6.2/binaries/apache-maven-3.6.2-bin.tar.gz
Resolving mirrors.tuna.tsinghua.edu.cn... 101.6.8.193, 2402:f000:1:408:8100::1
Connecting to mirrors.tuna.tsinghua.edu.cn|101.6.8.193|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 9142315 (8.7M) [application/x-gzip]
Saving to: “apache-maven-3.6.2-bin.tar.gz”

100%[================================================================================================================================================>] 9,142,315    630K/s   in 16s     

2019-09-06 16:35:56 (552 KB/s) - “apache-maven-3.6.2-bin.tar.gz” saved [9142315/9142315]

$ ls
apache-maven-3.6.2-bin.tar.gz bin include  jdk  lib  lib64  libexec  records  sbin  share  src
$ tar zxvf apache-maven-3.6.2-bin.tar.gz 
$ mv apache-maven-3.6.2 maven
$ vim /etc/profile //尾部添加 配置环境变量
MAVEN_HOME=/usr/local/maven
PATH=$PATH:$MAVEN_HOME/bin
export MAVEN_HOME
export PATH
$ source /etc/profile
$ mvn -v //验证是否安装成功
Apache Maven 3.6.2 (40f52333136460af0dc0d7232c0dc0bcf0d9e117; 2019-08-27T23:06:16+08:00)
Maven home: /usr/local/maven
Java version: 1.8.0_45, vendor: Oracle Corporation, runtime: /usr/local/jdk/jre
Default locale: en_US, platform encoding: UTF-8
OS name: "linux", version: "2.6.32-754.12.1.el6.x86_64", arch: "amd64", family: "unix"