MySQL

High Availability MySQL

Basic Guideline for High Availability MySQL Replication DRBD HA We are discussing DRBD HA here. So first things to go is DRBD HA Following Steps are required: Preparation of OS : DRBD Preparation OS : We need to reserve a huge physical volume which would be later used as a DRBD volume. Don’t specify any file system type. fdisk /dev/sda…

Continue Reading

MySQL

The BLACKHOLE Storage Engine

The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Retrievals always return an empty result: mysql> CREATE TABLE test(i INT, c CHAR(10)) ENGINE = BLACKHOLE; Query OK, 0 rows affected (0.03 sec)   mysql> INSERT INTO test VALUES(1,’record one’),(2,’record two’); Query OK, 2 rows affected (0.00 sec) Records: 2  Duplicates:…

Continue Reading

Linux

The cron command

The crontab command shown below will activate the cron tasks automatically on the hour: 0 * * * * wget -O – -q -t 1 http://www.jit.co.in/cron.php In the above sample, the 0 * * * * represents when the task should happen. The first figure represents minutes – in this case, on the “zero” minute, or top of the hour.…

Continue Reading

Technology

The Three Ways to Cloud Compute

  SAAS – Software as a Service Best Part Accessible from anywhere through internet Good for the collaborative environment Subscription basis can save cost instead of investing a huge money Reduce Infrastructure Cost, Maintenance Cost, etc. Need to Think Genric Application sometimes not suitable for all business But can be archive though customized plugin PAAS – Platform as a Service…

Continue Reading

Project Management

Project Open ]po[

Project Open Nice Project Management Tool; http://www.project-open.com ]po[ iPhone App available Follows PMI Guideline Good UI & Structuring But Only CVS Support! SVN Integration is on the way; no Idea on GIT Support Instead of MySQL they use PostgreSQL.

PHP, Technology

SOAP

SOAP, originally defined as Simple Object Access Protocol. It relies on Extensible Markup Language (XML) for its message format.SOAP has been adopted as the standard for Web services, and applications from major vendors have developed SOAP APIs for their products, thus making software systems integration easier. Transport methods Both SMTP and HTTP are valid application layer protocols used as Transport…

Continue Reading

Linux

Fedora 14: Wireless network is not working

Wireless Network is not working in Fedora 14 by default, here is the solution su – yum install b43-fwcutter wget Next, download the Windows driver: wget downloads.openwrt.org/sources/broadcom-wl-4.150.10.5.tar.bz2 Next decompress, extract and copy firmware to /lib/firmware directory. tar xjf broadcom-wl-4.150.10.5.tar.bz2 cd broadcom-wl-4.150.10.5/driver b43-fwcutter -w /lib/firmware/ wl_apsta_mimo.o .

Technology

REST Web Service & SOAP

Short Comparison with REST and SOAP What is a REST Web Service The acronym REST stands for Representational State Transfer, this basically means that each unique URL is a representation of some object. You can get the contents of that object using an HTTP GET, to delete it, you then might use a POST, PUT, or DELETE to modify the…

Continue Reading

MySQL

MySQL Slow Query Log

Start MySQL Server: /etc/init.d/mysqld start Syntax for /etc/my.cnf in Red Hat Family Machine : [mysqld] set-variable=long_query_time=1 log-slow-queries=/var/log/mysql/log-slow-queries.log log-queries-not-using-indexes The 2nd line under [mysqld] turns on slow query log and logs all slow queries to log-slow-queries.log in the MySQL data directory. The 1st line indicates that any queries that took more than 1 seconds to execute need to be logged. The…

Continue Reading