Kedar

Still have MySQL 5.6 variable binlog_error_action as IGNORE_ERROR?

Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check failed to verify a MySQL master’s binary log coordinates. My colleague working from the other side of the globe observed the following: mysql> show master status; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are not using binary logging Interestingly, the...

mysql database backup shell script with status email

This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the backup to specified offsite location. – Upon detecting failure in any of the above step, it will send out failure email. – Upon overall success, it will sendout success email with execution time and present backups list. You might be looking for setting up physical...

दुर्गे दुर्घट भारी – श्री देवीची आरती | Aarti Durge Durghat Bhari | Marathi

दुर्गे दुर्घट भारी – श्री देवीची आरती Durge Durghat Bhari दुर्गे दुर्घट भारी तुजविण संसारी ।अनाथनाथे अंबे करुणा विस्तारी ॥वारी वारीं जन्ममरणाते वारी ।हारी पडलो आता संकट नीवारी ॥ १ ॥ जय देवी जय देवी महिषासुरमथनी ।सुरवरईश्वरवरदे तारक संजीवनी ॥ धृ. ॥ त्रिभुवनी भुवनी पाहतां तुज ऐसे नाही ।चारी श्रमले परंतु न बोलावे काहीं ॥साही विवाद करितां पडिले प्रवाही ।ते तूं भक्तालागी पावसि लवलाही ॥ २ ॥ जय देवी जय देवी महिषासुरमथनी ।सुरवरईश्वरवरदे तारक संजीवनी ॥ प्रसन्न वदने प्रसन्न होसी निजदासां ।क्लेशापासूनि सोडी तोडी भवपाशा ॥अंबे तुजवांचून कोण पुरविल आशा ।नरहरि तल्लिन झाला पदपंकजलेशा ॥ ३ ॥ जय देवी जय...