apt-get install g++ gcc make libncurses5-dev libssl-dev

cd RunSoft
wget http://erlang.org/download/otp_src_18.3.tar.gz
tar otp_src_18.3.tar.gz
 ./configure 
 make -j4 
 sudo make install

export PATH=/opt/otp/bin:$PATH

source ~/.bashrc

# Erlang
#export PATH=/opt/otp/bin:$PATH

/data/home/yzhang/CoamRunning/Erlang/ejabberd/deps/emysql/src/emysql_conn.erl:337: Warning: erlang:now/0: Deprecated BIF. See the "Time and Time Correction in Erlang" chapter of the ERTS User's Guide for more information.

# NeoSmart NeoGrub Bootloader Configuration File
#
# This is the NeoGrub configuration file, and should be located at C:\NST\menu.lst
# Please see the EasyBCD Documentation for information on how to create/modify entries:
# http://neosmart.net/wiki/display/EBCD/

title Install Ubuntu
root (hd0,0)
kernel (hd0,0)/vmlinuz.efi boot=casper iso-scan/filename=/ubuntu-15.10-desktop-amd64.iso locale=zh_CN.UTF-8
initrd (hd0,0)/initrd.lz
title reboot
reboot
title halt
halt

cd /data/home;
sudo mkdir yzhang
sudo chown yzhang:yzhang yzhang
//sudo usermod -d /data/home/yzhang -m yzhang

sudo apt-get install vim
sudo apt-get install git

sudo visudo

yzhang ALL=(ALL)NOPASSWD:ALL

sudo apt-get install lnav

$ ./configure
$ make
$ sudo make install

$ lnav /var/log/messages*

sudo apt-get --purge remove fcitx*

sudo apt-get --purge autoremove

sudo gdebi sogou_pinyin_linux_1.0.0.0014_amd64.deb

sudo add-apt-repository ppa:fcitx-team/nightly

sudo apt-get update

sudo apt-get install fcitx

sudo apt-get install fcitx-config-gtk

sudo apt-get install fcitx-table-all

sudo apt-get install im-switch

sudo apt-get install fcitx fcitx-config-gtk fcitx-table-all im-switch

sudo dpkg -i sogoupinyin_2.0.0.0068_amd64.deb

sudo apt-get install -f

sudo apt-get install vim automake make perl gcc g++
sudo apt-get install bison g++-multilib git flex lzop gperf libxml2-utils zlib1g-dev

sudo apt-get install cmake qtcreator

sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java8-installer

java -version

Picked up JAVA_TOOL_OPTIONS: -javaagent:/usr/share/java/jayatanaag.jar

sudo rm /usr/share/upstart/sessions/jayatana.conf

sudo add-apt-repository ppa:webupd8team/sublime-text-3
sudo apt-get update
sudo apt-get install sublime-text

—– BEGIN LICENSE —–
Andrew Weber
Single User License
EA7E-855605
813A03DD 5E4AD9E6 6C0EEB94 BC99798F
942194A6 02396E98 E62C9979 4BB979FE
91424C9D A45400BF F6747D88 2FB88078
90F5CC94 1CDC92DC 8457107A F151657B
1D22E383 A997F016 42397640 33F41CFC
E1D0AE85 A0BBD039 0E9C8D55 E1B89D5D
5CDB7036 E56DE1C0 EFCC0840 650CD3A6
B98FC99C 8FAC73EE D2B95564 DF450523
—— END LICENSE ——

cd ~/.config/sublime-text-3/Packages/
git clone https://github.com/wbond/package_control_channel.git Package\ Control

sudo ln -s /media/yzhang/0000678400004823/DeveloperWorkspace/CoamServer/ ~/CoamServer
sudo ln -s /media/yzhang/0000678400004823/DeveloperWorkspace/ ~/DeveloperWorkspace

sudo add-apt-repository ppa:hzwhuang/ss-qt5
sudo apt-get update
sudo apt-get install shadowsocks-qt5

ss-qt5

$ sudo apt-get install ksnapshot

