iPXE is the leading open source network boot firmware. It provides a full PXE implementation enhanced with additional features such as:
boot from a web server via HTTP
boot from an iSCSI SAN
boot from a Fibre Channel SAN via FCoE
boot from an AoE SAN
boot from a wireless network
boot from a wide-area network
boot from an Infiniband network
control the boot process with a script
Monthly Archives: January 2015
MySQL downtime: Set max_user_connections
Fix: ERROR 1040 (00000): Too many connections
GRANT USAGE ON *.* TO ‘batchjob1’@’localhost’ WITH MAX_USER_CONNECTIONS 10;
Failed to execute ‘write’ on ‘Document’: It isn’t possible to write into a document from an asynchronously-loaded external script unless it is explicitly opened
Failed to execute ‘write’ on ‘Document’: It isn’t possible to write into a document from an asynchronously-loaded external script unless it is explicitly opened
jsapi:21 Failed to execute ‘write’ on ‘Document’: It isn’t possible to write into a document from an asynchronously-loaded external script unless it is explicitly opened
Usually it means it can be DNS related issues or firewall, please check /etc/resolv.conf
Ghost for Unix
G4U is an operating systems independent application that can be used for disk cloning. It boots either of disks or LiveCD – and then allows you to copy all of the content from a harddisk to a remote server or other local disk or partition. Mainly built for distributing similar images across a network of computers, but can be used for backup purposes as well.
dm-0 device?
The device mapper is a Linux kernel’s framework for mapping physical block devices onto higher-level virtual block devices.
mysql copy table
CREATE TABLE new_table LIKE old_table;
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’
alter table table_name convert to character set utf8 collate utf8_general_ci;
SQL round after division
ROUND(value/100, 2)
mysql delete table values
truncate table_name;
or
delete from table_name; # will not reseting the autoincremental id
copy block device over ssh
ssh root@remote_server "dd if=/dev/vda " | dd of=/root/remote_vda.img
mkdir /mnt/fs
mount -o loop /root/remote_vda.img /mnt/fs
ls -la /mnt/fs
or maybe you should use rsync if available:
rsync -vP --inplace --copy-devices root@remote_server:/dev/vda /root/remote_vda.img
mysql avoid table lock during backup
mysqldump –lock-tables=false