— 安装MySQL数据库
[root@fgedu ~]# yum install -y mysql-server
— 启动MySQL服务
[root@fgedu ~]# systemctl start mysqld
[root@fgedu ~]# systemctl enable mysqld
— 创建平台数据库
[root@fgedu ~]# mysql -uroot -p
mysql> CREATE DATABASE dm_platform CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
mysql> CREATE USER ‘dm_platform’@’fgedu.localhost’ IDENTIFIED BY ‘DmPlatform123’;
mysql> GRANT ALL PRIVILEGES ON dm_platform.* TO ‘dm_platform’@’fgedu.localhost’;
mysql> FLUSH PRIVILEGES;
— 导入平台数据库脚本
[root@fgedu ~]# mysql -udm_platform -pDmPlatform123 dm_platform < dm_platform.sql

部署平台后端服务：

— 安装Python环境
[root@fgedu ~]# yum install -y python3 python3-pip
— 安装依赖包
[root@fgedu ~]# pip3 install flask flask-sqlalchemy flask-cors pymysql requests
— 部署平台后端代码
[root@fgedu ~]# mkdir -p /dm-platform/backend
[root@fgedu ~]# cd /dm-platform/backend
— 创建配置文件
[root@fgedu ~]# vi config.py
import os
class Config:
SECRET_KEY = os.environ.get(‘SECRET_KEY’) or ‘dm-platform-secret-key’
SQLALCHEMY_DATABASE_URI = ‘mysql+pymysql://dm_platform:DmPlatform123@fgedu.localhost/dm_platform’
SQLALCHEMY_TRACK_MODIFICATIONS = False
— 创建后端服务文件
[root@fgedu ~]# vi app.py
from flask import Flask, jsonify, request
from flask_sqlalchemy import SQLAlchemy 学习交流加群风哥QQ113257174
from config import Config
app = Flask(__name__)
app.config.from_object(Config)
db = SQLAlchemy(app)
# 数据库实例模型
class DBInstance(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
host = db.Column(db.String(100), nullable=False)
port = db.Column(db.Integer, nullable=False)
username = db.Column(db.String(100), nullable=False)
password = db.Column(db.String(100), nullable=False)
status = db.Column(db.String(20), default=’active’)
# 获取所有实例
@app.route(‘/api/instances’, methods=[‘GET’])
def get_instances():
instances = DBInstance.query.all()
result = []
for instance in instances:
result.append({
‘id’: instance.id,
‘name’: instance.name,
‘host’: instance.host,
‘port’: instance.port,
‘username’: instance.username,
‘status’: instance.status
})
return jsonify(result)
# 添加实例
@app.route(‘/api/instances’, methods=[‘POST’])
def add_instance():
data = request.get_json()
instance = DBInstance(
name=data[‘name’],
host=data[‘host’],
port=data[‘port’],
username=data[‘username’],
password=data[‘password’]
)
db.session.add(instance) 更多视频教程www.fgedu.net.cn
db.session.commit()
return jsonify({‘message’: ‘Instance added successfully’})
# 批量执行SQL
@app.route(‘/api/instances/batch-sql’, methods=[‘POST’])
def batch_sql():
data = request.get_json()
instances = DBInstance.query.filter(DBInstance.id.in_(data[‘instance_ids’])).all()
results = []
for instance in instances:
try:
import pymysql
conn = pymysql.connect(
host=instance.host,
port=instance.port,
user=instance.username,
password=instance.password,
database=’fgedudb’
)
cursor = conn.cursor()
cursor.execute(data[‘sql’])
conn.commit()
cursor.close()
conn.close()
results.append({
‘instance_id’: instance.id,
‘instance_name’: instance.name,
‘status’: ‘success’
})
except Exception as e:
results.append({
‘instance_id’: instance.id,
‘instance_name’: instance.name,
‘status’: ‘failed’,
‘error’: str(e)
})
return jsonify(results)
if __name__ == ‘__main__’:
db.create_all()
app.run(host=’0.0.0.0′, port=5000)

— 检查后端服务状态
[root@fgedu ~]# systemctl status dm-platform-backend
— 服务状态
● dm-platform-backend.service – DM Platform Backend
Loaded: loaded (/etc/systemd/system/dm-platform-backend.service; enabled; vendor preset: disabled)
Active: inactive (dead) since Thu 2026-04-09 10:00:00 CST; 10s ago
— 启动后端服务
[root@fgedu ~]# systemctl start dm-platform-backend
— 检查前端服务状态
[root@fgedu ~]# systemctl status dm-platform-frontend
— 服务状态
● dm-platform-frontend.service – DM Platform Frontend
Loaded: loaded (/etc/systemd/system/dm-platform-frontend.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2026-04-09 10:00:00 CST; 10s ago

检查网络连接：

— 测试网络连接
[root@fgedu ~]# curl http://192.168.1.100:8080
— 输出结果

…

检查平台配置：

— 检查后端配置
[root@fgedu ~]# cat /dm-platform/backend/config.py
— 检查数据库连接
[root@fgedu ~]# mysql -udm_platform -pDmPlatform123 dm_platform -e “SELECT COUNT(*) FROM db_instance;”
— 查询结果
+———-+
| COUNT(*) |
+———-+
| 10 |
+———-+

重启平台服务：

— 重启后端服务
[root@fgedu ~]# systemctl restart dm-platform-backend
— 重启前端服务
[root@fgedu ~]# systemctl restart dm-platform-frontend
— 查看服务状态
[root@fgedu ~]# systemctl status dm-platform-backend
[root@fgedu ~]# systemctl status dm-platform-frontend
— 访问平台Web界面
— http://192.168.1.100:8080