如何进行mysql备份平台及django践行

这期内容当中小编将会给大家带来有关如何进行mysql备份平台及django实践，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。
 
 具体实现
2.1、python2.7安装
tar zvf Python-2.7.10.tar
cd  Python-2.7.10
./configure --enable-shared --prefix=/usr/local/python27
make && make install
cp /usr/local/python27/lib/libpython2.7.so.1.0 /usr/local/lib
cd /usr/local/lib
ln -s libpython2.7.so.1.0 libpython2.7.so
 
 
2.2、django环境搭建
tar zxvf Django-1.11.3.tar.gzcd Django-1.11.3
python setup.py install
 
2.3、安装 MySQL-python
tar xvf MySQL-python-1.2.3.tarcd MySQL-python-1.2.3/
python setup.py  build
python setup.py  install
测试是否ok
Python 2.7.5 (default, Nov  6 2016, 00:28:07)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-11)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import django
>>> import MySQLdb
>>>
2.4、数据库
 
<1>、创建好mysql数据库,此处忽略
<2>、建立数据库my，创建元信息表，具体可参考博客：mysql多层元信息与查询实践（http://blog.itpub.net/28823725/viewspace-2142234/）
create user dumper@'127.0.0.1' identified by '123456';
grant select on *.* to dumper@'127.0.0.1';
grant show view on *.* to dumper@'127.0.0.1';
grant lock tables on *.* to dumper@'127.0.0.1';
grant trigger on *.* to dumper@'127.0.0.1';
查询用户
create user dba_read@'127.0.0.1' identified by '123456';
grant select on *.* to dba_read@'127.0.0.1';
注：次处只有一个mysql，只做元信息库与测试备份库
<4>、构建数据：
insert into my_server values(1,'127.0.0.1','127.0.0.1','lcl','1','idc1','2017-07-24 10:00:00','A',now());
insert into my_ip values(1,'127.0.0.1','lcl','1','idc1','2017-07-24 10:00:00','A',now())
insert into my_cluster values(1,'my',6001,'db info',0,1,now(),now(),'1',10,10,'5.7.19',1,1,'db info');
insert into my_db values(1,1,'127.0.0.1',6001,1,now(),now(),1,'w,r','Master',1,1,0,1,'/data/mysql/','1G','5.7.19','my','succ','db info');
insert into my_database values(1,1,'my','my','lcl',1,1,now(),now(),'dba','dba','succ','db info');
2.5、django详细
 
<1>创建项目
cd /chunlei/django/
django-admin.py   startproject   dba_backup
会产生目录dba_backup
cd /chunlei/django/dba_backup
ls
drwxr-xr-x. 3 root root 4096 Jul 24 17:18 dba_backup
-rwxrwxr-x. 1 root root  808 Jul 24 14:56 manage.py
 
<2>设置配置文件
cd /chunlei/django/dba_backup/dba_backup
vi settings.py
ALLOWED_HOSTS = ['可以访问的IP地址，也可以写*即不限制']
INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'dba_backup',
]
EMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': ['/chunlei/chunlei/django/dba_backup/dba_backup/templates'],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]
 
TIME_ZONE = 'Asia/Shanghai'
 
<3>、设置django的url文件
from django.conf.urls import url
from django.contrib import admin
from dba_backup.views import sql_export_search_form
from dba_backup.views import sql_export_result
from dba_backup.views import sql_export_sql
urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'^sql_export_search_form/$',sql_export_search_form),
    url(r'^sql_export_result/$', sql_export_result),
    url(r'^sql_export_search_form/sql_export_sql/$', sql_export_sql),
]
<4>、编写django的view文件
如附件
<5>、django的template的网页文件
/chunlei/django/dba_backup/dba_backup
mkdir templates
文件如附件
<6>、启动django
cd /chunlei/django/dba_backup
python manage.py  runserver IP:端口