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 :)
Here is my bash script:
[ec2-user@ip-xyz-xyz-xyz-xyz filestores]$ more mybashscript
if [[ ! “$(/sbin/service mysqld status)” =~ “start/running” ]]
/sbin/service mysqld start
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.
LinkedIN’s new service , inLearning, has been available with one month trial period.
I reviewed several trainings , you can definitely find something useful for you :) Give it a try!
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”
This is a great documentation to get default and maximum limits of most of the Azure services. As I have been following, it is updating through time.
You can find the brief list below.
PS: This list and limits changes.
Continue reading “Azure subscription and service limits, quotas, and constraints”
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”