Giter Club home page Giter Club logo

mysql-snapshot-cron's Introduction

概要

RDSなどを使えない場合用のsnapshot自動化スクリプト。

一時間ごとに、mysqlのデータをs3にバックアップする。

shellはbashが前提です。

使い方

BUCKUP_BUCKET_NAMEとMYSQL_ROOT_PASSWORDは適宜適切な物を入れてください。

前準備

make setUpX86Linux # x86 architecture
# or
make setUpArmLinux # arm architecture

echo 'BUCKUP_BUCKET_NAME = YOUR_OWN_BUCKUP_BUCKET_NAME' >> ~/.bashrc
echo 'MYSQL_ROOT_PASSWORD = YOUR_OWN_MYSQL_ROOT_PASSWORD' >> ~/.bashrc

# AWS CLI用の設定
echo 'AWS_ACCESS_KEY_ID = YOUR_OWN_AWS_ACCESS_KEY_ID' >> ~/.aws/credentials
echo 'AWS_SECRET_ACCESS_KEY = YOUR_OWN_AWS_SECRET_ACCESS_KEY' >> ~/.aws/credentials

source ~/.bashrc
source ~/.aws/credentials

cron設定

make setCron

解凍

gunzip FILE_NAME

mysql-snapshot-cron's People

Contributors

hirokihello avatar

Watchers

James Cloos avatar avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.