Amazon Aurora is designed to be compatible with MySQL and with PostgreSQL, so that existing applications and tools can run without requiring modification.Īmazon Aurora is designed to offer greater than 99.99% availability, increasing MySQL and PostgreSQL performance and availability by tightly integrating the database engine with an SSD-backed virtualized storage layer purpose-built for database workloads. It delivers up to five times the throughput of standard MySQL and up to three times the throughput of standard PostgreSQL. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon RDS.Īmazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It frees you to focus on your applications, so you can give them the fast performance, high availability, security and compatibility they need.Īmazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. The MySQL documentation is available here.Amazon Web Services offers a broad set of global cloud-based products including compute, storage, databases, analytics, networking, mobile, developer tools, management tools, IoT, security and enterprise applications.Īmazon Relational Database Service (Amazon RDS) facilitates the setting up, operating, and scaling of relational databases in the Cloud.
With bash now being available natively on Windows (traditionally poor in the MySQL backup area), these might be worth investigating for users of that OS.Īn interesting variant on automysqlbackup (disclaimer - I haven't used it) is a script which will perform incremental backups which is to be found here.Īnother way to backup - which is "hot" is to use replication - this process is explained in detail here. One of the best (IMHO) of which (and one of the most popular) is automysqlbackup, but you may like to try out any/all/some of the others. A Google of " mysql incremental backup bash script" (or similar) will get you a shedload of these. On a final note, there is an endless number of shell (mostly bash) scripts out there. (Credit where credit is due, I "stole" this image from here :-) )
I would concur with that regularly taking a full backup (at such small time intervals) doesn't make sense - your system will not be able to do any real work with a constant resource drain like that.įor completeness, you might want to look at the options here: You could also look at zmanda - (mentioned in " High Performance MySQL"). If you're familiar with all that stuff about mounting logical volumes &c., this may be of interest to you.
You might also be interested in LVM snapshots - it's not a technology with which I am currently familiar but it's on my to-do list (like a lot of stuff :-) ). What they offer is Percona XtraBackup which has an incremental backup functionality. I would recommend without hesitation any tool by Percona and I would put this first on my list for testing on any MySQL system which I work with. In addition to the Enterprise solution mentioned by there is a F/LOSS solution available from Percona (who are big hitters in the MySQL world). mysqldump -uuser -ppass -single-transaction -routines -triggers -all-databases > backup_db.sql From here, the complete mysqldump command for a hot backup of a MySQL database using only InnoDB tables is: (from here).