LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-17-2023, 12:40 PM   #1
finalturismo
Member
 
Registered: May 2019
Posts: 120

Rep: Reputation: Disabled
Prevent MariaDB data corruption on service start


So sometimes when i have a power outage i have an issue when i cant start the MariaDB service. Due to various reasons this happens to me time and time again and i have to restore from a backup. I need to setup a cronjob that flushed the ram back to the disk to prevent this from happening again to me again. What can i use to go ahead and flush the cache from ram to disk so that if i have an improper shutdown i can go ahead and restore from that copy without having issues.
 
Old 02-17-2023, 12:48 PM   #2
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,278

Rep: Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694Reputation: 1694
Install a UPS device that signals the server to do a safe shutdown and gives it enough time to do so.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed to start database (mariadb.service) jezo Linux - Server 5 08-28-2019 11:13 AM
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
Any way to prevent file system corruption when power is interrupted during disk write weshutchins Linux - General 8 03-22-2011 02:17 PM
[SOLVED] prevent file system corruption on hard lock-up [GOD]Anck Slackware 9 04-07-2010 05:31 PM
Prevent Linux from corruption after crash mhamro Linux - Software 7 12-18-2006 08:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:45 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration