2015年6月8日 星期一

[研究] Visual Studio Community 2013 with Update 4 安裝語系套件 Language Pack

[研究] Visual Studio Community 2013 with Update 4 安裝語系套件 Language Pack

2015-06--08

Visual Studio Community 2013 with Update 4 下載
https://www.visualstudio.com/zh-tw/downloads/download-visual-studio-vs#DownloadFamilies_2


由於該網頁 Language Pack 不提供 繁體中文語系套件,參考下面這篇下載語系套件

Microsoft Visual Studio 2013 語言套件 - 繁體中文
http://shaurong.blogspot.com/2015/06/visual-studio-2013-language-pack.html

(下圖) 安裝結果,失敗



有可能這是不含任何 Update 的語系套件,所以不能用;也可能它不支援社群版。
因為微軟公開的下載中心沒找到聲明有包含 Update 4 的 語系套件,改去 MSDN 找,發現有,開始下載安裝。











最後 Visual Studio Community 2013 with Update 4 變成繁體中文介面了。

(完)

[研究] Visual Studio 2013 Language Pack 語言套件 - 離線安裝版下載

[研究] Visual Studio 2013 Language Pack 語言套件 - 離線安裝版下載

2015-06-08

Microsoft Visual Studio 2013 語言套件 - 繁體中文
http://www.microsoft.com/zh-tw/download/details.aspx?id=40783

如果直接執行 vs_langpack.exe,會進行線上下載安裝。如果要安裝多台,會浪費下載時間和頻寬。

執行 vs_langpack.exe   /?  可以看到提供的參數,其中  /layout 參數可以下載語言套件的檔案,然後進行離線安裝。






 (下圖) 路徑太長,換個短些的




(完)

2015年6月4日 星期四

[研究] mysql-5.6.25.tar.gz 安裝 (CentOS 7.1 x86_64)

[研究] mysql-5.6.25.tar.gz 安裝 (CentOS 7.1 x86_64)

2015-06-04

參考
http://dev.mysql.com/doc/refman/5.6/en/installing-source-distribution.html

下面為切換 su 在 /root 目錄下安裝情況
wget 若沒安裝可用 yum -y install wget 安裝
mysql-5.6.25.tar.gz 請自行下載
http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.25.tar.gz
http://www.mysql.com/downloads/mysql/#downloads
(下拉選單選 Source Code,到最後一個 Generic Linux (Architecture Independent), Compressed TAR Archive)

mv   /etc/my.cnf   /etc/my.cnf.old

yum -y install  gcc  gcc-c++  ncurses*  cmake  bison

groupadd mysql
useradd -r -g mysql mysql
tar zxvf  mysql-5.6.25.tar.gz
cd mysql-5.6.25
cmake  .
make
make install

cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
yum -y install perl-Data-Dumper  perl-XML-Dumper
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data
bin/mysqld_safe --user=mysql &
cp support-files/mysql.server /etc/init.d/mysql.server

編譯可能發生問題

照官方這篇,沒有提到需要 ncurses* 套件,但是需要
http://dev.mysql.com/doc/refman/5.6/en/source-installation.html

在 cmake 過程,如果出現類似下面錯誤,請執行 rm -fr  /usr/local/mysql-5.6.25 把整個目錄砍掉
重新解壓 mysql-5.6.25.tar.gz,重新執行 cmake
( 一般若需要的套件沒先用 yum 安裝,而在 cmake 後才安裝會發生)

[root@localhost mysql-5.6.25]# cmake .
....(略)
CMake Error at /usr/share/cmake/Modules/TestBigEndian.cmake:31 (MESSAGE):
  no suitable type found
Call Stack (most recent call first):
  configure.cmake:626 (TEST_BIG_ENDIAN)
  CMakeLists.txt:390 (INCLUDE)

-- Configuring incomplete, errors occurred!
[root@localhost mysql-5.6.15]#

啟動 MySQL 可用

[root@localhost mysql]#  /usr/local/mysql/bin/mysqld_safe --user=mysql &

[root@localhost mysql]#  service   mysql.server   start

檢查一下

