Backup all databases nightly w/ mysqldump This is something very useful and everybody should be doing this. Because you can’t trusted the hosting provider backup. So you should always make your own backup and here is the tools will help you make your own mysql backup with ease. #!/bin/bash DB_BACKUP=”/backups/mysql_backup/`date +%Y-%m-%d`” DB_USER=”root” DB_PASSWD=”secretttt” HN=`hostname | […]
How to Recover InnoDB Corruption for MySQL Assume you’re running MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and some pages in Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk […]
Replace MySQL with MariaDB on DirectAdmin MySQL…It seems these days everybody doing something in the IT branch has used it, or still does. However, there are some problems: you only get the fun stuff (like clustering etc) if you pay big time, its development is stalling (more and more core developers are leaving), a […]
Replicating block device with DRBD on Centos 6 How to configure DRBD on CentOS 6 DRBD® refers to block devices designed as a building block to form high availability(HA) clusters – Distributed Replicated Block Device This is done by mirroring a whole block device via an assigned network. Distributed Replicated Block Device can be understood as network based raid-1. Distributed Replicated Block […]
Flashcache on CloudLinux and CentOS and OpenVZ or SolusVM Major issue on a hosting server which serve hundreds of website is remain the same: I/O bottleneck. My curiosity began when I received a newsletter from a VPS provider in US, they said they have added SSD as filesystem cache to their server fleet. Flashcache is a […]
Convert from INNODB to MYISAM MYISAM is use by very less hosting companies now a days, as its mostly provided with the shared hosting account. But sometimes, we needed to change mysql engine, when its create a problem while exporting and importing sql data from INNODB to MYISAM engine. Steps to follow: Take backup of […]
