[mysql service drops out affecting my website]

Have you tried to figure out why the service stopped in the first place? Checked MySQL and system error logs?

Any reason you aren't using RDS?

Hello requinix,

 

I am fairly new to sql. What commands can I use to specifically look up the logs? Are you referring to Amazon RDS? I have created a website using Joomla

[mysql service drops out affecting my website]

Hi Guys,

 

I'm wondering if anyone can be of assistance. I run a website through Amazon EC2 instance with mysql. Im finding every few months my website goes down with a mysql database connection error. Upon further investigation, I find the mysql service has stopped. It requires me to simply start the service again and we are back online. I did read a document some time back about having the service restart automatically when it bombs out however im unsure how to configure this.

Is anyone able to assist or recommend what I can do to overcome this problem?

 

Mark