2017 年 10月随笔档案 - geek_ace

收录文章

摘要：金融级MySQL高可用方案选型 ProxySQL高可用方案 DATABASE() fail Consider setting transaction_persistent=1 by default MySQL Query Rules ProxySQL Rules: Do I Have Too Man 阅读全文

posted @ 2017-10-31 18:35 geek_ace 阅读(85) 评论(0) 推荐(0) 编辑

mysql安装及问题解决

该文被密码保护。

posted @ 2017-10-31 16:52 geek_ace 阅读(7) 评论(0) 推荐(0) 编辑

mgr

摘要：一、安装部署mysql5.7 1.软件下载 wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz 2.安装 cd /usr/local/src tar zxvf my 阅读全文

posted @ 2017-10-26 18:52 geek_ace 阅读(161) 评论(0) 推荐(0) 编辑

网络yum源配置

摘要：1.下载yum源 wget http://mirrors.163.com/.help/CentOS6-Base-163.repomv CentOS-Base.repo CentOS-Base.repo.oriyum clean allyum makecacheyum repolistyum -y i 阅读全文

posted @ 2017-10-26 12:05 geek_ace 阅读(310) 评论(0) 推荐(0) 编辑

old password

摘要：GRANT SELECT, INSERT, UPDATE, DELETE, DROP ON `test`.`test` TO 'writeuser'@'%' identified by '111111'ERROR 1827 (HY000): The password hash doesn't hav 阅读全文

posted @ 2017-10-25 18:19 geek_ace 阅读(878) 评论(0) 推荐(0) 编辑

linux环境初始化

摘要：一、网络 1.ip配置 vi /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=eth0TYPE=EthernetONBOOT=yesNM_CONTROLLED=yesBOOTPROTO=dhcp service network restart ip 阅读全文

posted @ 2017-10-25 17:11 geek_ace 阅读(227) 评论(0) 推荐(0) 编辑

mongo备份恢复

摘要：1.mongoexport 与mongoimport export mongoexport --host "localhost:27017" --username="user" --password="xxxx" --authenticationDatabase=testdb --db=testdb 阅读全文

posted @ 2017-10-19 15:59 geek_ace 阅读(332) 评论(0) 推荐(0) 编辑

repair table

摘要：错误 HA_ConfigFieldActivity' is marked as crashed and should be repaired 执行repair REPAIR TABLE HA_ConfigFieldActivity Table Op Msg_type Msg_text fission 阅读全文

posted @ 2017-10-09 15:22 geek_ace 阅读(164) 评论(0) 推荐(0) 编辑

10 2017 档案

公告