AWS micro instances & mysqld deadlock

Hello all,

If you’re running mysql daemon on an AWS micro instance type AMI like me, you must already have undergone mysqld deadlocks day by day. I guess,   to move local mysql db to AWS RDS is the best solution in order to avoid this circumstance.

Creating a swap space is one of the solutions but you may have a limited storage on micro instances.Another solution would be to restart mysqld when it stops by cron jobs :)

crontab-syntax

Here is my bash script:

[ec2-user@ip-xyz-xyz-xyz-xyz filestores]$ more mybashscript
#!/bin/bash
if [[ ! “$(/sbin/service mysqld status)” =~ “start/running” ]]
then
/sbin/service mysqld start
fi

Don’t forget to give required permission for your bash file.

chmod +x /home/ec2-user/filestores/mybashscript 

And here is crontab (root crontab file!)You can access root crontab file by typing sudo crontab -e command

*/1 * * * * /home/ec2-user/filestores/mybashscript  –> Bash will run in every 1 minute.

That’s all, just give it a try. You can find different bash script on the Internet.

Wish you good and prosperity

Have a nice day.

 

 

 

Azure Cool Blob Storage

Please scroll down for [EN]

Artan depolama alanı ihtiyacına karşı depolama maliyetini optimize etmek için bulut tabanlı depolama servisleri avantajlıdır. Azure blob storage servisine yakın zamanda eklenen cool & hot özelliği ile, sıkça erişilen veriniz ile sıkça erişilmeyen verinizi ayırarak depolama maliyetinizi daha da optimize edebilirsiniz. Azure üzerinde storage account’u oluştururken belirlediğiniz Cool niteliğindeki verinizin maliyeti oldukça düşük oluyor.

Ör: Gigabyte/Ay maliyeti 0.01 USD ‘dir.

Daha detaylı göz atmak isterseniz aşağıdaki tabloyu inceleyebilirsiniz*

Continue reading “Azure Cool Blob Storage”

JackDB – Direct SQL access

Greetings!

While I was evaluating an AWS Redshift lab on qwikLABS, the lab directed me to connect to Redshift cluster by using JackDB which is a hosted service that can be used as a secure client software to connect to cluster in order to run queries . Thus, you are able to query your database by using a 3rd party client software.

If you are seeking a service like JackDB, all of the plans come with 14-days free trial.

Before adding a data source to JackDB dashboard, make sure that you have already configured the AWS security group which allows the incoming connection that is initiated from JackDB IP’s.

In addition to this, you can undoubtedly use it to connect to Azure SQL service as well. I have added a data source which is hosted on Azure SQL.

Continue reading “JackDB – Direct SQL access”