sudo passwd root

sudo vi /usr/share/lightdm/lightdm.conf.d/50-ubuntu.conf

[Seat:*]
user-session=ubuntu
greeter-show-manual-login=true

sudo apt-get remove unity-webapps-common

sudo apt-get remove thunderbird totem rhythmbox empathy brasero simple-scan gnome-mahjongg aisleriot \
 gnome-mines cheese transmission-common gnome-orca webbrowser-app gnome-sudoku  landscape-client-ui-install

sudo apt-get remove onboard deja-dup

sudo apt-get install python python-psutil python-appindicator 
sudo apt-get install python-gtk2

sudo dpkg -i indicator-sysmonitor_0.4.3_all.deb

sudo apt-get install dstat
sudo apt-get install acpi

$ mkdir -p ~/.scripts && cd ~/.scripts
$ wget http://webupd8.googlecode.com/files/sysmon_0.2.tar.gz && tar -xvf sysmon_0.2.tar.gz

$ sudo apt-get install glances
$ glances

sudo apt-get install ubuntu-desktop

sudo apt-get install --reinstall ubuntu-desktop

sudo reboot

chmod +x /home/auto.sh # 赋予 auto.sh 可执行权限
chmod -R 777 /home/wwwroot # 赋予 /home/wwwroot 写入权限(部分网站程序安装时需要用到)

rm test.tar.gz # 删除test.tar.gz,会有提示你确认 y即可
rm -rf /home/wwwroot/test # 无提示直接删除test目录,勿乱用,切记.

tar zcvf test.tar.gz /home/wwwroot #把/home/wwwroot打包
tar zxvf tet.tar.gz # 在当前目录解压test.tar.gz

zip -r tester.zip /home/wwwroot #把/home/wwwroot打包
unzip teter.zip # 在当前目录解压test.tar.gz

scp -P 2222 root@www.legcloud.com:/root/test.tar.gz /home/test.tar.gz

scp -P 2222 -r root@www.legcloud.com:/root/dirname/ /home/dirname/

scp -P 2222 /home/test.tar.gz root@www.legcloud.com:/root/test.tar.gz

scp -P 2222 -r /home/dirname/ root@www.legcloud.com:/root/dirname/

# 如果你是 centos 系统,执行:

yum install iftop

# 如果你是 debian/ubuntu 系统,执行:

apt-get install iftop

# 使用 ifconfig ,查看所有网络配置,使用 -i 参数选择相关网络.

ifconfig

# 阿里云默认的 iftop ,执行查看的是第一个,即内网的IP,以下二个命令效果相同

iftop
iftop -i eth0

# 如果查看外网带宽,则需要选择外网配置的eth,默认命令

iftop -i eth1

mysql> SHOW SLAVE STATUS;

GRANT REPLICATION SLAVE ON *.* TO 'syBackup'@'42.96.194.60' IDENTIFIED BY '******';

#################################################
server-id=1 #主机id,整数
#开启二进制日志,并且名称为 /var/lib/mysql/mysql-bin.***
# 如果是个路径则,保存到该路径下(log-bin=/var/log/mysql-bin.log -> /var/log/mysql-bin.***)
log-bin=mysql-bin

### as master ###
read-only=0 #主机读写权限,读写都可以

binlog-do-db=CoamDatabase #记录日志的数据库:需要的备份数据,多个写多行
binlog-do-db=CoamInfo
binlog-do-db=CoamSNS
binlog-do-db=form
binlog-do-db=CommonData
binlog-do-db=Wordpress
binlog-do-db=IM_Ejabberd

binlog-ignore-db=mysql #不记录日志的数据库:不需要备份的数据库,多个写多行
binlog-ignore-db=test
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema

# 自增字段奇数递增,防止冲突(1, 11, 21, ...,)
auto-increment-increment = 10 # 每次递增的步长
auto-increment-offset = 1 # 初始值

### as slave ###
###
###############################################################

