Mysql database backup

Question

we have a mysql table which consist of 300 million rows. The data get inserted in the database frequently and there must be no down time. What is the ideal way to back up these data. Is mysql Enterprise back up is a good option?

@BaBL86 Not necessarily, some switches can remove locking altogether (assuming InnoDB). See stackoverflow.com/a/104628/505722 — Jim
– Jim, Commented Apr 28, 2014 at 11:21

BaBL86 · Accepted Answer · 2014-04-28 10:51:51Z

1

Use Percona with innoDB DB Engine. Percona toolkit include innobackupex utility, that can dump your base on the fly.

Or you can place your data folder on LVM partition and create snapshot. But it's slooooow...

Another way - replication. You can setup another mysql server as slave (for read only) and create backups from that second server. But it needs more money =)

answered Apr 28, 2014 at 10:51

BaBL86

2,6301 gold badge16 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3580984 Over a year ago

thanks for your reply . Can i use Percona in windows? I heard that it is mainly for linux.

BaBL86 Over a year ago

There is only one DBServer, that works normal in Windows: MSSQL Server. MySQL, Percona, PostgreSQL, Oracle, Firebird more powerful and more comfort and mostly developed for unix-like systems.

Collectives™ on Stack Overflow

Mysql database backup

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related