[root@localhost mysql]# ps aux | grep mysql
root      30236  0.0  0.0 113248  1592 pts/1    S    15:41   0:00 /bin/sh bin/mysqld_safe --user=mysql
mysql     30326  1.1 23.9 970380 447716 pts/1   Sl   15:41   0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/localhost.localdomain.err --pid-file=/usr/local/mysql/data/localhost.localdomain.pid
root      30350  0.0  0.0 112640   960 pts/1    R+   15:41   0:00 grep --color=auto mysql
[root@localhost mysql]#


停止 MySQL

[root@localhost mysql]#  service    mysql.server   stop

Shutting down MySQL.150604 15:42:16 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended
 SUCCESS!
[1]+  Done                    bin/mysqld_safe --user=mysql

或把 Process ID 用 kill -9 砍掉
[root@localhost mysql]# kill -9  30236

(完)

相關文章

[研究] mysql-5.6.25.tar.gz 安裝 (CentOS 7.1 x86_64)
http://shaurong.blogspot.com/2015/06/mysql-5625targz-centos-71-x8664.html

[研究] mysql-5.6.20.tar.gz 安裝 (CentOS 7.0 x86_64)
http://shaurong.blogspot.com/2014/08/mysql-5620targz-centos-70-x8664.html

[研究] mysql-5.6.15.tar.gz 安裝(CentOS 6.5 x64)
http://shaurong.blogspot.tw/2014/01/mysql-5615targz-centos-65-x64.html
http://forum.icst.org.tw/phpbb/viewtopic.php?f=21&t=80713

[研究] MySQL 5.6.15 安裝(rpm)(CentOS 6.5 x64)
http://shaurong.blogspot.com/2014/01/mysql-5615-rpmcentos-65-x64.html

[研究] MySQL Community 5.6.15 版安裝(yum) (CentOS 6.5 x64)
http://shaurong.blogspot.com/2014/01/mysql-community-5615-tgz-centos-65-x64.html

[研究] 4主機 MySQL Cluster 7.3.3 架設(CentOS 6.5 x64)
http://shaurong.blogspot.tw/2014/01/4-mysql-cluster-7.html

[研究] 4主機 MySQL Cluster 7.2.10.1 架設
http://shaurong.blogspot.tw/2013/02/4-mysql-cluster-7210-1.html

[研究] 2主機 MySQL Cluster 7.2.10-1 架設
http://shaurong.blogspot.com/2013/02/2-mysql-cluster-7210-1.html

[研究] 4主機 MySQL Cluster 7.0.9 架設
http://forum.icst.org.tw/phpbb/viewtopic.php?f=10&t=17903

[研究] 雙主機 MySQL Cluster 7.0.9架設
http://forum.icst.org.tw/phpbb/viewtopic.php?f=10&t=17904

[研究] MariaDB 5.5 安裝(yum)(CentOS 6.3 x64)
http://shaurong.blogspot.com/2013/02/mariadb-55-yum-centos-63-x64.html

[研究] CentOS 5.4 x86 上 MySQL 資料庫同步(Replication)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=17824

[研究] mariadb-5.1.42 (tar.gz)(瑪利亞資料庫, MySQL) 安裝 (CentOS 5.4)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=17988

