如何远程清理48组MySQL DB Server上面的过期实效的备份! 刚开始想到一个个从control控制机器ssh进去,rm 掉,然后exit,再通过control机器ssh进去,再rm再exit,这样的话岂不是要操作48次ssh以及exit,48台还能接受,如果是480台,4800台呢,any way ?
OK,我想到了,写一个shell脚本,在control机器上面远程执行ssh命令,不需要ssh进具体的单台db了,如下clean.sh
ssh aaaaaaaaa048xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa047xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa046xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa045xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa044xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa043xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa042xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa041xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa040xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa039xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa038xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa037xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa036xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa035xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa034xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa033xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa032xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa031xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa030xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa029xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa028xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa027xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa026xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa025xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa024xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa023xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa022xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa021xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa020xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa019xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa018xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa017xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa016xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa015xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa014xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa013xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa012xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa011xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa010xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa009xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa008xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa007xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa006xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa005xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa004xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa003xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa002xxxxxx "sudo -u mysql du -sh /mysqlback/*";
ssh aaaaaaaaa001xxxxxx "sudo -u mysql du -sh /mysqlback/*";
PS:
1 ssh aaaaaaaaa001xxxxxx "sudo -u mysql du -sh /mysqlback/*";这个指示最后check检查备份有没有被删除的脚本你可以将du -sh /mysqlback/*";换成rm -rf就变成了自己要清理文件的功能了。
2 我这里ssh是不带密码的,如果你的ssh还要带输入密码验证的话,请参考:ssh pass -p 'password' sshroot@xx.com
"command"命令
run 这个clean脚本, 我这里ssh 进aaaaaaaaa001xxxxxx 是不需要密码的,而且因为进去db server还需要切换到mysql帐号,否则不能rm操作mysql用户组的文件。远程命令里面用了sudo -u mysql前缀。
分享到:
相关推荐
10204_vista_w2k8_x64_production_db.zip
oracle 10g r2(10204_vista_w2k8_x64_production_db.zip )是比较老的版本,它发布后,才发布windows server 2008 r2的,这个数据库版本是专门为这个操作系统发布的。所以这个操作系统必须安装这个版本,还需安装...
oracle_10203_vista_w2k8_x86_production_db
The MySQL® software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production ...
mysql4.1.10的JDBC驱动 把它拷贝到你的web应用的WEB-INF\lib下(当然也可以设置CLASSPATH) <br>接着修改程序代码: 将你的: Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 改为: ...
oracle 10g r2(10204_vista_w2k8_x64_production_db.zip )。以及这个版本的2个补丁文件: p8202632_10205_MSWIN-x86-64.zip, p8350262_10205_Generic.zip
用于MATLAB Production Server:trade_mark:的MATLAB客户端使您可以通过MATLAB附加组件从MATLAB桌面访问MATLAB:registered:Production Server托管的算法。 MATLAB Production Server为您的算法提供集中,安全和可扩展...
mysql-connector-java-3.0.12-production.zip
MySQL Connector/J 5.1.26, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.26 is suitable for use with ...
Create and run a real-time, highly-available, and high-redundancy version of the world's most popular open-source database, MySQL. You will understand the advantages and disadvantages of the MySQL NDB...
Even though research in flow shop production scheduling has been carried out for many dec- ades, there is still a gap between research and application – especially in manufacturing para- digms such ...
[root@dbserver ~]# groupadd oinstall //安装组 [root@dbserver ~]# groupadd dba //管理组 [root@dbserver ~]# useradd -g oinstall -G dba oracle [root@dbserver ~]# passwd oracle [root@dbserver ~]# ...
它可以自动执行Azure基础结构的大部分创建和配置,从而在多个Azure虚拟机上运行已安装的MATLAB Production Server版本。 链接到此提交的参考体系结构包含分步说明,体系结构图以及在Azure环境中执行的模板和脚本。...
MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-de-ployed software. Oracle is a registered trademark of Oracle Corporation and/or its ...
远程服务器运行matlab代码Amazon Web Services上的MATLAB Production Server 要求 开始之前,您需要满足以下条件: MATLAB:registered:Production Server:trade_mark:许可证。 有关更多信息,请参见。 为了在云中...
Microsoft Exchange Server 2013 doesn’t just add dozens of new features: It integrates multiple technologies into a common, unified communications system that can add value in many new ways....
release it! design and deploy production ready software
In Production-Ready Microservices, author Susan Fowler looks at lessons learned from driving high production-readiness standards across over a thousand microservices. She discusses standards that ...