Skip to content

Trying to restore to master #194

@CodeBleu

Description

@CodeBleu

Is it possible to restore a backup back to the main node? I've tried to use the API to restore, but it wouldn't work. I manually edited the myhoard_controller_state.json file in the state directory to change from active to idle and then run a curl command to do a restore.

I get a "phase": "failed", after it copies all the prefetch files in my /var/lib/mysql dir.

last log entry is:
Nov 14 15:17:05 jwh-srlinux-lab bash[1687267]: 2024-11-14 15:17:05,611 BinlogDownloader INFO 'default/2024-11-14T03:00:00.647931+00:00Z_01ac71e7-46ed-43f5-8b33-e7f93f58f0ee/binlogs/0/131_1' successfully saved as '/var/lib/mysql/relay.000221.prefetch' in 0.04 seconds
status is

curl -s -XGET -H "Content-Type: application/json" http://localhost:16001/status | jq
{ 
"mode": "restore"
}

curl -s XGET -H "Content-Type: application/json" http://localhost:16001/status/restore | jq

{
  "basebackup_compressed_bytes_download": 0,
  "basebackup_compressed_bytes_total": 1644805,
  "binlogs_being_restored": 0,
  "binlogs_pending": 221,
  "binlogs_restored": 0,
  "phase": "failed"
}

@packi I see you're active right now. Just wondering if you could help me figure this out? I'm new to this myhoard, but would really like to figure out how to get it to work.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions