[研究] 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 變成繁體中文介面了。
(完)
2015年6月8日 星期一
[研究] 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-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 架設
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]# 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]#
[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
[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 "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
# 啟動瀏覽器,連上網站
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
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 ~]#
(可以依自己喜好修改)
[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'; "
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
(待續)
相關
[研究] 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 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 "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
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 ~]#
(可以依自己喜好修改)
[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'; "
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
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)
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 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.
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
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 ~]#
(完)
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 ~]#
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 ~]# 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
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