mysql mmm架构不足_MySQL-MMM架构使用

问题

本案例要求基于普通版的MySQL服务器改造MMM架构,完成以下任务操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

启动MMM集群架构

设置集群中服务器为online状态方案

MySQL-MMM架构部署完成后需要启动,数据库端启动mmm-agent进程,管理端启动mmm-monitor进程,启动完成后设置所有数据库主机状态为online。

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

步骤

实现此案例需要按照如下步骤进行。

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

步骤一:启动MMM集群架构

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

1)启动mmm-agent进程

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

master1操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@master1 ~]# /etc/init.d/mysql-mmm-agent start

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon bin: "/usr/sbin/mmm_agentd"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon pid: "/var/run/mmm_agentd.pid"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Starting MMM Agent daemon... Ok

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

master2操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@master2 ~]# /etc/init.d/mysql-mmm-agent start

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon bin: "/usr/sbin/mmm_agentd"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon pid: "/var/run/mmm_agentd.pid"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Starting MMM Agent daemon... Ok

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

slave1操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@master2 ~]# /etc/init.d/mysql-mmm-agent start

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon bin: "/usr/sbin/mmm_agentd"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon pid: "/var/run/mmm_agentd.pid"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Starting MMM Agent daemon... Ok

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

slave2操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@slave2 ~]# /etc/init.d/mysql-mmm-agent start

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon bin: "/usr/sbin/mmm_agentd"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon pid: "/var/run/mmm_agentd.pid"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Starting MMM Agent daemon... Ok

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

2)启动mmm-monitor进程

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

monitor主机操作:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# /etc/init.d/mysql-mmm-monitor start

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon bin: "/usr/sbin/mmm_mond"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Daemon pid: "/var/run/mmm_mond.pid"

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

Starting MMM Monitor daemon: Ok

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

步骤二:设置集群中服务器为online状态

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

控制命令只能在管理端monitor服务器上执行。

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control show

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

master1(192.168.4.10) master/AWAITING_RECOVERY. Roles:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

master2(192.168.4.11) master/AWAITING_RECOVERY. Roles:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

slave1(192.168.4.12) slave/AWAITING_RECOVERY. Roles:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

slave2(192.168.4.13) slave/AWAITING_RECOVERY. Roles:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

设置4台数据库主机状态为online:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control set_online master1

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

OK: State of "master1" changed to ONLINE. Now you can wait some time and check its new roles!

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control set_online master2

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

OK: State of "master2" changed to ONLINE. Now you can wait some time and check its new roles!

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control set_online slave1

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

OK: State of "slave1" changed to ONLINE. Now you can wait some time and check its new roles!

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control set_online slave2

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

OK: State of "slave2" changed to ONLINE. Now you can wait some time and check its new roles!

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]#

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

再次查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

[root@monitor ~]# mmm_control show

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

master1(192.168.4.10) master/ONLINE. Roles: writer(192.168.4.200)

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

master2(192.168.4.11) master/ONLINE. Roles:

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

slave1(192.168.4.12) slave/ONLINE. Roles: reader(192.168.4.201)

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

slave2(192.168.4.13) slave/ONLINE. Roles: reader(192.168.4.202)

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@monitor ~]#

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

步骤三:测试MySQL-MMM架构

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

1)客户机安装MySQL-client软件包

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# tar xvf MySQL-5.6.15-1.el6.x86_64.rpm-bundle.tar

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

.. ..

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

.. ..

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

2)MySQL-MMM虚拟IP访问测试

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# mysql -h192.168.4.200 -uroot -ppwd123 -e "show databases"

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

Warning: Using a password on the command line interface can be insecure.

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| Database           |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| information_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| mysql              |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| performance_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| tarena             |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| test               |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]#

ocreatean“uberjar”containingtheirapplicationalongwithitsdependencies.Theuser’sjarshouldneverincludeH

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# mysql -h192.168.4.200 -uroot -ppwd123 -e "show databases"

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

Warning: Using a password on the command line interface can be insecure.

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| Database           |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| information_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| mysql              |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| performance_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| tarena             |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| test               |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]#

ocreatean“uberjar”containingtheirapplicationalongwithitsdependencies.Theuser’sjarshouldneverincludeH

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# mysql -h192.168.4.202 -uroot -ppwd123 -e "show databases"

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

Warning: Using a password on the command line interface can be insecure.

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| Database           |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| information_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| mysql              |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| performance_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| tarena             |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| test               |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]#

ocreatean“uberjar”containingtheirapplicationalongwithitsdependencies.Theuser’sjarshouldneverincludeH

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

3)主数据库宕机测试

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

[root@master1 ~]# service mysql stop //停止master1上服务

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

Shutting down MySQL....                                    [确定]

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

[root@master1 ~]#

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@monitor ~]# mmm_control show //查看集群内服务器状态

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

通过输出信息可以看到虚拟IP从master1切换到master2:

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

master1(192.168.4.10) master/HARD_OFFLINE. Roles:

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

master2(192.168.4.11) master/ONLINE. Roles: writer(192.168.4.200)

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

slave1(192.168.4.12) slave/ONLINE. Roles: reader(192.168.4.201)

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

slave2(192.168.4.13) slave/ONLINE. Roles: reader(192.168.4.202)

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@monitor ~]#

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

/mmm_mond.pid"StartingMMMMonitordaemon:Ok步骤二:设置集群中服务器为online状态控制命令只能在管理端monitor服务器上执行。查看当前集群中各服务器状态:

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]# mysql -h192.168.4.200 -uroot -ppwd123 -e "show databases" //访问虚拟IP测试

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

Warning: Using a password on the command line interface can be insecure.

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| Database           |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| information_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| mysql              |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| performance_schema |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| tarena             |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

| test               |

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

+--------------------+

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

[root@client ~]#

ocreatean“uberjar”containingtheirapplicationalongwithitsdependencies.Theuser’sjarshouldneverincludeH

式存储系统。2.Sparkisagnostictotheunderlyingclustermanager.Aslongasitcanacquireexecutorprocesses,andthesec

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

donthecommandlineinterfacecanbeinsecure.+--------------------+|Database          |+-----------------

ocreatean“uberjar”containingtheirapplicationalongwithitsdependencies.Theuser’sjarshouldneverincludeH


版权声明:本文为weixin_42396932原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。