redis

http://www.runoob.com/redis/redis-tutorial.html

mariadb ubuntu 16.4

官方
https://mariadb.com/kb/en/mariadb/installing-mariadb-deb-files/

• New Key
• Add MariaDB to your sources.list 

sudo apt-get install software-properties-common 
sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
sudo add-apt-repository 'deb http://ftp.osuosl.org/pub/mariadb/repo/10.0/ubuntu trusty main'


sudo apt-get update
sudo apt-get install mariadb-server


．begin install maybe have question about other mariadb toolkit install
If Y -> have one question for root password
If N -> use  mysql_secure_installtion  for secure


Finish install mariadb.

modify my.cnf    /etc/mysql  ( find / -name my.cnf )

[mysqld]
1、port  maybe change  3306 -> 6033
2、listen maybe 127.0.0.1 -> 0.0.0.0


login mysql

1、root login anywhere %, full rights

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'put password' with grant option;


2、create other account  login anywhere %, full rights

GRANT ALL PRIVILEGES ON *.* TO 'otheraccount'@'%' IDENTIFIED BY 'put password' with grant option;



3、remove  Revoke  (權限)

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'root'@'%';

4、Remove/Delete the user

DROP USER 'root'@'%';

5、show user and grant 顯示
SELECT User,Host FROM mysql.user;

SHOW GRANTS FOR 'root'@'localhost';
SHOW GRANTS FOR 'root'@'%';

http://idroot.net/linux/install-mariadb-ubuntu-16-04/

T2 instance CPU Credit Usage & Balance

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/t2-instances.html


CPUCreditUsage

(Only valid for T2 instances) The number of CPU credits consumed during the specified period.

consumed 消耗


CPUCreditBalance

(Only valid for T2 instances) The number of CPU credits that an instance has accumulated.

accumulated 累積