[研究] mariadb-5.2.4-Linux-i686.tar.gz 安裝 (CentOS 5.5 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19434

[研究] mysql-5.5.14.tar.gz 安裝(失敗)(CentOS 6.0 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=20252

[研究] mysql-5.5.8.tar.gz 安裝(CentOS 5.5 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19214

[研究] mysql-5.5.8.tar.gz 安裝(Fedora 14 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19215

[研究] 每天自動備份 MySQL 方法
http://forum.icst.org.tw/phpbb/viewtopic.php?t=14972

[研究] 雙主機 MySQL Cluster 7.0.9 架設

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 7.1 x64)(繁體中文版)(失敗)

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 7.1 x64)(繁體中文版)

2015-06-02
Lu

WordPress 台灣正體中文網站
http://tw.wordpress.org/

安裝參考
http://tw.wordpress.org/txt-install/

下載
https://tw.wordpress.org/wordpress-4.2.2-zh_TW.tar.gz
https://tw.wordpress.org/wordpress-4.2.2-zh_TW.zip


安裝

# 立刻關閉 SELinux
/usr/sbin/setenforce 0 

# 設定 reboot 後也關閉 SELinux
sed -i -e "s@SELINUX=enforcing@#SELINUX=enforcing@" /etc/selinux/config
sed -i -e "s@SELINUX=permissive@#SELINUX=permissive@" /etc/selinux/config
sed -i -e "/SELINUX=/aSELINUX=disabled" /etc/selinux/config

yum  -y install php php-mysql mysql httpd mariadb-server

#chkconfig httpd on
#service httpd restart
systemctl enable httpd
systemctl start httpd
systemctl status httpd

#chkconfig mysqld on
#service mysqld restart
systemctl enable mariadb
systemctl  start  mariadb
systemctl  status  mariadb


# 替 MySQL 的 root 帳號設定密碼
/usr/bin/mysql_secure_installation

[root@localhost ~]# /usr/bin/mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n]
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n]
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n]
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
[root@localhost ~]#


# 建立 WordPress 系統使用的資料庫,稱為 wordpressdb,連線帳號 wordpresser,密碼 123456
(可以依自己喜好修改)

[root@localhost ~]# mysql -u root -pABCDE
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.71 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database wordpressdb;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on wordpressdb.* to wordpresser@localhost identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@localhost ~]#

# 假設 MySQL root 的密碼為 ABCDE
mysqladmin --user=root  -pABCDE  create wordpressdb
# 建立使用者 galerauser,密碼 123456,給 Cluster 使用
mysql -e "GRANT ALL PRIVILEGES ON *.* TO wordpresser@localhost IDENTIFIED BY '123456' ; " -pABCDE

mysql -uroot -pABCDE -e "show databases;"
#mysql -e -uroot  -pABCDE "use wordpressdb; show databases; "
#mysql -e "use wordpressdb; show tables; "
#mysql -e "GRANT ALL PRIVILEGES ON wordpressdb.* TO wordpresser@localhost IDENTIFIED BY 'wordpresser' ; "
#mysql -e " flush privileges; "
#mysql -e "use mysql; select * from user where User='wordpresser'; "

cd    /usr/local/src
wget    https://tw.wordpress.org/wordpress-4.2.2-zh_TW.tar.gz
tar   xzvf   wordpress-4.2.2-zh_TW.tar.gz    -C   /var/www/html
# 為了寫入 wp-config.php
chmod  -R a+w /var/www/html/wordpress
#touch /var/www/html/wordpress/wp-config.php
#chmod   a+w /var/www/html/wordpress/wp-config.php
cp wp-config-sample.php wp-config.php

define('DB_NAME', 'database_name_here');
define('DB_USER', 'username_here');
改為

define('DB_NAME', 'wordpressdb');
define('DB_USER', 'wordpresser');



# 啟動瀏覽器,連上網站
firefox   httpd://192.168.128.71/wordpress












失敗,有問題,不知是作業系統因素 ? 還是資料庫因素 ? or 其他因素 ?

(待續)

相關

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 7.1 x64)(繁體中文版)(失敗)
http://shaurong.blogspot.com/2015/06/wordpress-422-centos-71-x64.html

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 6.6 x64)(繁體中文版)
http://shaurong.blogspot.com/2015/06/wordpress-422-centos-66-x64.html

[研究] WordPress 3.8.1 部落格伺服器架設 (CentOS 6.5 x64)(繁體中文版)
http://shaurong.blogspot.com/2014/01/wordpress-381-centos-65-x64.html

[研究] WordPress 3.7 部落格伺服器架設 (CentOS 6.4 x64)(繁體中文版)
http://shaurong.blogspot.tw/2013/10/wordpress-27-centos-64-x64.html

[研究] WordPress網誌 快速安裝程式(CentOS 5.5 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19279

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 6.6 x64)(繁體中文版)

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 6.6 x64)(繁體中文版)

2015-06-04
Lu

WordPress 台灣正體中文網站
http://tw.wordpress.org/

安裝參考
http://tw.wordpress.org/txt-install/

