Mycat个人心得笔记（二）

我就是我 2022-01-23 08:34 280阅读 0赞

#                              Mycat个人心得笔记（二） #

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

**目录**

Mycat个人心得笔记（二）

一.Mysql集群安装

1.安装cmake(云主机,虚拟机环境无需安装)

2.安装包解压(/home/resources中)

3.安装数据库相关包

4.检查相关两个文件夹

5.Mysql运行启动

6.远程连接云主机Mysql

7.登录远程数据库

下篇博客搭建数据库Mysql的主从配置

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

# 一.Mysql集群安装 #

### **1.安装****cmake****(****云主机****,****虚拟机环境无需安装****)** ###

**环境插件  空环境必须做这一项**

**yum 安装cmake gcc tcl\***

**\#yum -y install cmake**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70][]

### **2.安装包解压****(/home/resources****中****)** ###

**创建一个空文件  PS:需要两个云主机**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 1][]

**将资源移动到该文件夹中**

![20190603113745582.png][]

**解压该资源**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 2][]

### 3.安装数据库相关包 ###

**安装 要按顺序来，最好安装我的图来做，防止产生没必要的错误 \-ivh 显示安装进度**

![20190603114529859.png][]

**安装第一个安装包 rpm -ivh Percona-Server-56-debuginfo-5.6.24-rel72.2.el6.x86\_64.rpm     调试**

![2019060311461737.png][]

**安装第二个安装包 rpm -ivh Percona-Server-shared-56-5.6.24-rel72.2.el6.x86\_64.rpm          分片**

![20190603114826369.png][]

**安装第三个安装包 rpm -ivh Percona-Server-client-56-5.6.24-rel72.2.el6.x86\_64.rpm             客户端**

![20190603115121550.png][]

**安装第四个安装包 rpm -ivh Percona-Server-server-56-5.6.24-rel72.2.el6.x86\_64.rpm            servlet**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 3][]

**两台云主机Mysql安装成功，PS：不只是我这一种安装方法**

### **4.检查相关两个文件夹** ###

**1./etc/my.cnf**

![2019060311564448.png][]

**这个文件出现，才能说明安装成功**

![20190603115945707.png][]

**如果不存在,从有的服务器远程拷贝**

**远程拷贝：\[root@IP\]****\#  scp xxx.txt root@10.42.60.249:/home/**

**2./var/lib/mysql**

![20190603120151990.png][]

### **5.Mysql运行启动** ###

![20190603120303464.png][]

**数据库启动成功**，

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 4][]

**无需输入数据库密码直接通过指令进入**

![20190603120519530.png][]

**查看数据库信息，好久没敲，指令都快忘记了**

### **6.远程连接云主机Mysql** ###

![20190603121429540.png][]

**设置对应的账号，密码，远程连接需要账号和密码**

![20190603121745727.png][]

**设置运行远程登录 在自动生成的Mysql数据库中有User表，用来设置运行远程登录，需要在云主机中设置**

*  **默认安装的mysql没有外部访问权限,所以需要开启访问权限**
 *  **grant \[权限\] on \[数据库名\].\[表名\] to \['用户名'\]@\['web服务器的ip地址'\] identified by \['密码'\];**
 *  **"%" 表示所有10.0.0.1这样格式的ip地址 10-0-0-1**
 *  **mysql>grant all on \*.\* to 'root'@'%' identified by 'root';**

![20190603122120119.png][]

**给所有输入root,root的用户运行远程连接**

![2019060312234732.png][]

**连接成功**

### **7.登录远程数据库** ###

![20190603122527622.png][]

**把所有账号root中的密码全部改成加密的字符串（root加密）**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 5][]

**两台全部设置**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 6][]

**此时，Mysql数据库基本搭建成功**

# **                     下篇博客搭建数据库Mysql的主从配置** #

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70]: /images/20220123/665c8ec151b047499d4b025a8a2a3bb3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 1]: /images/20220123/ec90edf6e9654aa0bc275e88d5282e14.png
[20190603113745582.png]: /images/20220123/c39848f0a2aa436fbd648a496d63e37b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 2]: /images/20220123/979642226b6145a487d3f8e0d44b791b.png
[20190603114529859.png]: /images/20220123/9639943aa109454b97be86075eca1ae6.png
[2019060311461737.png]: /images/20220123/0afafe80b22f4295ab184222a293d007.png
[20190603114826369.png]: /images/20220123/c17b40dfc7ef43f9975b5522cc6eb323.png
[20190603115121550.png]: /images/20220123/492c077990334a35a905708dbebbfbeb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 3]: /images/20220123/1ff9048953ea427cab2dc5b8889dece2.png
[2019060311564448.png]: /images/20220123/ff2561daa4494a0a804b25955a3cc41b.png
[20190603115945707.png]: /images/20220123/996c22bc7d414ff0ae4433e274aa7790.png
[20190603120151990.png]: /images/20220123/ae61a56bc315485a8392d3b8b4396b55.png
[20190603120303464.png]: /images/20220123/05818bb958b34700983a6ccb5a041242.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 4]: /images/20220123/a744246f785746aca9d55d322453331f.png
[20190603120519530.png]: /images/20220123/9c909cec03d249ca9135c12b97df8441.png
[20190603121429540.png]: /images/20220123/1b0f4be7d1664839b74f5ecae1e8ed7f.png
[20190603121745727.png]: /images/20220123/bd2b9a70a7354faa9720f356e3c8ceb3.png
[20190603122120119.png]: /images/20220123/ddfa733e5f4a4a269f9c76b6a342bdc8.png
[2019060312234732.png]: /images/20220123/fda966fa554044ffac22d222d89479a2.png
[20190603122527622.png]: /images/20220123/9e8dc9fbee194a4b85831eeb525b5c82.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 5]: /images/20220123/56ddd6a76ff74b74baf10a8c65cfb1c6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0xpdVk1MjE_size_16_color_FFFFFF_t_70 6]: /images/20220123/7a9ae91f078c4b988642fced957e53a4.png