近来突然想鼓捣下linux下的python，看下Python数据库方面的东西，想着在centos下测试下。然而安装的过程有很多坑。下面对整个流程进行下记录1、python基本库的安装 在安装python的过程中，发现其中很多的依赖库是没有包含在内的。根据我的需要，我安装了sqlite和zlib这两个依赖库。具体过程说明如下：(1)sqlite1>下载文件sqlite-autoconf-3160100.tar.gz： http://pan.baidu.com/s/1slOw8BN2>解压3>配置、编译、安装./confi...
启动mysqld服务失败，报错如下：[root@LCM01GCM01 ~]# service mysqld start
Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe"for details.[FAILED]既然有了提示，先看下有什么帮助没有[root@LCM01GCM01 ~]# systemctl status mysqld.serviceLoaded: loaded (/etc/rc.d/init.d/mysqld)Acti...
yum -y install mysql-devwget http://downloads.sourceforge.net/project/mysql-python/mysql-python-test/1.2.4b4/MySQL-python-1.2.4b4.tar.gz?r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fmysql-python%2F&ts=1364895531&use_mirror=nchctar zxvf MySQL-python-1.2.4b4.tar.gz
cd MySQL-python-1.2.4b4
python setup.py build
python setup.py installurllib2.URLError: <urlopen error [Errno 110] Connection timed
out>...
重新安装mysql时，运行systemctl status mysqld.service报错。[root@test-dcruxue ~]# systemctl start mysqld.serviceJob for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.查看mysql服务状态[root@test-dcruxue ~]# systemctl status mysqld.service● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/syst...
1.启动命令systemctl start mysqld.service 或者 /etc/init.d/mysqld start 结果同样的错误 2.错误是: Job for mysqld.service failed. See ‘systemctl status mysqld.service‘ and ‘journalctl -xn‘ for details. 3.按照提示输入命令 systemctl status mysqld.service 或者 journalctl -xn 命令后提示: mysqld.service - SYSV: MySQL database server. Loaded: loaded (/etc/rc.d/init.d/...
python2.7代码如下:
wget http://www.python.org/ftp/python/2.7.6/Python-2.7.6.tar.xz
yum install xz-libs
xz -d Python-2.7.6.tar.xz
ls
tar -xvf Python-2.7.6.tar
cd Python-2.7.6
yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel readline
LDFLAGS="-Wl,-rpath /usr/local/lib"vim /etc/ld.so.conf./configure --prefix=/usr/local --enable-unicode=ucs4 --enable-shared LDFLAGS="-Wl,-rpa...
loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
检查是否安装libaiorpm -qa|grep libaio 若不存在，安装这个包即可yum install libaio-devel.x86_64
阿里云Centos7 安装mysql5.7 报错：./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory标签：阿里 dev color erro error info img ...
my.cnf下添加 [mysqldump] user password）
添加脚本 vi /data/app/mysqldump/mysqldump_bak.sh
#!/bin/sh
# This is a ShellScript For Auto DB Backup and Delete old Backup
# back path
backupdir=/data/databackup
time=` date +%Y%m%d%H `
#MYSQL_PWD=$(admindev123$%^) && mysqldump -u root -p$(admindev123$%^) cmccepidemic | gzip > $backupdir/cmccepidemic$time.sql.gz
mysqldump cmccepidemic | gzip > $b...
查看python的版本#python -V Python 2.6.6
1.下载Python-2.7.3#wget http://python.org/ftp/python/2.7.3/Python-2.7.3.tar.bz2
2.解压#tar -jxvf Python-2.7.3.tar.bz2
3.更改工作目录#cd Python-2.7.3
4.安装#./configure#make all #make install#make clean#make distclean
5.查看版本信息#/usr/local/bin/python2.7 -V
6.建立软连接，使系统默认的 python指向 python2.7#mv /usr/bin/python /usr/bin/python2.6.6#...
备份是怎么样一个定位呢
教育项目 使用mysql 出现了数据页的损坏20G数据文件大小16万，做的数据恢复
做备份需要增加1. 备份硬件成本2. 备份的管理成本
10000G = 10TDisk -> Disk-> 备份网络里面对于超大容量文件传送到Ceph 分布式文件系统
备份方案最后救命稻草同样也包含了开发测试环境，每天做一个全备 mysqldump
恢复时间没有备份会出现什么问题1. 做备份2. 学会看日志
如果大家在线上做SQL更新，先做备份
备份可以分为几...
当输入命令
~]# systemctl start mysql.service
要启动MySQL数据库是却是这样的提示
Failed to start mysqld.service: Unit not found
解决方法如下:首先需要安装mariadb-server~]# mariadb-server启动服务~]# systemctl start mariadb.service添加到开机启动~]# systemctl enable mariadb.service
至此完成!
可以测试一下~]# mysql -u root -p
CentOS7.2安装mariadb-server,解决Failed to start mysqld.service: Unit not found...
for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.[FAILED]既然有了提示，先看下有什么帮助没有[root@LCM01GCM01 ~]# systemctl status mysqld.serviceLoaded: loaded (/etc/rc.d/init.d/mysqld)Active: failed (Result: exit-code) since Wed 2016-01-20 18:26:57 CST; 40s agoDocs: man:systemd-sysv-generator(8)Proce...
说明: 前面的数据库文章中提到数据库初始化主主所以这里就直接接着上文写了
写一个mysql.service
vim mysql.service[Unit]Description=MySQL Server
Documentation=man:mysqld(5.7)After=network.target
After=syslog.target
Before=shutdown.target # 关机前操作[Install]
WantedBy=multi-user.target
Alias=mysql.service[Service]
User=mysql
Group=mysqlType=forking
PIDFile=/var/lib/mysql/Devops-mysql-master.pid#Disable ...
安装mysql的server端，
然后再输入/etc/init.d/mysqld start 启动成功（或许你的启用命令是这样的service mysqld restart）centos启动mysql报错 mysqld：unrecognized service标签：etc strong 启用 zed str mysql 失败 sql 成功 本文系统来源：https://www.cnblogs.com/Alwaysbecoding/p/11294257.html
：需要更新你的yum源，保证yum源最新。
1.安装:
yum install -y mariadb-server
2.启动maria DB服务:
systemctl start mariadb.service
(说明：CentOS 7.x开始，CentOS开始使用systemd服务来代替daemon，原来管理系统启动和管理系统服务的相关命令全部由systemctl命令来代替。)
3.将mariadb服务添加至开机自启动：
systemctl enable mariadb.serviceCentOS7安装mysql后无法启动服务，提示Failed to start mysqld.service: ...
安装mysql的server端，