• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here: Home » Autostart MySQL After a Crash : Solve WordPress Database Connection Error

By Abhishek Ghosh November 29, 2018 6:56 pm Updated on November 29, 2018

Autostart MySQL After a Crash : Solve WordPress Database Connection Error

Advertisement

WordPress Error establishing a database connection is frequently faced problem. In our previous guides, we pointed to properly configure my.cnf, that is adding [mysqld_safe] stanza at the end of my.cnf file with socket, PID. For newer versions of MYSQL, we written guide for Percona MySQL to auto-restart. Newer Ubuntu, Debian installations do not automatically create the required debian-sys-maint user for restart. In that installation guide, we tried address it. However, still MySQL may fail to auto restart after a crash! Here is one fallback way to autostart MySQL after a crash.

Autostart MySQL After a Crash

 

Autostart MySQL After a Crash : Reasons of Failure

 

Unfortunately, MySQL may start to fail depending on the error the crash happened!. In the above paragraph, we described one type of errors in configuration and absense of the required user to execute the work.

Corrupt MySQL binary can cause the MySQL server to fail. Ownership and permissions of the MySQL files such as binaries, logs may get itself changed during a version upgrade, which may lead to errors. The /tmp directory should be checked for permission, space. Lack of disk space, not enough memory may fail the automatic restart process. A badly coded WordPress plugin may create odd situation. Self hosted analytics plugins may invite trouble.

Advertisement

---

 

Autostart MySQL After a Crash : Fallback Bash Script and Cron

 

Depending upon your situation, a fallback bash script and cron job to execute the script may act as additional layer for peace when chance to manually check the site too longer! You’ll notice during upgrades that Percona identifies ownself as :

Vim
1
2
3
percona-server-client-x.y
percona-server-common-x.y
percona-server-server-x.y

That often create confusion during complete removal (for re-installation). However, general purpose command :

Vim
1
/etc/init.d/mysql status

… works for all kind of MySQL forks. Compare the difference after running the above and below commands :

Vim
1
service mysql status

If you run :

Vim
1
ls -l /etc/rc2.d | grep mysql

You’ll get response like below :

Vim
1
lrwxrwxrwx 1 root root  15 May 28  2017 S03mysql -> ../init.d/mysql

This symlink to MySQL’s init script in the /etc/rc2.d directory. The S script under the default runlevel directory for the service, init will start the service when the server will be rebooted. Manual reboot of server from mobile devices can be an emergency life-saver in acute emergencies.

Now run these commands :

Vim
1
ps -ef | grep mysql

You’ll get output something like :

Vim
1
2
root     29795     1  0 17:18 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql    30182 29795  0 17:18 ?        00:00:04 /usr/sbin/mysqld

The number beside the username is PID. mysqld_safe and mysqld. mysqld_safe has process IDs 29795 and 30182 respectively. We can kill them to emulate crash :

Vim
1
2
sudo kill -9 29795
sudo kill -9 30182

Now, if you run :

Vim
1
/etc/init.d/mysql status

You’ll get MySQL is stopped.. message. Of course you can get rid of test crash to normal situation by the command :

Vim
1
2
service mysql restart
# /etc/init.d/mysql restart

You can check by running :

Vim
1
sudo systemctl status mysql.service

Now if we create a bash script named safe.sh kept on my GitHub repo and then make it executable :

Vim
1
chmod +x safe.sh

Then, executing the script should restart MySQL after simulating crash :

Vim
1
sh safe.sh

It will brutally start MySQL. If a service does not exist, we can start by adding and entry on cron (sudo crontab -e), like for example service named nothing.service (it is every minute checking for example) :

Vim
1
* * * * * /bin/systemctl status nothing.service > /dev/null || /bin/systemctl start  nothing.service

Instead of nothing.service, using mysql.service should start MySQL. Easy way to remember cron :

Vim
1
1 2 3 4 5 /root/script.sh

Where :
1 -> Minute (0-59)
2 -> Hours (0-23)
3 -> Day (0-31)
4 -> Month (0-12 [12 == December])
5 -> Day of the week(0-7 [7 or 0 == sunday])
/root/script.sh – Script with path

If that normal restart fails then try that bash script :

Vim
1
* * * * * /bin/systemctl status mysql.service > /dev/null || /root/safe.sh

If the /bin/systemctl status mysql.service || logic fails then you need another bash script to curl, cut, grep “eroor database” like keyword from home page and fire it. Now various methods will be timed in a way that no method keeps server down for more than 30 minutes.

Tagged With constantlyl3w

This Article Has Been Shared 576 Times!

Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Autostart MySQL After a Crash : Solve WordPress Database Connection Error

  • Best Tools For Web Server Log Processing & Statistics Running WordPress

    Commonly We Run One Server One WordPress Website Setup. Here Are Some Best Tools For Web Server Log Processing & Statistics Running WordPress Which Are Self-Hosted.

  • Scalable MySQL Database for WordPress with Rackspace Cloud

    Scalable MySQL Database for WordPress is very easy to create as Rackspace allows Cloud Database,so does Amazon. Here is a guide for high performance WordPress.

  • Installing WordPress on Free OpenShift PaaS

    Installing WordPress on Free OpenShift PaaS can be a free way for installing self hosted WordPress. This is a long, detailed video to startup using WordPress.

  • How to Include Jupyter Notebooks in WordPress Posts

    How to Include Jupyter Notebooks in WordPress Posts? There Are Several Ways. It Depends on What Exactly Your Blogs Are About.

  • Configure Apache Tika With WordPress to Search, Get Meta of PDF/Doc Files

    Apache Tika Can Be Combined With PHP. Here is How to Configure Apache Tika With WordPress to Search, Get Meta of PDF/Doc/Excel/Text and Other Type of Files.

Additionally, performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • What is Configuration Management February 5, 2023
  • What is ChatGPT? February 3, 2023
  • Zebronics Pixaplay 16 : Entry Level Movie Projector Review February 2, 2023
  • What is Voice User Interface (VUI) January 31, 2023
  • Proxy Server: Design Pattern in Programming January 30, 2023

About This Article

Cite this article as: Abhishek Ghosh, "Autostart MySQL After a Crash : Solve WordPress Database Connection Error," in The Customize Windows, November 29, 2018, February 6, 2023, https://thecustomizewindows.com/2018/11/autostart-mysql-after-a-crash-wordpress/.

Source:The Customize Windows, JiMA.in

PC users can consult Corrine Chorney for Security.

Want to know more about us? Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT