Shulou(Shulou.com)06/01 Report--

The following brings you about the use of ToughMySQL tools to provide data storage to the ToughRADIUS system, if you are interested, let's take a look at this article, I believe that after reading the use of ToughMySQL tools to provide data storage to the ToughRADIUS system will be of some help.

Functional features:

Implement MySQL Docker container deployment.

Provides optimized configuration for different CVM configuration environments.

Provides one-click script quick installation.

Provide backup script to support automatic deletion of backups for more than 7 days.

Provide fast configuration of master-slave and master / slave.

Quick Guide backing up the current database

If this is a first-time installation, you can skip it, and if you are migrating the database, be sure to make a backup.

Installation script

Tmshell is an automated installation and management script through which many useful management functions are provided

$wget https://github.com/talkincode/toughmysql/raw/master/tmshell-O / usr/local/bin/tmshell$ chmod + x / usr/local/bin/tmshell$ tmshell install

Enter tmshell directly to see the supported instruction operations

Usage: tmshell [OPTIONS] instance docker_setup install docker Docker-compose pull mysql docker p_w_picpaths pull install install default mysql instance remove uninstall mysql instance config mysql instance config edit status mysql instance status restart mysql instance restart stop Mysql instance stop logs mysql instance logs showmaster mysql instance showmaster status showslave mysql instance showslave status upmaster mysql instance update master sync config backup mysql instance backup database dsh mysql instance bash term All other options are passed to the tmshell program. Complete installation process

The installation process is an interactive process, which modifies specific parameters according to the actual situation.

[root@i-jahnm3dt ~] # tmshell install# default created mysql database user mysql user [raduser]: # default created mysql database user password mysql user password [radpwd]: # default created mysql database name mysql database [radiusd]: # default mysqlroot password mysqlroot password [none]: # default mysql private replication user password mysql replication password [replication]: # mysql service port mysql port [3306]: # if you plan to deploy in hot standby mode You need to enter server idmysql server id [1re2] (default none): maximum memory mysql max memary used by the mysql service [512m memory 1G] 4G] (default none): ToughMySQL instance config:instance name: mysqlmysql_user: radusermysql_password: radpwdmysql_database: radiusdmysql_root_password:mysql_repl_password: replicationmysql_port: 3306serverid: 1mysql_max_mem:database: container_name: db_mysql p_w_picpath: "index.alauda.cn/toughstruct/mysql" privileged: true ports:-"3306 ulimits: nproc: 65535 nofile: Soft: 20000 hard: 40000 environment:-SERVERID=1-MYSQL_MAX_MEM=-MYSQL_USER=raduser-MYSQL_PASSWORD=radpwd-MYSQL_DATABASE=radiusd-MYSQL_ROOT_PASSWORD=-MYSQL_REPL_PASSWORD=replication restart: always volumes: / home/toughrun/mysql/dbmysql:/var/lib/mysql / home/toughrun/mysql/backup:/var/backupCreating db_mysql Name Command State Ports---db_mysql / usr/local/bin/run Up 0.0.0.0 3306/tcp 3306->

The / home/toughrun/mysql/dbmysql directory is mapped to the MySQL data file directory on the host

The / home/toughrun/mysql/backup directory is a backup directory mapped to the host

Read the details about the use of ToughMySQL tools to provide data storage to the ToughRADIUS system, whether there is anything to gain. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.