下載
https://tw.wordpress.org/wordpress-4.2.2-zh_TW.tar.gz
https://tw.wordpress.org/wordpress-4.2.2-zh_TW.zip


安裝

# 立刻關閉 SELinux
/usr/sbin/setenforce 0 

# 設定 reboot 後也關閉 SELinux
sed -i -e "s@SELINUX=enforcing@#SELINUX=enforcing@" /etc/selinux/config
sed -i -e "s@SELINUX=permissive@#SELINUX=permissive@" /etc/selinux/config
sed -i -e "/SELINUX=/aSELINUX=disabled" /etc/selinux/config

yum  -y install php php-mysql mysql httpd mysql-server

chkconfig httpd on
service httpd restart

chkconfig mysqld on
service mysqld restart


# 替 MySQL 的 root 帳號設定密碼 (下面假設設定為 ABCDE)
/usr/bin/mysql_secure_installation

[root@localhost ~]# /usr/bin/mysql_secure_installation


NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


In order to log into MySQL to secure it, we'll need the current
password for the root user.  If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.

Set root password? [Y/n]
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n]
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]
 ... Success!

By default, MySQL comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n]
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n]
 ... Success!

Cleaning up...



All done!  If you've completed all of the above steps, your MySQL
installation should now be secure.

Thanks for using MySQL!


[root@localhost ~]#


# 建立 WordPress 系統使用的資料庫,稱為 wordpressdb,連線帳號 wordpresser,密碼 123456
(可以依自己喜好修改)

[root@localhost ~]# mysql -u root -pABCDE

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database wordpressdb;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on wordpressdb.* to wordpresser@localhost identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
[root@localhost ~]#


# 假設 MySQL root 的密碼為 ABCDE
mysqladmin --user=root  -pABCDE  create wordpressdb
# 建立使用者 galerauser,密碼 123456,給 Cluster 使用
mysql -e "GRANT ALL PRIVILEGES ON *.* TO wordpresser@localhost IDENTIFIED BY '123456' ; " -pABCDE
#mysql -e "GRANT ALL PRIVILEGES ON *.* TO wordpresser@% IDENTIFIED BY '123456' ; " -pABCDE
mysql -e " flush privileges; " -pABCDE

mysql -uroot -pABCDE -e "show databases;"
#mysql -e -uroot  -pABCDE "use wordpressdb; show databases; "
#mysql -e "use wordpressdb; show tables; "
#mysql -e "GRANT ALL PRIVILEGES ON wordpressdb.* TO wordpresser@localhost IDENTIFIED BY 'wordpresser' ; "
#mysql -e " flush privileges; "
#mysql -e "use mysql; select * from user where User='wordpresser'; "

cd    /usr/local/src
wget    https://tw.wordpress.org/wordpress-4.2.2-zh_TW.tar.gz
tar   xzvf   wordpress-4.2.2-zh_TW.tar.gz    -C   /var/www/html
# 為了寫入 wp-config.php
chmod  -R a+w /var/www/html/wordpress
#touch /var/www/html/wordpress/wp-config.php
#chmod   a+w /var/www/html/wordpress/wp-config.php

# 啟動瀏覽器,連上網站
firefox   httpd://192.168.128.66/wordpress











最後把權限改回
chmod a-w /var/www/html/wordpress

(完)

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 7.1 x64)(繁體中文版)(失敗)
http://shaurong.blogspot.com/2015/06/wordpress-422-centos-71-x64.html

[研究] WordPress 4.2.2 部落格伺服器架設 (CentOS 6.6 x64)(繁體中文版)
http://shaurong.blogspot.com/2015/06/wordpress-422-centos-66-x64.html

[研究] WordPress 3.8.1 部落格伺服器架設 (CentOS 6.5 x64)(繁體中文版)
http://shaurong.blogspot.com/2014/01/wordpress-381-centos-65-x64.html

[研究] WordPress 3.7 部落格伺服器架設 (CentOS 6.4 x64)(繁體中文版)
http://shaurong.blogspot.tw/2013/10/wordpress-27-centos-64-x64.html