Tue May 17 10:31:52 yzhang@coam:/data/home/data/mysql$ ls
auto.cnf         client-key.pem  coam.pid    ib_buffer_pool  ibtmp1           performance_schema  server-key.pem
ca-key.pem       CoamDatabase    CoamSNS     ibdata1         IM_Ejabberd      private_key.pem     sys
ca.pem           coam.err        CommonData  ib_logfile0     mysql            public_key.pem      test
client-cert.pem  CoamInfo        forum       ib_logfile1     mysqld_safe.pid  server-cert.pem     Wordpress
Tue May 17 10:31:52 yzhang@coam:/data/home/data/mysql$ sudo service mysql restart       ======> 重启 Mysql 数据库服务
Tue May 17 10:31:52 yzhang@coam:/data/home/data/mysql$ ls
auto.cnf         CoamDatabase  CommonData      ib_logfile1       mysql-bin.000002  performance_schema  sys
ca-key.pem       coam.err      forum           ibtmp1            mysql-bin.000003  private_key.pem     test
ca.pem           CoamInfo      ib_buffer_pool  IM_Ejabberd       mysql-bin.000004  public_key.pem      Wordpress
client-cert.pem  coam.pid      ibdata1         mysql             mysql-bin.index   server-cert.pem
client-key.pem   CoamSNS       ib_logfile0     mysql-bin.000001  mysqld_safe.pid   server-key.pem

mysql> FLUSH TABLES WITH READ LOCK;

mysqldump --master-data -uroot -p hello > hello.sql
mysqldump -u username -p password --databases CoamDatabase CoamInfo CoamSNS CommonData Wordpress IM_Ejabberd >backup.sql

mysql> show master status\G;
*************************** 1. row ***************************
             File: mysql-bin.000005
         Position: 154
     Binlog_Do_DB: CoamDatabase,CoamInfo,CoamSNS,forum,CommonData,Wordpress,IM_Ejabberd
 Binlog_Ignore_DB: mysql,test,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.00 sec)

ERROR:
No query specified

UNLOCK TABLES;

[mysqld]

####################################################################
server-id=2
log-bin=mysql-bin

### as master ###
### as slave ###
replicate-do-db=CoamDatabase #只复制某个库,多个写多行
replicate-do-db=CoamInfo
replicate-do-db=CoamSNS
replicate-do-db=form
replicate-do-db=CommonData
replicate-do-db=Wordpress
replicate-do-db=IM_Ejabberd

replicate-ignore-db=mysql #不复制某个库
replicate-ignore-db=test
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

relay-log=mysqld-relay-bin # 开启日志中继
log-slave-updates # slave 将复制事件写进自己的二进制日志
#5.5
#log-slave-updates = ON
#5.1
#log-slave-updates = 1
###############################################################

Tue May 17 11:07:14 yzhang@coam:/data/home/data/mysql$ ls
auto.cnf    client-cert.pem  coam.pid        ib_logfile0  mysql               private_key.pem  server-key.pem
ca-key.pem  client-key.pem   ib_buffer_pool  ib_logfile1  mysqld_safe.pid     public_key.pem   sys
ca.pem      coam.err         ibdata1         ibtmp1       performance_schema  server-cert.pem
Tue May 17 10:31:52 yzhang@coam:/data/home/data/mysql$ sudo service mysql restart       ======> 重启 Mysql 数据库服务
Tue May 17 11:08:40 yzhang@coam:/data/home/data/mysql$ ls
auto.cnf    client-cert.pem  coam.pid        ib_logfile0  mysql             mysqld_safe.pid     public_key.pem   sys
ca-key.pem  client-key.pem   ib_buffer_pool  ib_logfile1  mysql-bin.000001  performance_schema  server-cert.pem
ca.pem      coam.err         ibdata1         ibtmp1       mysql-bin.index   private_key.pem     server-key.pem

mysql> CREATE DATABASE CoamDatabase DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> CREATE DATABASE CoamInfo DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> CREATE DATABASE CoamSNS DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> CREATE DATABASE CommonData DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> CREATE DATABASE Wordpress DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> CREATE DATABASE IM_Ejabberd DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

