源码包安装(Python mysql redis)

一  源码包安装

(1)python3.6源码包安装
    ./configure       ------> 定制功能
     make
     make install
     
mysql 源码包
    cmake
    make 
    make install
  
(2) redis 源码包安装 
    make

修改环境变量
vim /etc/profile

添加以下一行:
export PATH=/opt/redis-3.2.10/src:$PATH

生效配置
source /etc/profile


(3) 让python链接redis

unzip redis-py-master.zip 
cd redis-py-master
python3 setup.py install


对redis的单实例进行连接操作
python3
>>>import redis
>>>r = redis.StrictRedis(host='localhost', port=6379)
>>>r.set('name', 'oldguo')
True
>>>r.get('name')
'oldguo'

二  经典互联网架构项目

三  二进制包mysql(mysql5.7.20)

3.1 解压及制作软连接
tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
ln -s mysql-5.7.20-linux-glibc2.12-x86_64 mysql

3.2 编辑环境变量
在根目录'/'下的etc文件
vim  /etc/profile
在文件最后一行,添加以下一行:
export PATH=/opt/mysql/bin:$PATH

生效配置:
source /etc/profile

3.3 卸载centos自带mariadb
yum remove mariadb-libs

3.4 生成配置文件(/etc/my.cnf)
vim /etc/my.cnf
---------------------------------
[mysqld]
basedir=/opt/mysql
datadir=/opt/mysql/data
socket=/tmp/mysql.sock
user=mysql
log_error=/var/log/mysql.log
log_bin=/opt/mysql/data/mysql-bin
server_id=100
[mysql]
socket=/tmp/mysql.sock
----------------------------------
3.5 创建用户和数据目录,并授权

1.创建一个用户
useradd mysql 
mkdir  /opt/mysql/data 
2.授权
chown -R mysql.mysql /opt/mysql


3.6 初始化数据
[root@python3 ~]# mysqld --initialize-insecure --basedir=/opt/mysql --datadir=/opt/mysql/data --user=mysql
2019-01-04T03:58:03.128958Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-01-04T03:58:03.142436Z 0 [ERROR] Could not open file '/var/log/mysql.log' for error logging: Permission denied
2019-01-04T03:58:03.142492Z 0 [ERROR] Aborting

报错解决:
touch /var/log/mysql.log 
给权限:
chown -R mysql.mysql /var/log/mysql.log

再次初始化:
mysqld --initialize-insecure --basedir=/opt/mysql --datadir=/opt/mysql/data --user=mysql


3.7 启动mysql,切换到启动文件所在的文件夹
cd /opt/mysql/support-files
执行下面命令启动mysql
./mysql.server start

为了启动方便将启动文件拷贝到/etc下的配置文件
cp mysql.server /etc/init.d/mysqld
启动mysql用start,restart都可以
/etc/init.d/mysqld restart


扩展:使用systemctl 管理mysql,写入下面文件就可以用systemctl来启动mysql
vim /etc/systemd/system/mysqld.service
-----------------------------------------------------------------
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/opt/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
-------------------------------------------------------------------------------
启动mysql
systemctl restart mysqld
关闭mysql
systemctl stop mysql
查看mysql的端口
netstat -tulnp |grep 3306
查看mysql软件是否启动
netstat -lnp | grep mysql

如果修改配置文件需要:
systemctl daemon-reload

3.8 测试python3链接mysql

创建mysql链接用户
授权用户
grant all on *.* to root@'10.0.0.%' identified by '123';
create database bbs charset utf8;

python代码测试:
更新pip
pip3 install --upgrade pip
安装python连接包
pip3 install pymysql

测试脚本
vim testmysql.py
----------------------------------------------------------
#!/usr/bin/python3
import pymysql
db = pymysql.connect("10.0.0.100","root","123","bbs" )
cursor.execute("SELECT VERSION()")
data = cursor.fetchone()
print ("Database version : %s " % data)
db.close()
----------------------------------------------------------
python3  testmysql.py