[研究] WordPress網誌 快速安裝程式(CentOS 5.5 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19279

2015年6月2日 星期二

[研究] Redis 3.0.1 資料庫 安裝(tar.gz)(CentOS 7.1 x86_64)

[研究] Redis 3.0.1 資料庫 安裝(tar.gz)(CentOS 7.1 x86_64)

2015-06-02
Lu

Redis is an open source, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.

官方網站
http://redis.io/

下載
http://redis.io/download
http://code.google.com/p/redis/downloads/list
直接下載
http://download.redis.io/releases/redis-3.0.1.tar.gz

安裝參考
http://redis.io/download

安裝

# yum -y groupinstall "Development Tools"

yum   -y   install   gcc
wget   http://download.redis.io/releases/redis-3.0.1.tar.gz
cd   redis-3.0.1

make distclean
cd deps
make hiredis jemalloc linenoise lua
cd ..
make

yum   -y   install   tcl
make test

啟動

[root@localhost ~]# redis-server  &

參數

[root@localhost ~]# redis-server --help
Usage: ./redis-server [/path/to/redis.conf] [options]
       ./redis-server - (read config from stdin)
       ./redis-server -v or --version
       ./redis-server -h or --help
       ./redis-server --test-memory <megabytes>

Examples:
       ./redis-server (run the server with default conf)
       ./redis-server /etc/redis/6379.conf
       ./redis-server --port 7777
       ./redis-server --port 7777 --slaveof 127.0.0.1 8888
       ./redis-server /etc/myredis.conf --loglevel verbose

Sentinel mode:
       ./redis-server /etc/sentinel.conf --sentinel
[root@localhost ~]#

設定檔案 /etc/retdis.conf

測試



[root@localhost ~]# redis-server  -v
Redis server v=3.0.1 sha=00000000:0 malloc=jemalloc-3.6.0 bits=64 build=7d85349cd20c11a3

[root@localhost ~]# ps aux | grep redis
root      20033  0.0  0.4 140836  7816 pts/1    Sl   14:49   0:00 redis-server *:6379
root      20046  0.0  0.0 112640   956 pts/1    R+   14:49   0:00 grep --color=auto redis

[root@localhost ~]#  netstat -ntplu | grep redis
tcp        0      0 0.0.0.0:6379            0.0.0.0:*               LISTEN      20033/redis-server
tcp6       0      0 :::6379                 :::*                    LISTEN      20033/redis-server

[root@localhost ~]#

[root@localhost ~]# systemctl stop firewalld

[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
   Active: inactive (dead) since Tue 2015-06-02 14:50:31 CST; 5s ago
  Process: 966 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)
 Main PID: 966 (code=exited, status=0/SUCCESS)

Jun 01 15:02:44 localhost.localdomain systemd[1]: Started firewalld - dynamic...
Jun 02 14:50:31 localhost.localdomain systemd[1]: Stopping firewalld - dynami...
Jun 02 14:50:31 localhost.localdomain systemd[1]: Stopped firewalld - dynamic...
Hint: Some lines were ellipsized, use -l to show in full.

[root@localhost ~]# redis-cli set foo bar
OK
[root@localhost ~]# redis-cli get foo
"bar"

[root@localhost ~]# yum -y install telnet
[root@localhost ~]# telnet 127.0.0.1 6379
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
set foo 3
+OK
get foo
$1
3
^]
telnet> quit
Connection closed.
[root@localhost ~]#


更多命令介紹參考文檔介紹。
http://code.google.com/p/redis/wiki/CommandReference

(完)

相關

[研究] Redis 2.8.19 資料庫 安裝(yum)(CentOS 7.1 x86_64)
http://shaurong.blogspot.com/2015/06/redis-2819-yumcentos-71-x8664.html

[研究] Redis 2.8.13 資料庫 安裝(yum)(CentOS 7.0 x86_64)
http://shaurong.blogspot.com/2014/09/redis-2813-yumcentos-70-x8664.html

[研究] Redis 2.8.14 資料庫 安裝(tar.gz)(CentOS 7.0 x86_64)
http://shaurong.blogspot.com/2014/09/redis-2814-targzcentos-70-x8664.html

[研究] Redis 2.8.4 資料庫 安裝(tar.gz)(CentOS 6.5 x64)
http://shaurong.blogspot.com/2014/01/redis-284-targzcentos-65-x64.html