mysql> source backup.sql;

# 以下方式分别导入数据库
mysql -uroot -p CoamDatabase < backup.sql
mysql -uroot -p CoamInfo < backup.sql
mysql -uroot -p CoamSNS < backup.sql
mysql -uroot -p CommonData < backup.sql
mysql -uroot -p Wordpress < backup.sql
mysql -uroot -p IM_Ejabberd < backup.sql

mysql> slave stop;
mysql> CHANGE MASTER TO
-> MASTER_HOST='43.241.222.110', //主服务器的IP地址
-> MASTER_USER='syBackup', //同步数据库的用户
-> MASTER_PASSWORD='******', //同步数据库的密码
-> MASTER_CONNECT_RETRY=60,  // 如果从服务器发现主服务器断掉,重新连接的时间差(秒)
-> MASTER_LOG_FILE='mysql-bin.000001', //主服务器二进制日志的文件名(前面要求记住的 File 参数)
-> MASTER_LOG_POS=98; //日志文件的开始位置(前面要求记住的 Position 参数)
mysql> CHANGE MASTER TO MASTER_HOST='43.241.222.110', MASTER_USER='syBackup', MASTER_PASSWORD='******', MASTER_CONNECT_RETRY=60, MASTER_LOG_FILE='mysql-bin.000005', MASTER_LOG_POS=154;
mysql > slave start;

service mysqld restart

mysql> show slave status\G;
*************************** 1. row ***************************
            Slave_IO_State: Connecting to master
                Master_Host: 43.241.222.110
                Master_User: syBackup
                Master_Port: 3306
            Connect_Retry: 60
            Master_Log_File: mysql-bin.000001
        Read_Master_Log_Pos: 98
            Relay_Log_File: mysqld-relay-bin.000001
            Relay_Log_Pos: 98
    Relay_Master_Log_File: mysql-bin.000001
        Slave_IO_Running: Yes
        Slave_SQL_Running: Yes
            Replicate_Do_DB: CoamDatabase,CoamInfo,CoamSNS,form,CommonData,Wordpress,IM_Ejabberd
 Replicate_Ignore_DB: mysql,test,information_schema,performance_schema,collie,ding,inotseeyou_com,pi
wik,trac,wzjp_net
        Exec_Master_Log_Pos: 98
            Relay_Log_Space: 98
            Until_Log_Pos: 0
    Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Slave_IO_State: Waiting for master to send event

mysql> use hello;
Database changed
mysql> create table test(id int);
mysql> insert int test set id=1;

mysql> show master status\G;
*************************** 1. row ***************************
            File: mysql-bin.000002  # 注意这里
        Position: 276    # 注意这里
    Binlog_Do_DB:
CoamDatabase,CoamInfo,CoamSNS,form,CommonData,Wordpress,IM_Ejabberd
Binlog_Ignore_DB: mysql,test,information_schema,performance_schema,collie,ding,inotseeyou_com,pi
wik,trac,wzjp_net

1 row in set (0.00 sec)

mysql> use hello;
mysql> show tables;
+-----------------+
| Tables_in_hello |
+-----------------+
| test            | 
+-----------------+
1 row in set (0.00 sec)

mysql> select * from test;
+------+
| id   |
+------+
|    1 | 
+------+
1 row in set (0.00 sec)

mysql> show slave status\G;
*************************** 1. row ***************************
            Slave_IO_State: Waiting for master to send event
                Master_Host: 43.241.222.110
                Master_User: syBackup
                Master_Port: 3306
            Connect_Retry: 60
            Master_Log_File: mysql-bin.000002  # 跟 master 一样
        Read_Master_Log_Pos: 276  # 跟 master 一样
            Relay_Log_File: mysqld-relay-bin.000003
            Relay_Log_Pos: 413
    Relay_Master_Log_File: mysql-bin.000002
        Slave_IO_Running: Yes
        Slave_SQL_Running: Yes
            Replicate_Do_DB: CoamDatabase,CoamInfo,CoamSNS,form,CommonData,Wordpress,IM_Ejabberd
 Replicate_Ignore_DB: mysql,test,information_schema,performance_schema,collie,ding,inotseeyou_com,pi
