Note – Adamhuan's Data Center – 【逻辑驱动数据】

MySQL参数：max_connect_errors

首先看看MySQL官方文档上对于该参数的说明：
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

1 2	首先看看MySQL官方文档上对于该参数的说明： https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html

该参数累积的是：主机请求服务器失败次数；
该参数控制的是：MySQL服务器是否阻止客户端主机进一步的连接
因为，服务器会假设出了问题（例如，有人试图闯入），并阻止客户端主机进一步连接请求。

这里有几个情况：

如[……]
Read more

Posted on: 2021年4月22日 2021年4月23日
Author: Adamhuan
Categories: MySQL
Tags: -, -h, -p, ，, :, ", /, 1.3, 10, 1024, 11, 12, 16, 1653, 18, 18.3, 2, 2.2, 2.4, 200, 2018, 21, 22, 255, 26, 3, 3.7, 30, 3306, 4, 46, 5, 5.3, 5.5, 5.7, 50, 6, 64, 7, 7.3, 7.5, 8, 80, 9, AB, AD, add, admin, ANSI, AS, b, Block, BLOCKED, CA, Cache, cal, cat, dd, desc, dm, DNS, ED, ERR, error, ERROR 1129 (HY000): Host 'xxxxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts', ES, exit, flush hosts, for, form, format, from, full, GI, HA, help, host, host_cache, host_cache_size, http, https, IE, IO, IP, IT, list, load, localhost, LOCK, log, man, MariaDB, max_connect_errors, monitor, MySQL, mysqladmin, Name or service not known, net, nic, Note, NULL, OP, Oracle, OS, OST, parameter, password, performance_schema, pre, prototype, ps, put, racle, rap, rm, root, s, select, Server, service, show, size, skip_name_resolve, solve, SQL, src, SSL, ST, stat, table, telnet, thin, timestamp, tr, UNKNOWN, upload, use, user, variable, variables, version, word, xampp, You, 中断, 主, 主机, 从, 使用, 信, 信息, 判断, 参数, 变量, 口令, 命令, 命令行, 图, 境, 处理, 失败, 官方, 官方文档, 密码, 库, 当前, 得到, 情, 想, 想要, 成功, 我, 截图, 执行, 报错, 控制, 数据, 数据库, 文档, 新, 方案, 日志, 更新, 服务, 服务器, 权限, 查, 查看, 查询, 模拟, 步骤, 测试, 清, 清空, 演示, 状态, 环境, 用户, 用户名, 监控, 相关, 空, 系统, 累, 终, 表, 解决, 记录, 设置, 说, 连接, 重设, 锁, 错, 错误, 问题, 阻止, 验证
Leave a comment: MySQL参数：max_connect_errors

Linux drbd-utils：编译RPM包的时候报错：make[1]: po4a-translate: Command not found

如题所示，在Linux环境上通过编译安装的方式安装drbd-utils的时候遇到了报错。
具体情况如下所示：

可以看到，报错原因是因为编译drbd-utils的rpm包的时候，需要有命令【po4a-translate】的支持，但是系统上并没有这个命令，于是报错了。

通过YUM的【wha[……]

Posted on: 2020年8月12日 2020年8月12日
Author: Adamhuan
Categories: RHEL, 善用佳软
Tags: -, -p, ，, :, ", /, 1.3, 1.6, 10, 11, 12, 2, 21, 3, 3.6, 30, 4, 5, 6, 64, 7, 7.1, 8, 9, b, break, cal, change, check, date, db, director, directory, disable, download, drbd, drbd-utils, epel, error, File, for, from, grep, gz, http, if, Instal, Install, Linux, list, load, log, main, maintain, make, make[1]: po4a-translate: Command not found, man, Match, MySQL, net, nload, Note, package, plug, po4a-translate, pre, proc, put, rap, register, release, repo, rm, root, RPM, s, size, solve, source, subscription-manager, tr, try, use, user, valid, Verify, version, war, whatprovides, x86, xml, You, YUM, 命令, 境, 安装, 情, 执行, 报错, 环境, 系统, 编译, 编译安装, 软件, 软件包, 错, 错误, 问题
Leave a comment: Linux drbd-utils：编译RPM包的时候报错：make[1]: po4a-translate: Command not found

MySQL MGR：3 Nodes

开始本文的前提：

【3】台，RHEL 7.6的Linux服务器
每台服务器，安装好MySQL【5.7.26】；MySQL数据库的安装步骤，在本文中不重复赘述

本文将呈现【3】节点的【MySQL MGR】的技术细节；
涉及架构包括：

单主模式
多主模式

环境介绍：

操作系统[……]