[研究] Redis 2.4.10 資料庫 安裝(yum) (CentOS 6.5 x64)
http://shaurong.blogspot.tw/2014/01/redis-2410-yum-centos-65-x64.html

[研究] Redis 2.0.4 資料庫 安裝 (CentOS 5.5 x86)


[研究] MemSQL Community 4.0.28 安裝 (CentOS 7.1 x64)

[研究] MemSQL Community 4.0.28 安裝 (CentOS 7.1 x64)

2015-06-02

Installing and Configuring MemSQL Ops
http://docs.memsql.com/latest/ops/install/

下載網頁
http://www.memsql.com/download/


安裝說明
http://docs.memsql.com/latest/setup/setup_onprem/

硬體需求
http://docs.memsql.com/latest/setup/requirements/#hardware-requirements-onprem
CPU : Two socket x86-64 based server with 8 cores. At a minimum, Intel Core i3 or better processor. (MemSQL will run on machines with less than 8GB RAM, but this is not recommended.)
Memory : Recommended: 64-96GB. Minimum: 8GB
Hard Drive : SSD or SATA 7200RPM hard drive with 3X memory capacity

MemSQL 是由前Facebook工程師創辦的,號稱世界上最快的分佈式關係型數據庫,兼容MySQL但更快,原理是僅用內存並將SQL預編譯為C++。

社群版 (Community Edition) 安裝 
(要可以連上 Internet,install.sh 執行過程,會自動下載套件安裝)

cd   /usr/local
wget   http://download.memsql.com/memsql-ops-4.0.28/memsql-ops-4.0.28.tar.gz
tar   zxvf   memsql-ops-4.0.28.tar.gz
cd memsql-ops-4.0.28
./install.sh

[root@localhost memsql-ops-4.0.28]# ./install.sh
Installing MemSQL Ops in /var/lib/memsql-ops
Creating a memsql user
Setting up permissions
Creating an init script so that MemSQL Ops runs on startup
Creating a symlink to MemSQL Ops at /usr/bin/memsql-ops

Successfully installed MemSQL Ops!

--------------------------------------------------------------------------------

You can install MemSQL across multiple machines
using the MemSQL Ops Web UI.

For quick testing, you can also install a simple MemSQL
deployment on this host.

Do you want to install MemSQL on this host only? [y/N] y

