All geek questions in one place

Amazon-RDS Dedicated Server Database

I reviewed this answer here: Mysqldump AWS RDS But apparently this did not give me any clues.

What am I going to do?

I have an RDS instance running on amazon and the database has about 450+ tables, which is an insane amount of data for mysqldump. I want it to reset so that I can transfer it from AwS to Dedicated.

What is the problem?

It freezes when I start accepting a dump through the admin. Snapshot provides a format that can be used from one region to another, but I want it to say .. SQL format (to simplify it), and then transfer it to a dedicated server.

Any ideas?

0
source share
1 answer

450+ tables, which is an insane amount of data for sqldump

Assuming you mean mysqldump , this is not an exact statement. I regularly use mysqldump for systems with 10,000 + tables and hundreds of millions of rows. Recovering data on a new server may take some time, but this is true for everything that is stored in what you called the "SQL format".

The --single-transaction in mysqldump will retrieve a consistent snapshot of all InnoDB tables; the --compress option for mysqldump will use the compressed mysql client / server protocol to reduce the time taken to retrieve data without changing the contents of the dump file; and, of course, the --events --triggers and --routines options are important.

+2
source

Source: https://habr.com/ru/post/946932/

More articles:


All Articles