Posted on: 2019年8月15日 2019年8月15日
Author: Adamhuan
Categories: Group Replication
Tags: _id, -, --initialize, --initialize-insecure, -h, -p, ，, :, ", /, /etc/hosts, /etc/my.cnf, $, 10, 11, 12, 127.0.0.1, 151, 16, 18, 2, 2.0, 2.2, 2.4, 200, 21, 22, 255, 26, 3, 3.2, 30, 3306, 4, 404, 46, 5, 5.3, 5.7, 50, 6, 64, 64bit, 7, 7.1, 7.2, 7.6, 8, 80, 9, 96, AB, AD, add, AI, ant, applied, ARCH, AS, auto, automatic, b, BE, bind, binlog, break, bytes, CA, cat, CE, CG, change, character, check, client, CM, compress, config, cp, CPU, create, create database, create table, create user, created, CSV, daemon, Data, database, datadir, date, db, dd, default, desc, detail, diff, director, directory, disable, Doc, ED, EM, enable, error, exit, extract, fence, ffi, File, find, firewall, firewalld, flush privileges;, for, format, from, FTP, full, GC, GI, go, grep, group, Group Replication, group_name, group_replication, group_replication.so, GTID, HA, hash, help, HIVE, host, hostname, http, IE, if, imp, index, init, innodb, IO, IP, IT, kill, Library, Linux, list, load, localhost, LOCK, log, log-bin, logfile, loop, main, man, Manual, master, master_log_file, master_log_pos, memory, mgr, module, monitor, MR, my.cnf, MySQL, mysqld, mysqld_safe, Note, NULL, OP, options, Oracle, OS, OST, partition, password, percona, pid, ping, plug, Plugin, pre, privileges, proc, process, prompt, ps, Puppet, purge, put, racle, rap, rar, RAW, recover, redo, register, remove, REPLICAT, Replication, repo, report, repository, reset, RHEL, RHEL 7, rm, root, s, SC, SCHEMA, secure, sed, segment, select, SELINUX, seq, Server, server-id, service, show, show grants for, sinple primary, size, slave, sock, socket, solve, SQL, SQL Server, SSL, ST, stat, Status, switch, Syntax, table, tablespace, TAR, theme, thin, timestamp, tr, ui, UID, undo, use, user, user=mysql, UUID, variables, version, VI, war, warning, while, word, write, You, zlib, 之间, 事务, 信, 信息, 修改, 停, 停止, 内存, 切换, 创建, 创建数据库, 初始化, 加载, 包含, 单主, 参数, 变化, 启动, 命令, 命令行, 哈希, 境, 复制, 多主, 字符, 字符集, 存储, 安全, 安装, 实例, 工具, 开机, 开机启动, 引导, 当前, 情, 成功, 执行, 提示符, 插件, 操作系统, 改, 数据, 数据库, 文件, 日志, 日志文件, 服务, 服务器, 架构, 查, 查看, 查询, 格式, 步骤, 测试, 清, 版本, 状态, 环境, 用户, 目录, 禁用, 端口, 算法, 系统, 组, 细节, 终, 网络, 自动, 自定义, 表, 角色, 设置, 账号, 软件, 运行, 进程, 配置, 配置文件, 重复, 错, 错误, 防火墙
Leave a comment: MySQL MGR：3 Nodes

Python：MySQL自动安装

直接看代码吧：

终了，…

[……]

Posted on: 2019年7月20日 2019年7月22日
Author: Adamhuan
Categories: MySQL
Tags: -, -h, -p, ，, :, ", /, 2, 3, 4, 5, 5.7, 6, 64, 7, 7.2, 8, 9, admin, b, cat, change, check, Coding, command, config, create, createrepo, Data, default, df, df -h, director, directory, dm, else, exit, File, gbk, gpg, grep, group, if, imp, import os, iso, Linux, load, log, main, man, MySQL, mysqladmin, mysqld, Note, OS, password, pg, popen, pre, print, Python, rap, RAW, repo, RHEL, RHEL 7, root, s, sed, Server, service, SQL, theme, tr, UTF-8, war, word, write, x86, YUM, yum.conf, YUM源, zip, 不存在, 中文, 乱, 乱码, 介质, 代码, 会话, 传参, 修改, 函数, 创建, 判断, 包含, 参数, 变量, 口令, 可用, 启动, 命令, 命令执行, 命令行, 回收, 处理, 字符, 字符集, 安装, 安装介质, 密码, 开发, 忘记, 情, 成功, 我, 执行, 挂载, 换行, 操作系统, 改, 数据, 文件, 文字, 是否存在, 显示, 服务, 查, 检查, 模块, 比较, 源, 目录, 相关, 禁用, 程序, 空, 空行, 系统, 组, 终, 缓存, 编程, 脚本, 自动, 自动安装, 表, 解压, 资源, 路, 路径, 转义, 转换, 追加, 配置, 配置文件, 错, 错误, 问题, 预配置, 默认
Leave a comment: Python：MySQL自动安装

Python Code：回文（Palindrome）的检查

本文的代码是关于如何用Python实现对字符串的回文检查的。
代码：

#encoding=utf-8
__author__ = 'adamhuan'

print "------------------------------"
print "Program：isPalindrome"
print "------------------------------"