2015-06-02 10:34:05: J62bf4b [INFO] Deploying MemSQL to 192.168.128.71:3306
2015-06-02 10:34:05: J359f08 [INFO] Deploying MemSQL to 192.168.128.71:3307
2015-06-02 10:34:51: J62bf4b [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:34:51: J62bf4b [INFO] Installing MemSQL
2015-06-02 10:34:51: J359f08 [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:34:51: J359f08 [INFO] Installing MemSQL

2015-06-02 10:35:22: J62bf4b [INFO] Finishing MemSQL Install
2015-06-02 10:35:22: J359f08 [INFO] Finishing MemSQL Install
Waiting for MemSQL to start...

MemSQL failed to start: Failed to start MemSQL: This machine does not have enough memory to run MemSQL. The minimum required size is 3700 MB, and this machine has 1826 MB
Cleaning up failed MemSQL installs

You can setup, manage and monitor MemSQL with the MemSQL Ops
web UI on port 9000. Make sure that port 9000 is open in your
firewall or security group.

[root@localhost memsql-ops-4.0.28]#

VM 目前設定 2GB RAM 無法安裝,根據訊息至少還要 3700-1826=1874 MB,所以 VM  PowerOff 後,設定為 4GB 再測試

[root@localhost memsql-ops-4.0.28]# ./install.sh
Installing MemSQL Ops in /var/lib/memsql-ops
Creating a memsql user
Setting up permissions
Creating an init script so that MemSQL Ops runs on startup
Creating a symlink to MemSQL Ops at /usr/bin/memsql-ops

Successfully installed MemSQL Ops!

--------------------------------------------------------------------------------

You can install MemSQL across multiple machines
using the MemSQL Ops Web UI.

For quick testing, you can also install a simple MemSQL
deployment on this host.

Do you want to install MemSQL on this host only? [y/N] y
2015-06-02 10:44:16: J8114ec [INFO] Deploying MemSQL to 192.168.128.71:3306
2015-06-02 10:44:16: J6884a3 [INFO] Deploying MemSQL to 192.168.128.71:3307
2015-06-02 10:45:24: J8114ec [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:45:24: J8114ec [INFO] Installing MemSQL
2015-06-02 10:45:24: J6884a3 [INFO] Downloading MemSQL: 100.00%
2015-06-02 10:45:24: J6884a3 [INFO] Installing MemSQL
2015-06-02 10:45:43: J6884a3 [INFO] Finishing MemSQL Install
2015-06-02 10:45:45: J8114ec [INFO] Finishing MemSQL Install
Waiting for MemSQL to start...
MemSQL failed to start: Failed to start MemSQL: This machine does not have enough CPU cores to run MemSQL. The minimum required number is 4, and this machine has 1 cores
Cleaning up failed MemSQL installs

You can setup, manage and monitor MemSQL with the MemSQL Ops
web UI on port 9000. Make sure that port 9000 is open in your
firewall or security group.

[root@localhost memsql-ops-4.0.28]#

要 4 core CPU,PowerOff 修改 VM 設定為 4 processors 和 1 core/processor 後再 Power On測試

[root@localhost memsql-ops]# memsql-ops status
MemSQL Ops is running with pid 2888 on port 9000.

[root@localhost memsql-ops-4.0.28]# ps aux | grep mem
memsql     2888  0.8  1.4 3660224 54296 ?       Sl   10:49   0:01 /var/lib/memsql-ops/lib/memsql-ops start
root       4130  0.0  0.0 112644   960 pts/0    S+   10:52   0:00 grep --color=auto mem

[root@localhost memsql-ops-4.0.28]# netstat -ntulp | grep 9000
tcp        0      0 0.0.0.0:9000            0.0.0.0:*               LISTEN      2888/memsql-ops

[root@localhost memsql-ops-4.0.28]# /var/lib/memsql-ops/lib/memsql-ops stop
Stopping MemSQL Ops
Waiting up to 60 seconds for a clean exit.
Done.

[root@localhost memsql-ops-4.0.28]# /var/lib/memsql-ops/lib/memsql-ops start
Starting MemSQL Ops...
MemSQL Ops is running with pid 5081
The web UI is running on port 9000
[root@localhost memsql-ops-4.0.28]#



(完)


2015年6月1日 星期一

[研究] Memcached 1.4.15 安裝 (CentOS 7.1 x64)

[研究] Memcached 1.4.15 安裝 (CentOS 7.1 x64)

2015-06-01


安裝
yum   -y   install   memcached

設定 /etc/sysconfig/memcached, 設定記憶體使用量 (預設 64)
CACHESIZE="1024"

設定開機啟用 memcached 服務

[root@localhost ~]# systemctl   enable   memcached.service
ln -s '/usr/lib/systemd/system/memcached.service' '/etc/systemd/system/multi-user.target.wants/memcached.service'
[root@localhost ~]#

啟用 memcached 服務
systemctl  start   memcached.service

測試 memcached 是否成功啟用

[root@localhost ~]# netstat -ntulp | grep 11211
tcp        0      0 0.0.0.0:11211           0.0.0.0:*               LISTEN      15409/memcached
tcp6       0      0 :::11211                :::*                    LISTEN      15409/memcached
udp        0      0 0.0.0.0:11211           0.0.0.0:*                           15409/memcached
udp6       0      0 :::11211                :::*                                15409/memcached
[root@localhost ~]#


(完)

[研究] Redis 2.8.19 資料庫 安裝(yum)(CentOS 7.1 x86_64)

[研究] Redis 2.8.19 資料庫 安裝(yum)(CentOS 7.1 x86_64)

2015-06-01
Lu

Redis is an open source, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets.

官方網站
http://redis.io/

下載
http://redis.io/download
http://code.google.com/p/redis/downloads/list
直接下載
http://download.redis.io/releases/redis-3.0.1.tar.gz

安裝參考
http://redis.io/download

安裝

# yum -y groupinstall "Development Tools"
rpm   -ivh   http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm
yum   -y   install   redis
systemctl   enable   redis.service
systemctl   start   redis.service
systemctl   --all   |   grep redis

參數

[root@localhost ~]# redis-server --help
Usage: ./redis-server [/path/to/redis.conf] [options]
       ./redis-server - (read config from stdin)
       ./redis-server -v or --version
       ./redis-server -h or --help
       ./redis-server --test-memory <megabytes>

Examples:
       ./redis-server (run the server with default conf)
       ./redis-server /etc/redis/6379.conf
       ./redis-server --port 7777
       ./redis-server --port 7777 --slaveof 127.0.0.1 8888
       ./redis-server /etc/myredis.conf --loglevel verbose

Sentinel mode:
       ./redis-server /etc/sentinel.conf --sentinel
[root@localhost ~]#

設定檔案 /etc/retdis.conf

測試

[root@localhost ~]# redis-server  -v
Redis server v=2.8.19 sha=00000000:0 malloc=jemalloc-3.6.0 bits=64 build=c0359e7aa3798aa2
[root@localhost ~]#


[root@localhost ~]# redis-server  -v
Redis server v=2.8.19 sha=00000000:0 malloc=jemalloc-3.6.0 bits=64 build=c0359e7aa3798aa2
[root@localhost ~]# ps aux | grep redis
redis     15597  0.0  0.3 142688  5720 ?        Ssl  16:53   0:00 /usr/bin/redi -server 127.0.0.1:6379
root      15613  0.0  0.0 112640   956 pts/1    S+   16:53   0:00 grep --color=auto redis
[root@localhost ~]#


[root@localhost ~]# netstat -ntplu | grep redis
tcp        0      0 127.0.0.1:6379          0.0.0.0:*               LISTEN      15597/redis-server
[root@localhost ~]#


[root@localhost ~]# systemctl stop firewalld

[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
   Active: inactive (dead) since Mon 2015-06-01 16:54:23 CST; 3s ago
 Main PID: 966 (code=exited, status=0/SUCCESS)

Jun 01 15:02:44 localhost.localdomain systemd[1]: Started firewalld - dynamic...
Jun 01 16:54:22 localhost.localdomain systemd[1]: Stopping firewalld - dynami...
Jun 01 16:54:23 localhost.localdomain systemd[1]: Stopped firewalld - dynamic...
Hint: Some lines were ellipsized, use -l to show in full.
[root@localhost ~]#




[root@localhost ~]# redis-cli set foo bar
OK
[root@localhost ~]# redis-cli get foo
"bar"

[root@localhost ~]# yum -y install telnet
[root@localhost ~]# telnet 127.0.0.1 6379
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
set foo 3
+OK
get foo
$1
3
^]
telnet> quit
Connection closed.
[root@localhost ~]#


更多命令介紹參考文檔介紹。
http://code.google.com/p/redis/wiki/CommandReference

(完)

相關

[研究] Redis 2.8.19 資料庫 安裝(yum)(CentOS 7.1 x86_64)
http://shaurong.blogspot.com/2015/06/redis-2819-yumcentos-71-x8664.html

[研究] Redis 2.8.13 資料庫 安裝(yum)(CentOS 7.0 x86_64)
http://shaurong.blogspot.com/2014/09/redis-2813-yumcentos-70-x8664.html

[研究] Redis 2.8.14 資料庫 安裝(tar.gz)(CentOS 7.0 x86_64)
http://shaurong.blogspot.com/2014/09/redis-2814-targzcentos-70-x8664.html

[研究] Redis 2.8.4 資料庫 安裝(tar.gz)(CentOS 6.5 x64)
http://shaurong.blogspot.com/2014/01/redis-284-targzcentos-65-x64.html

[研究] Redis 2.4.10 資料庫 安裝(yum) (CentOS 6.5 x64)
http://shaurong.blogspot.tw/2014/01/redis-2410-yum-centos-65-x64.html

[研究] Redis 2.0.4 資料庫 安裝 (CentOS 5.5 x86)
http://forum.icst.org.tw/phpbb/viewtopic.php?t=19575