MySQL Forums
Forum List  »  InnoDB

Daily backing up around 1 billion records
Posted by: Frwa Onto
Date: February 15, 2018 07:01AM

We are going into an environment with roughly around 10 different shards. Each shard will generate around 100 millions of records daily. The issue now comes about data backup and retention. How best to back up this sort of data on a daily basis. Off course we want to keep this data not on the current machine but other machines. We will doing partition on the data but is it possible to keep more around 100 plus partition will be impacting the performance ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Daily backing up around 1 billion records
349
February 15, 2018 07:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.