target_string = raw_input("Type in Target String which you want to Check：\n")
print "Your Target String is：",target_string

print "------------------------------"

target_length = target_string.__len__()
print "The Length of Target is：",target_length

check_length = target_length%2

string_desc = ""
string_asc = ""
string_asc_temp = ""

if (target_length < 2):
    print "Target String is too Short，Try Again."
else:
    cut_length = target_length/2
    if (check_length == 0):
        print "The Length of Target is: Even."
        string_desc = target_string[:cut_length]
        string_asc = target_string[::-1]
        string_asc_temp = string_asc[:cut_length]

    else:
        print "The Length of Target is: Odd."

        string_desc = target_string[:cut_length]
        string_asc = target_string[::-1]
        string_asc_temp = string_asc[:cut_length]

print "------------------------------"

isPalidrome_number = cmp(string_desc,string_asc_temp)

if (isPalidrome_number == 0):
    print "Target is Palindrome."
else:
    print "Target is Not Palindrome."

print "------------------------------"
print "Done."

#encoding=utf-8

__author__ = 'adamhuan'

print "------------------------------"

print "Program：isPalindrome"

print "------------------------------"

target_string = raw_input("Type in Target String which you want to Check：\n")

print "Your Target String is：",target_string

print "------------------------------"

target_length = target_string.__len__()

print "The Length of Target is：",target_length

check_length = target_length%2

string_desc = ""

string_asc = ""

string_asc_temp = ""

if (target_length < 2):

print "Target String is too Short，Try Again."

else:

cut_length = target_length/2

if (check_length == 0):

print "The Length of Target is: Even."

string_desc = target_string[:cut_length]

string_asc = target_string[::-1]

string_asc_temp = string_asc[:cut_length]

else:

print "The Length of Target is: Odd."

string_desc = target_string[:cut_length]

string_asc = target_string[::-1]

string_asc_temp = string_asc[:cut_length]

print "------------------------------"

isPalidrome_number = cmp(string_desc,string_asc_temp)

if (isPalidrome_number == 0):

print "Target is Palindrome."

else:

print "Target is Not Palindrome."

print "------------------------------"

print "Done."

运行效果如下：

Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py
------------------------------
Program：isPalindrome
------------------------------
Type in Target String which you want to Check：
allahhalla
Your Target String is： allahhalla
------------------------------
The Length of Target is： 10
The Length of Target is: Even.
------------------------------
Target is Palindrome.
------------------------------
Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py
------------------------------
Program：isPalindrome
------------------------------
Type in Target String which you want to Check：
angelababyIybabalegna
Your Target String is： angelababyIybabalegna
------------------------------
The Length of Target is： 21
The Length of Target is: Odd.
------------------------------
Target is Palindrome.
------------------------------
Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py
------------------------------
Program：isPalindrome
------------------------------
Type in Target String which you want to Check：
adamhuan
Your Target String is： adamhuan
------------------------------
The Length of Target is： 8
The Length of Target is: Even.
------------------------------
Target is Not Palindrome.
------------------------------
Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py
------------------------------
Program：isPalindrome
------------------------------
Type in Target String which you want to Check：
Babyla
Your Target String is： Babyla
------------------------------
The Length of Target is： 6
The Length of Target is: Even.
------------------------------
Target is Not Palindrome.
------------------------------
Done.

C:\Users\adamhuan>

Microsoft Windows [版本 6.1.7601]

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py

------------------------------

Program：isPalindrome

------------------------------

Type in Target String which you want to Check：

allahhalla

Your Target String is： allahhalla

------------------------------

The Length of Target is： 10

The Length of Target is: Even.

------------------------------

Target is Palindrome.

------------------------------

Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py

------------------------------

Program：isPalindrome

------------------------------

Type in Target String which you want to Check：

angelababyIybabalegna

Your Target String is： angelababyIybabalegna

------------------------------

The Length of Target is： 21

The Length of Target is: Odd.

------------------------------

Target is Palindrome.

------------------------------

Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py

------------------------------

Program：isPalindrome

------------------------------

Type in Target String which you want to Check：

adamhuan

Your Target String is： adamhuan

------------------------------

The Length of Target is： 8

The Length of Target is: Even.

------------------------------

Target is Not Palindrome.

------------------------------

Done.

C:\Users\adamhuan>c:\Python27\python.exe d:\python_data\isPalindrome.py

------------------------------

Program：isPalindrome

------------------------------

Type in Target String which you want to Check：

Babyla

Your Target String is： Babyla

------------------------------

The Length of Target is： 6

The Length of Target is: Even.

------------------------------

Target is Not Palindrome.

------------------------------

Done.

C:\Users\adamhuan>

——————————————————————
Done。[……]

Posted on: 2015年3月14日 2015年3月14日
Author: Adamhuan
Categories: Python
Tags: Code, Learn, Note, Palindrome, Python, 代码, 回文, 笔记
Leave a comment: Python Code：回文（Palindrome）的检查