wik,trac,wzjp_net
                Last_Errno: 0
                Last_Error: 
            Skip_Counter: 0
        Exec_Master_Log_Pos: 276
            Relay_Log_Space: 413
    Seconds_Behind_Master: 0
1 row in set (0.00 sec)

serivce mysqld restart

mysql> GRANT REPLICATION SLAVE ON *.* TO 'syBackup'@'43.241.222.110' IDENTIFIED BY '******';
mysql> FLUSH TABLES WITH READ LOCK;
mysql> show master status\G;
*************************** 1. row ***************************
         File: mysql-bin.000003
         Position: 468
     Binlog_Do_DB: CoamDatabase,CoamInfo,CoamSNS,forum,CommonData,Wordpress,IM_Ejabberd
 Binlog_Ignore_DB: mysql,test,information_schema,performance_schema
Executed_Gtid_Set:
1 row in set (0.01 sec)
mysql> UNLOCK TABLES;

mysql> slave stop;
mysql>  CHANGE MASTER TO MASTER_HOST='42.96.194.60', MASTER_USER='syBackup', MASTER_PASSWORD='yafei312', MASTER_CONNECT_RETRY=60, MASTER_LOG_FILE='mysql-bin.000004, MASTER_LOG_POS=46702';
mysql> slave start;

mysql> show slave status\G;

#2002 - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) — The server is not responding (or the local server's socket is not correctly configured).

yzhang@coam:~$ sudo find / -type s
/tmp/mongodb-27017.sock
/tmp/mysql/mysql.sock
/run/fail2ban/fail2ban.sock
...

[client]
socket=/tmp/mysql/mysql.sock <= this path should be also same as is[mysqld]

sudo service mysql restart

sudo ln -s /tmp/mysql/mysql.sock /var/run/mysqld/mysqld.sock

/usr/bin/mysql -u root -p -S /home/mysql/mysql.sock

vi /etc/php5/fpm/php.ini

[Pdo_mysql]
...
pdo_mysql.default_socket = /tmp/mysql/mysql.sock
...

[MySQL]
...
mysql.default_socket = /tmp/mysql/mysql.sock
...

[MySQLi]
...
mysqli.default_socket = /tmp/mysql/mysql.sock
...

mysql> CREATE DATABASE CoamDatabase DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

mysql> DROP DATABASE CoamDatabase;

mysqldump -u root -p CoamDatabase > CoamDatabase.sql   (输入后会让你输入进入MySQL的密码)

mysqldump -h hostname -u username -p password --databases db_name1 db_name2 db_namen >backup.sql

mysqldump -h hostname -u username -p password --no-data --databases db_name1 db_name2 db_namen >backup.sql

mysqldump -h hostname -u username -p password --all-databases >backup.sql

mysqldump —opt —skip-comments —extended-insert=false -uroot -p1234 inotseeyou_com > inotseeyou_com.sql

CREATE DATABASE CoamDatabase DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
use CoamDatabase;
source CoamDatabase.sql;

mysql> SELECT User, Host, Password FROM mysql.user;

mysql> INSERT INTO mysql.user (User,Host,Password) VALUES('demouser','localhost',PASSWORD('demopassword'));

mysql> GRANT USAGE ON *.* TO 'zhangyanxi'@'localhost' IDENTIFIED BY 'yanxi312' WITH GRANT OPTION;
mysql> GRANT ALL ON *.* TO 'zhangyanxi'@'localhost';        ======> 给用户授权
mysql> flush privileges;

mysql> GRANT ALL PRIVILEGES ON demodb.* to demouser@localhost;
GRANT SELECT, INSERT ON *.* TO 'zhangyanxi'@'localhost';
GRANT ALL ON *.* TO 'zhangyanxi'@'%';

mysql> SHOW GRANTS FOR 'demouser'@'localhost';