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…
Author: Jit
Having expertise in dynamic and interactive web applications design and development looking for a challenging position in LAMP (Linux, Apache, MySQL and PHP) environment and MySQL DBA.In depth Knowledge and experience of client/server technologies, internet/intranet based programming techniques, MVC Architecture server management and object-oriented approaches, user centered design approach.Expertise in Provides Business Solutions, Project Documentations, Architecture, Design, Functional Documentation
User Account Management
MySQL User Account Management: A MySQL account is defined in terms of a user name and the client host or host from which the user can connect to the server. The account also has a password. MySQL user names can be up to 16 characters long. Note: Operating system user names are completely unrelated to MySQL user names. MySQL passwords…
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:…
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.…
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…
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.
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…
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 .
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…
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…