8 Replies Latest reply: Dec 31, 2012 9:51 AM by Charles Lamb RSS

    Backups best practices

    Aris Prassinos
      Charles

      Can you point me to some backups best practices for very large databases?
        • 1. Re: Backups best practices
          Charles Lamb
          Have you looked at the [http://docs.oracle.com/cd/NOSQL/html/AdminGuide/Oracle-NoSQLDB-Admin.pdf] ?

          Charles
          • 2. Re: Backups best practices
            Aris Prassinos
            Yes, but would snapshots work for 50TB databases?
            Is there an incremental backup capability?
            • 3. Re: Backups best practices
              Greybird-Oracle
              Have you considered that replication also provides a form of backup?

              --mark                                                                                                                                                                                   
              • 4. Re: Backups best practices
                Charles Lamb
                The snapshots are just file system links. Presumably the 50TB is spread across multiple shards based on your performance requirements.

                Charles
                • 5. Re: Backups best practices
                  Aris Prassinos
                  Given that Cassandra offers incremental backups in addition to link based snapshots
                  what are your thoughts on this incremental capability?
                  • 6. Re: Backups best practices
                    Greybird-Oracle
                    Incremental backups are not currently supported in NoSQL DB, as I think you know. The fact that Cassandra supports incremental backups is not in itself a reason we should make this a high priority feature for a future release. If you can describe more about how you would use this feature, it would help us to prioritize. For example:

                    - are you going to backup your entire data set?
                    - how large is it?
                    - on what media?
                    - what replication factor are you using (the default is 3) and why is replication insufficient as a backup?

                    Thanks,
                    --mark                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                    • 7. Re: Backups best practices
                      Aris Prassinos
                      - are you going to backup your entire data set?
                      Yes

                      - how large is it?
                      Up to 300 TB

                      - on what media?
                      Disk-to-Disk-to-Tape

                      - what replication factor are you using (the default is 3) and why is replication insufficient as a backup?
                      Replication factor of 3.
                      Backups have to be stored to tape and then moved offsite.
                      • 8. Re: Backups best practices
                        Charles Lamb
                        Hi Aris,

                        So it's a pretty standard backup procedure that you're talking about. That makes sense.

                        How many shards do you have (i.e. how is the 300TB split up)?

                        I can understand the need for incremental backup and we have talked about it in the past.

                        We'd love to hear about your deployment. Feel free to email me or Ashok (charles.lamb or ashok.joshi) @ o.com if you want to discuss it.

                        Charles