MySQL in RAM. How to make a backup?

Question

MySQL

Good afternoon.
The administrator moved the database to the RAM. And I wrote a database backup script every 2 hours.

#!/bin/bash
/etc/init.d/mysqld stop
cd /var/mysql
rsync -arvv * /var/lib/mysql
/etc/init.d/mysqld start

It seems to me that stopping the base every two hours is not an option. Are there other ways?

From what I googled: mylvmbackup, mysqlhotcopy

Answer 1

It seems to me that stopping the base every two hours is not an option.

Depends on reliability and uptime requirements.
But the way is, of course, strange.

Are there other ways?

Make a backup from the slave.

Answer 2

and why mysqldump does not suit you?
well, ssd is a little simpler and more reliable than RAM

Answer 3

You don't need to stop MySQL at all .
Backup options without stopping the server:

• mysqdump - takes a logical data dump, but see the pitfalls about table locking and consistency...
  
• xtrabackup (using innobackupex) - takes a physical copy of InnoDB databases without stopping the application/database server. Does something similar to your script, but more advanced and without stopping the service.