microsoft azure cloud - backup service to dedicated server - start now

Suoritettu Julkaistu 3 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

hello i m using microsoft azure backup service to perform automatic daily backup on my server

a day ago db crashed and got corrupted and every file was wiped out so I used azure backup to recover db data but to my surprise the data was corrupted and had the following error :

2020-12-19T02:01:42.340805Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\[login to view URL] (mysqld 5.7.31-log) starting as process 13484 ...

2020-12-19T02:01:42.375039Z 0 [Warning] option 'innodb-thread-concurrency': unsigned value 5000 adjusted to 1000

2020-12-19T02:01:42.376415Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2020-12-19T02:01:42.377066Z 0 [Note] InnoDB: Uses event mutexes

2020-12-19T02:01:42.377518Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier

2020-12-19T02:01:42.378161Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-12-19T02:01:42.383007Z 0 [Note] InnoDB: Number of pools: 1

2020-12-19T02:01:42.383678Z 0 [Note] InnoDB: Not using CPU crc32 instructions

2020-12-19T02:01:42.387410Z 0 [Note] InnoDB: Initializing buffer pool, total size = 46G, instances = 16, chunk size = 128M

2020-12-19T02:01:45.642254Z 0 [Note] InnoDB: Completed initialization of buffer pool

2020-12-19T02:01:46.674254Z 0 [ERROR] InnoDB: Space ID in fsp header is 258, but in the page header it is 16384.

2020-12-19T02:01:46.675481Z 0 [ERROR] InnoDB: Data file '.\ibdata1' uses page size 8192, but the innodb_page_size start-up parameter is 16384

2020-12-19T02:01:46.676275Z 0 [ERROR] InnoDB: Corrupted page [page id: space=4294967295, page number=0] of datafile '.\ibdata1' could not be found in the doublewrite buffer.

2020-12-19T02:01:46.677307Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2020-12-19T02:01:46.980071Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

2020-12-19T02:01:46.981555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2020-12-19T02:01:46.982902Z 0 [ERROR] Failed to initialize builtin plugins.

i couldnt do anything about it

for the future i would like to make sure that when data is backed up that the data (especially the db data) will not be corrupted.

not an expert with microsoft azure cloud so maybe someone can be of any help ?

to be clear I only use azure cloud backup service to my own dedicated service that is all.

only apply if you have a solution to avoid this scenario in the future in an automated way preferably with existing microsoft azure cloud implementation

only apply if you can work and guide me now how to do

budget is 40$ max.

Azure MySQL Windows Server Cloud Microsoft Azure

Projektin tunnus: #28635444

Tietoa projektista

1 ehdotus Etäprojekti Aktiivinen 3 vuotta sitten

Myönnetty käyttäjälle:

usmans4

i will help i have a solution other then azure autobackup thing. you can hire me and i will apply fix immediately.

$40 USD 2 päivässä
(6 Arvostelua)
3.2