mysql

Auto Restart MySQL When It Crashes Ubuntu 18.04

Good Day, long enough not blogging on this site. This is my problem when I’m moving some websites into my cloud servers. Sometimes when my traffic going very high MySQL server crashes and I need to run it manually or reboot my server. This is really bad for SEO because my servers uptime will changed.

I am googling about this problem to find solution for resolve this issue and finally I found one is working for me.  Here is the steps you need to follow :

Read More »Auto Restart MySQL When It Crashes Ubuntu 18.04

Auto Backup MySQL Database

Data is important thing in company or organization. People who can’t protect their data is the loser this day. Can you imagine you lost all your data for works? it just like a heaven go away from you he he.. This happen to me yesterday and I lost 1 month production data caused by bad electrical environment. In this short articles I will share a small information how to backup your data periodically. I am using windows server and xampp to run every automation so I will write how to backup MySQL database periodically. First thing you need to know,… Read More »Auto Backup MySQL Database

How To Fix WordPress Database Error

If you are using wordpress or other cms and have a lot of data in you sql, your site usually will unavailable with common message database error. What actually error on your database? Nothing, this is all about query limitation on your hosting. Your blog will grown in time, say in the last months you got 10,000 readers and in the next month you got 1,000,000 readers. When people access your site it’s continuously reading data again from your database, when it to much some hosting will stop it to executed. This is not good for SEO because your potential… Read More »How To Fix WordPress Database Error