当前位置： 首页 > news >正文

网站建设后续的费用/数据分析一般用什么软件

news 2025/8/3 23:40:38
网站建设后续的费用,数据分析一般用什么软件,长安网站建设公司哪家好,外贸网站建设步骤文章目录CentOS 7 下 MySQL 5.7.x 安装安装准备安装包准备卸载 MariaDBMySQL 5.7.x 安装MySQL 主从配置主节点从节点主从测试主节点从节点CentOS 7 下 MySQL 5.7.x 安装 CentOS 7 MySQL5.7 主从配置-binlog 全自动安装mysql脚本 新服务器从安装mysql到主从配置完成只需要3分钟…

文章目录

  • CentOS 7 下 MySQL 5.7.x 安装
      • 安装准备
          • 安装包准备
          • 卸载 MariaDB
      • MySQL 5.7.x 安装
      • MySQL 主从配置
          • 主节点
          • 从节点
      • 主从测试
          • 主节点
          • 从节点

CentOS 7 下 MySQL 5.7.x 安装

  • CentOS 7 MySQL5.7 主从配置-binlog 全自动安装mysql脚本 新服务器从安装mysql到主从配置完成只需要3分钟

安装准备

安装包准备
  • 上传安装包
mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar
  • 解压安装包
# tar -xf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar
卸载 MariaDB
  • 查看是否安装 MariaDB
# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
  • 卸载 MariaDB
# rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

MySQL 5.7.x 安装

  • 安装 mysql-community-common
# rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-common-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-common-5.7.25-1.e################################# [100%]
  • 安装 mysql-community-libs
# rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-libs-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-libs-5.7.25-1.el7################################# [100%]
  • 安装 mysql-community-client
# rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-client-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-client-5.7.25-1.e################################# [100%]
  • net-tools 安装
# rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:net-tools is needed by mysql-community-server-5.7.25-1.el7.x86_64

# yum -y install net-tools
Loaded plugins: fastestmirror
Determining fastest mirrors* base: mirror.bit.edu.cn* extras: mirror.bit.edu.cn* updates: mirrors.huaweicloud.com
base                                                                                                                                                                                              | 3.6 kB  00:00:00     
extras                                                                                                                                                                                            | 2.9 kB  00:00:00     
updates                                                                                                                                                                                           | 2.9 kB  00:00:00     
(1/4): base/7/x86_64/group_gz                                                                                                                                                                     | 153 kB  00:00:00     
(2/4): extras/7/x86_64/primary_db                                                                                                                                                                 | 205 kB  00:00:00     
(3/4): updates/7/x86_64/primary_db                                                                                                                                                                | 3.0 MB  00:00:00     
(4/4): base/7/x86_64/primary_db                                                                                                                                                                   | 6.1 MB  00:00:01     
Resolving Dependencies
--> Running transaction check
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
--> Finished Dependency ResolutionDependencies Resolved=========================================================================================================================================================================================================================Package                                           Arch                                           Version                                                             Repository                                    Size
=========================================================================================================================================================================================================================
Installing:net-tools                                         x86_64                                         2.0-0.25.20131004git.el7                                            base                                         306 kTransaction Summary
=========================================================================================================================================================================================================================
Install  1 PackageTotal download size: 306 k
Installed size: 917 k
Downloading packages:
warning: /var/cache/yum/x86_64/7/base/packages/net-tools-2.0-0.25.20131004git.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Public key for net-tools-2.0-0.25.20131004git.el7.x86_64.rpm is not installed
net-tools-2.0-0.25.20131004git.el7.x86_64.rpm                                                                                                                                                     | 306 kB  00:00:00     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Importing GPG key 0xF4A80EB5:Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5Package    : centos-release-7-5.1804.el7.centos.x86_64 (@anaconda)From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18()(64bit)
2:postfix-2.10.1-6.el7.x86_64 has missing requires of libmysqlclient.so.18(libmysqlclient_18)(64bit)Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                             1/1 Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                             1/1 Installed:net-tools.x86_64 0:2.0-0.25.20131004git.el7                                                                                                                                                                            Complete!
  • 安装 mysql-community-server
# rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
warning: mysql-community-server-5.7.25-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Sign                                                                              ature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-server-5.7.25-1.e################################# [100%]
  • 修改配置文件
# vim /etc/my.cnf
datadir=/home/autoInstall_1.2.1/mysql/data 		# 指定 MySQL data 目录
character-set-server=utf8
collation-server=utf8_general_ci
  • 创建目录 && 赋权
# mkdir -p /home/autoInstall_1.2.1/mysql/data
# chown -R mysql:mysql /home/autoInstall_1.2.1/mysql
  • 初始化数据库配置
# mysqld --initialize --user=mysql
  • 启动 MySQL && 配置开机启动
# systemctl start mysqld.service && systemctl enable mysqld.service && systemctl status mysqld.service
  • 获取临时密码
# cat /home/mysql/logs/mysqld.log | grep password
2020-07-13T05:21:02.798254Z 1 [Note] A temporary password is generated for root@localhost: *)3QpY%yh1rw
  • 通过临时密码配置 root 密码
# mysql -u root -p
Enter password: 			# 此处输入
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.25Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
  • 更改密码
mysql> set password = password("Test@MySQL1234!");
Query OK, 0 rows affected, 1 warning (0.00 sec)
  • 为 root 提供远程登录权限
mysql> grant all privileges on *.* to 'root' @'%' identified by 'Test@MySQL1234!';
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MySQL 主从配置

主节点
  • 更改配置文件
server-id = 119
log-bin = master-bin
  • 授权
mysql> GRANT REPLICATION SLAVE,REPLICATION CLIENT ON *.* TO 'mysql132'@'%' identified by 'Jhmk@MySQL2345!';
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
从节点
  • 更改配置文件
server-id = 119
  • 指向主节点
mysql> CHANGE MASTER TO MASTER_HOST='10.1.0.119',MASTER_PORT=3306,MASTER_user='mysql132',MASTER_PASSWORD='Jhmk@MySQL2345!';
Query OK, 0 rows affected, 2 warnings (0.03 sec)
  • 启动 Slave
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
  • 查看 master 线程
mysql> show master status \G
*************************** 1. row ***************************File: master-bin.000001Position: 613Binlog_Do_DB:Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)
  • 查看 slave 线程
mysql> show slave status \G
*************************** 1. row ***************************Slave_IO_State: Waiting for master to send eventMaster_Host: 10.1.0.119Master_User: mysql132Master_Port: 3306Connect_Retry: 60Master_Log_File: master-bin.000001Read_Master_Log_Pos: 613Relay_Log_File: hessian05-relay-bin.000002Relay_Log_Pos: 828Relay_Master_Log_File: master-bin.000001Slave_IO_Running: YesSlave_SQL_Running: YesReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0Last_Error:Skip_Counter: 0Exec_Master_Log_Pos: 613Relay_Log_Space: 1039Until_Condition: NoneUntil_Log_File:Until_Log_Pos: 0Master_SSL_Allowed: NoMaster_SSL_CA_File:Master_SSL_CA_Path:Master_SSL_Cert:Master_SSL_Cipher:Master_SSL_Key:Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: NoLast_IO_Errno: 0Last_IO_Error:Last_SQL_Errno: 0Last_SQL_Error:Replicate_Ignore_Server_Ids:Master_Server_Id: 119Master_UUID: bbce4327-b150-11ea-942f-fa163e3f3868Master_Info_File: /home/autoInstall_1.2.1/mysql/data/master.infoSQL_Delay: 0SQL_Remaining_Delay: NULLSlave_SQL_Running_State: Slave has read all relay log; waiting for more updatesMaster_Retry_Count: 86400Master_Bind:Last_IO_Error_Timestamp:Last_SQL_Error_Timestamp:Master_SSL_Crl:Master_SSL_Crlpath:Retrieved_Gtid_Set:Executed_Gtid_Set:Auto_Position: 0Replicate_Rewrite_DB:Channel_Name:Master_TLS_Version:
1 row in set (0.00 sec)

主从测试

主节点
  • 创建测试库
mysql> CREATE DATABASE `TEST_SYNC`;
Query OK, 1 row affected (0.01 sec)
  • 创建表
mysql> USE `TEST_SYNC`
Database changedmysql> CREATE TABLE `SYNC_01` (`ID` INT(11) NOT NULL AUTO_INCREMENT,`NAME` VARCHAR(255) NOT NULL,PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.03 sec)
  • 查看所有库
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| TEST_SYNC          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
  • 查看库中表 && 表结构
mysql> USE TEST_SYNC
Database changedmysql> SHOW TABLES;
+---------------------+
| Tables_in_TEST_SYNC |
+---------------------+
| SYNC_01             |
+---------------------+
1 row in set (0.00 sec)mysql> DESC SYNC_01;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| ID    | int(11)      | NO   | PRI | NULL    | auto_increment |
| NAME  | varchar(255) | NO   |     | NULL    |                |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
  • 查看 – 从节点信息
mysql> show slave hosts;
+-----------+------+------+-----------+--------------------------------------+
| Server_id | Host | Port | Master_id | Slave_UUID                           |
+-----------+------+------+-----------+--------------------------------------+
|       132 |      | 3306 |       119 | a909a62d-c1cd-11ea-ab37-fa163e651b69 |
+-----------+------+------+-----------+--------------------------------------+
1 row in set (0.00 sec)
  • 查看 – binary log 基本信息
mysql> show binary logs;
+-------------------+-----------+
| Log_name          | File_size |
+-------------------+-----------+
| master-bin.000001 |      1099 |
+-------------------+-----------+
1 row in set (0.00 sec)
  • 查看 – binlog event
mysql> show binlog events;
+-------------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------
| Log_name          | Pos | Event_type     | Server_id | End_log_pos | Info
+-------------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------
| master-bin.000001 |   4 | Format_desc    |       119 |         123 | Server ver: 5.7.25-log, Binlog ver: 4
| master-bin.000001 | 123 | Previous_gtids |       119 |         154 |
| master-bin.000001 | 154 | Anonymous_Gtid |       119 |         219 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
| master-bin.000001 | 219 | Query          |       119 |         461 | GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'mysql132'@'%'
| master-bin.000001 | 461 | Anonymous_Gtid |       119 |         526 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
| master-bin.000001 | 526 | Query          |       119 |         613 | FLUSH PRIVILEGES
| master-bin.000001 | 613 | Anonymous_Gtid |       119 |         678 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
| master-bin.000001 | 678 | Query          |       119 |         789 | CREATE DATABASE `TEST_SYNC`
| master-bin.000001 | 789 | Anonymous_Gtid |       119 |         854 | SET @@SESSION.GTID_NEXT= 'ANONYMOUS'
| master-bin.000001 | 854 | Query          |       119 |        1099 | use `TEST_SYNC`; CREATE TABLE `SYNC_01` (`ID` INT(11) NOT NULL AUTO_
+-------------------+-----+----------------+-----------+-------------+---------------------------------------------------------------------
10 rows in set (0.00 sec)
从节点
  • 查看所有库
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| TEST_SYNC          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
  • 查看库中表 && 表结构
mysql> USE TEST_SYNC
Database changedmysql> SHOW TABLES;
+---------------------+
| Tables_in_TEST_SYNC |
+---------------------+
| SYNC_01             |
+---------------------+
1 row in set (0.00 sec)mysql> DESC SYNC_01;
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| ID    | int(11)      | NO   | PRI | NULL    | auto_increment |
| NAME  | varchar(255) | NO   |     | NULL    |                |
+-------+--------------+------+-----+---------+----------------+
2 rows in set (0.01 sec)
http://www.lbrq.cn/news/1612117.html

相关文章：

  • 国外b站浏览器免费版/新乡搜索引擎优化
  • wordpress seo神器/soe搜索优化
  • 用asp做网站怎么美观/模板建站代理
  • 开发公司网站建设/免费收录链接网
  • 网站建设公司推荐/专注网站建设服务机构
  • 织梦网站建设交流群/怎么制作个人网站
  • 《动态网站建设》第02章在线测试/旺道seo推广有用吗
  • 佛山网页设计师培训/辽阳网站seo
  • Org.cn 域名的网站/丈哥seo博客工具
  • ui设计和网站开发/怎样写营销策划方案
  • 网站建设作为/深圳有实力的seo公司
  • 网站优化建设河南/关键词竞价排名
  • 360官网首页入口/宁波seo入门教程
  • 有做装修效果图赚钱的网站吗/网络营销课程个人总结
  • 食品网站首页模板欣赏/长沙seo排名外包
  • 北京平台网站建设价格/百度联盟点击广告赚钱
  • 西安高新区网站制作/品牌运营岗位职责
  • 装饰网站的业务员都是怎么做的/广东seo推广
  • 日本域名 wordpress主机 价格/shopify seo
  • 学做网站用到哪些知识/网络推广公司排名
  • 怎么更改网站域名/厦门人才网个人登录
  • 20条优化防疫措施方案/seo外链增加
  • 佛山附近做网站的公司有哪些/seo分析师招聘
  • 美食网站制作代码/公司网站如何seo
  • 网站开发设计报告/免费seo营销软件
  • 网站修改dns/seo搜索引擎优化步骤
  • 中小企业网站制作软件/长沙seo网站管理
  • 梧州网站建设公司/百度云盘官网登录入口
  • 电动车网站建设/建站官网
  • 深圳营销型网站建设推广服务/搜索引擎优化排名品牌
  • Python Seaborn【数据可视化库】 全面讲解
  • sifu mod制作 相关经验
  • Java 中的 HashMap.merge() 方法详解
  • 数据结构（12）二叉树
  • Removing Digits(Dynamic Programming)
  • 解锁智能油脂润滑系统：加速度与温振传感器选型协同攻略