09 Nov

Movie review: Ajab Prem Ki Gajab Kahani

Yes !! It is a Gajab Kahani, the name is perfectly chosen by the director Rajkumar Santoshi but it would have been better if he had taken a better script and had done some lessons on Direction before actually directing this one. I missed at least 20 minutes of the movie in start and it turned out to be for good. The story of the movie goes like this:

A loser called Prem live is some street. Prem likes to help others and make others happy. So he and other loser friends had made a loser club called “Happy Club” where Prem is president. Prem does not work neither his loser friends (As expected). He falls in love with a Christian girl Jeni or Jennifer which is played by Katrina. And then this story goes on without any particular path.

Later as we expected movie had a twist which is actually very straight forward, very predictable and not shocking at all. Jennie had a lover called Rahul played by Upen Patel. Rahul is child of some Politician with lots of money (as expected again). Then Rahul’s father do not agree (as expected) and then Prem did a prank type kidnap of Rahul from party. Not sure why Katrina was required in that party but she was dancing there with Ranbir, sorry Prem.

And then Prem make Rahul’s politician dad accept with another non-funny prank type setup. Then finally there a Don with prepaid mobile and limited ammo gun. The Don kidnaps Jenni and asks 10 crores. Finally Prem again saves Jenni from Don with some very unusual fight scene. After that jennie starts loving Prem and then she marries Prem. That’s IT … Thank god that story ends here itself.

Now I cannot tell you how much bad acting Katrina has done that it easily covers up Ranbir’s. Kat has shown no good comic timing and no equal facial expression. Ranbir does not actually look like looser at all. Most of the time in movie he looses his looser look and goes back to same style guru look. There has been little shown for their family but I can assure you that Prem’s parents had great comic sense and that is only part when I actually thought of laughing. The sets in the movie were pathetic and childish. I cannot really digest Don’s place in the movie, the setup at Don’s Dan was much like a Pogo TV show for kids. Actually it was funny how stupid one can try to be. Rajkumar Santoshi is not a stupid man and when he tried to be one he has done a mess. Most of the dialogs in movie are not funny at all. It looks like there has been no editing done for the movie and it just came out of actual reel. There is much more but don’t wanna right whole script here, you do understand right?

At music front, music is better when it is in CD. When the same music joins the movie it adds up to its boredom.

Movie scores low in scenes where we could have laugh riot it turns out that we had utter boredom. This happens when you try to be “Priyadarshan”.

The worst part about this movie is, being a comedy movie it does not make me laugh. Not even for few moments in the movie.

The film had lot of start point where I actually thought that this one can really pick the story up but soon it dies out with Ranbir and Kat getting into focus and ruining the movie. I waited till end of the movie thinking that at any time it can pick up but it never. Instead it just kept digging down and down and down.

If you want to know my ratings for the movie, just read my line below:

If I am a person going for the movie first time, I will quite on movies after this one.

This movie can get ½ stars or may be lower then that at my ratings.

I hope this lets you decide on if you want to go for this movie or not.

-Kaushik.

04 Nov

Buy Zune HD at Low Rates – Free Discount Coupon $15

Hi All,

I have figured out a way to get Zune HD discounted 15$ … Yes 15 $.

What you have to do is go to dell site using following coupon link below:
http://2b592ab2.linkbucks.com

Add Zune HD to your Cart
And add following coupon to get the 15$ discount

Ain’t its Easy??

Whats More?? You will get free regular shipping..

So shat are you waiting for? –>>> Go Zune 

To get Zune HD review, check out following 
http://bc73f143.linkbucks.com
(The review has not been done by me. All rights for the review is to the owner.)

I already own I-Touch, so comparison i will post here soon. :)

Thanks,
Kaushik.

04 Nov

London dreams – 2009 – xtreme Movie review

Simply tragedic, pityful, disgusting and many words… Movie is far from reality and close to cruelty.

The best thing about London Dreams is that it had an end, though nonsense, it ended.

Since beginning to end movie makes your mind ask questions… why? how?… But your curiosity dies exactly when movie starts rolling in around 10-15 mins. You feel no more curious, except to know the movie-length you have to bear.

When you consider music of the film, in first 10 mins you will hear two very familiar tunes, “zara zara” of RHTDM and “o sathi re din dube na” from Omkara(musical understanding requierd get when they appear). In rest of the movie, music meant noise, lyrics were poor and dance was a tragedy. I doubt lyrics were from Prasoon Joshi!

I have a lot to write, actually abuse, but I hope those who have seen it must be feeling that.

Story resembled written by a new-bie, and direction, and dance…!! Damn damn London Dreams…

I am so frustrated and feeling guilty of wasting my bucks and time to watch that non-sense.

Cheap story of London Dreams for free, don’t watch unless they pay you:

Since childhood Ajay wanted to be something in music, chasing his dream.

He dreams crowd tossing him up, that kinda happen in a gr8 music show.

Mean while his father and uncle opposes his passion for a stupid reason.

He prays to God for removing obstacles in his path and they showed that God removed his father!!

Later for unknown reason Om Puri went London with Ajay.

Ajay earned bucks from Salman’s(his childhood friend) gifted flute, later in movie it never pictured.

He did a road show to get popular and met Ranvir and his brother (two more tp characters of movie) and Asin( belongs to a conservative South Indian family. BTW no family had a role in this movie).

Ajay created their band, the London Dreams and went for some selection, where Asin appeared (kept on following him in whole movie) and Ajay invited her to dance :).

They got selected, got money and fame (and unknowingly exposed stupidity).

In between some timepass poor jokes filmed on Salman.
Later Salman called Ajay for his marriage in 5 days. Ajay got his marriage invite card, bought a new car and appeared in his village in 5 days from london (I don’t know if it’s possible).
Ajay decided to hide his feelings from Asin until he becomes a success with a psycho act – punishing him self by belt.

Ajay took him to London for music (Earlier they filmed that Salman just hates music, and later Salman rocked the stage :)).
They became friends and they went to some “night clubs” and “other** clubs” with Asin!!

On the very first meeting Salman proposed Asin, Asin kept on kinda flirting with them and later on strong propose she accepted to be with Salman, which was deep hurt for Ajay.

He decided to sideline Salman by making him drug addict with the help of Ranvijay and one other girl.
London Dream’s sponsor decided to abandon their tour cause of Salman’s drugg issues and other timepass. But Ajay convinced him by begging him on his knees!(!!!?? what the @#$@#4!!)

Before that Ajay and Ranvijay planned to give him drugs to keep him away from stage by sending that girl to him.

But Salman interrogated her, “who sent you, how you reached here…”, she started running and Salman (so poor) cannot catch her until they reached a lone road. Asin followed them and understood something else :) , and the drug-girl ran away. Ranvijay came there and gave drugs to Salman. Ranvijay’s brother had street-fight with him for that cheap act :).
At Wembly people kept on shouting “we want mannu… mannu”, making Ajay go mad and frustru on Salman’s fame.
Later Ajay screamed at crowed about Salman, he wont come and all that crap, booed by people. Salman appeared and an emotional drama (atyachar) started on that stage only.

After this Salman left for his hometown, and Om Puri explained Ajay for his mistakes.

They went back to hometown to sorry Salman, but with their surprise(and my WTF), Asin was there :)

And one more short emotional drama and they decided to further live the London Dreams.

–END–

My questions:
– ?
– If they were rich enough, why ajay’s father has a road side dhhaba?
– Thinking what om puri and ajay went to london?
– Om puri never wanted ajay to go in to music field, why he took him to london?
– Om puri never tried to find ajay in london?
– In london ajay grown almost 15 years older, and om puri, no age growth?
– Thinking what Ajay brought keyboard and guitar on london street performance; was he aware of other two loosly writen characters of the film?
– how do they got a drummer in their team?
– Which rock group/band have a girl only for dance? Damn!!
– Asin, from a conservative south indian family, really? Damn?
– Other than roaming around with Ajay & group, what she does in london?
– How after so many years Ajay identified Salman!!
– All night shows? Observe the filming there – when it’s in paris, every thing is dark except they showed Effil tower in the background :) same is the case when they showed Millennium Wheel/The london eye in background!!
– Wembly has a capacity of 90000, they performed in front of 25000. ~30% of capacity, but stadium filmed as a jam-packed!!?
– !!
– ??
– Asin’s father was a Limo Driver?!
– what happened to that girl who used to give drugs to Salman?
– @#$@#
– How did asin reached to village even before Ajay? With whom?
– So professional Ajay, dare to bring up personal fights on Wembly? Live? Audiance had empty water bottles :)!!!
– Crowd re-accepted them? No role of their mentor / sponsor this time?

I quit, I don’t want to as more questions..

IMDB gave 7+ Stars, many others gave 2.5/3! I’ll say it’s -10 out of 10.

I write to make people aware about good or bad things, here I’m writing for you to BEWARE.

It’s just an un-digestive movie.
I hated London Dreams.
Do not watch London Dreams.

Thanks,
Krex.

04 Nov

Quick Multi MySQL Server Installation with Master-Master Replication on Same Windows Box

This article is a brief step-by-step tutorial on the subject task which is divided into the following main parts:

  • Installing two MySQL Server Instances
  • Setting up master-slave replication
  • Setting up slave-master replication

Let’s begin covering those points…

Installing Two MySQL Server Instances on Windows:

1. Install MySQL:

  • Download MySQL Binaries from dev.mysql.com.
  • Install normal MSI Package of mysql. (I used: mysql-essential-5.0.83-win32).

* Following MSI Installation is quite easy, proceed and finish the installation.
This server will be installed on default 3306 port with all windows default settings.

2. Register/Install another MySQL instance:

To have two servers we make sure to have separate values of port, datadir etc. Please check the configuration file for according changes.

Create a duplicate of /etc/my.cnf as /etc/my2.cnf and make according changes.

mysqld-nt.exe –install “MySQL1″ –defaults-file=”C:\Program Files\MySQL\MySQL Server 5.0\my2.ini”

This will register the mysql1 service, and thus we’ll end up having two mysql instances on windows.

3. Start Both MySQL Servers:

net start mysql
net start mysql1

4. Check connecting client from command prompt:

mysql -uroot -p –port=3306
mysql -uroot -p –port=3307

* It will prompt for password, on success you will end up logging in both mysql servers.

Setting up Master-Master Replication on Windows – Single machine:

Setting up Master-Master Replication mainly consists of getting both servers to perform Master and Slave Replication Roles.

For replication I have used database named ‘master’ having table named ‘test’ with following structure:

Create database master;
Use master;
CREATE TABLE `temp` (
`id` int(10) NOT NULL auto_increment,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here we’ve two MySQL server instances, namely mysql and mysql1.

We will setup Master-Slave Replication from mysql1 to mysql. Later we will setup Master-Slave Replication from mysql to mysql1.
For your reference please check the appendix section for sample configuration files along with below mentioned instructions.

1. Setting Master Slave “mysql1 –> mysql”:

Considering:

mysql1 @ port: 3307 as Master
mysql @ port: 3306 as Slave

– On mysql1(master): Add following line to my.ini:

binlog-do-db=master

– We require a ‘Replication Slave’ privileged user on Master for slave to connect:

mysql> Grant replication slave on *.* to ‘replication1’@’localhost’ identified by ‘slave1′;

On mysql(slave):
– Add following line to my.ini:

#Conn. Pmtr for slave:

master-host = localhost
master-user = replication1
master-password = slave1
master-port = 3307

*It’s not a good idea to add such parameters in configuration file; but this is just learning purpose. Use CHANGE MASTER& command.

– Start Slave Server:

net start mysql

– On Slave Client:

mysql>Start Slave;

** Check for working Master-Slave Replication.**
** Stop both MySQL Servers **

2. Setting Slave Master “mysql1 <– mysql” :


Considering:

mysql1 @ port: 3307 as Slave
mysql @ port: 3306 as Master

– On mysql(master) Add following line to my.cnf:

binlog-do-db=master

– Start Master Server:

net start mysql1

– We require a ‘Replication Slave’ privileged user:

mysql> Grant replication slave on *.* to ‘replication2’@’localhost’ identified by ‘slave2′;

– On mysql1 (slave):
Add following line to my.cnf:

#Conn. Pmtr for slave:

master-host = localhost
master-user = replication2
master-password = slave2
master-port = 3306

– Start Slave Server:

net start mysql

– On Slave client:

mysql>Start Slave;

** Check for working Master-Slave **
** Check for working Master-Master **

And that’s it.  We now have two different instances of MySQL server running with a Master-Master replication scheme.  Hopefully, you found this tutorial helpful.  Please see examples of the final configuration files in the appendix below along with references for more information regarding this topic.

Appendix: Configuration Files for master-master mysql setup:

Following is the my.ini [configuration] file for first MySQL Server Instance:

##my.ini for mysql (Regularly installed):
[client]
port=3306
[mysqld]
server-id=2
port=3306
# Replication
log-bin=binlog
#For this as master:
binlog-do-db=master
binlog-ignore-db=mysql
binlog-ignore-db=test
#Conn. Pmtr for slave:
master-host = localhost
master-user = replication1
master-password = slave1
master-port = 3307
basedir=”C:/Program Files/MySQL/MySQL Server 5.0/”
datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/”
auto_increment_increment=1
auto_increment_offset=1

Following is the my2.ini [configuration] file for second MySQL instance named “mysql1″:

##my2.ini for Mysql1:
[client]
port=3307
[mysqld]
server-id=1
port=3307
# Replication
log-bin=binlog
#For this as master:
binlog-do-db=master
binlog-ignore-db=mysql
binlog-ignore-db=test
#Conn. Pmtr for slave:
master-host = localhost
master-user = replication2
master-password = slave2
master-port = 3306
basedir=”C:/Program Files/MySQL/MySQL Server 5.0/”
datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data1/”
auto_increment_increment=1
auto_increment_offset=2

References:

  1. http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
  2. http://dev.mysql.com/doc/refman/5.0/en/multiple-windows-servers.html
  3. http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
  4. http://dev.mysql.com/doc/refman/5.0/en/replication-options-master.html#sysvar_auto_increment_increment
04 Nov

Replication slave lag monitoring using heartbeat and windows batch scripts

“Show Slave Status” command has a last column “Seconds_Behind_Master”, which gives us idea about how much time slave is lagging behind master. It is an important to be considered parameter in monitoring and maintaining replication.

This article explains us a way to monitor replication slave lag time. It also includes a sample batch scripts to automate the monitoring process, makes it easy to understand.

Whats wrong with “Seconds_Behind_Master”:

Show Slave Status command; does shows us Seconds_Behind_Master.

Now Documentation says: The field measures the time difference in seconds between the slave SQL thread and the slave I/O thread. If the network is slow, this is not a good approximation; the slave SQL thread may quite often be caught up with the slow-reading slave I/O thread, so Seconds_Behind_Master often shows a value of 0, even if the I/O thread is late compared to the master. In other words, this column is useful only for fast networks.

Now this has been discussed at a lot of places for a lot of times, the solution is to periodically insert a row into a “heartbeat” table on the master server. Let it get replicated on slave and check the “heartbeat”s on the slave. This will surely explain you replication time and the slave behind master.

So whats the idea?

Consider descriptions of following two mysql functions:

current_timestamp() : The function when used in a query replicates its output same across the slaves. Thus even if the query is executed at a later time on slave, the value stored would be same as what is there in the master.

sysdate() : The behavior of this function is different from the above. It stores the current output of the function at the slave when executed. Thus the output produced could be different from what was produced at the master.

Considering behavior, if we have both values inserted on master server; we will get it replicated on slave. But for sysdate() function, the time will be of slave’s and that will help us calculating the slave lag comparing with current_timestamp() value.

Implementing Slave Behind Master Monitoring:

I’ve tried to implement replication slave lag monitoring through “heartbeat” method.

Here for making an example I’ve considered MySQL Server with port 3307 as Master and Server with port 3306 (Default) as Slave for monitoring Slave Lag.

Create table on Master MySQL Server:

1:
2:
3:
4:
5:
create table heartbeat
(
  master_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  slave_time TIMESTAMP NOT NULL
) ENGINE=MyISAM;

Periodical value insertion – Generate Heartbeat:

1:
insert into heartbeat(slave_time) values(SYSDATE());

One more case is, when slave is intentionally kept behind master. We can surely add up that time and make according insertion.

1:
2:
3:
Insert Into heartbeat(slave_time)
Values( from_unixtime((unix_timestamp(sysdate()) + time_to_sec('HH:MM:SS'))) ;

Here, HH:MM:SS is slave’s known time of lagging behind master.

We have following queries to monitor slave-lag:

First query will tell us the time difference of slave and master query execution time. Which is actually caused by the functions explained above.

1:
2:
3:
4:
5:
Select master_time, timediff(slave_time, master_time)
From heartbeat
Where DATE(master_time) = DATE(NOW())
Order By master_time;

This second query will tell us the time difference of last query execution time from replication to now.

1:
select timediff(NOW(), max(master_time)) from heartbeat;

Batch Scripts For Windows:

To understand above setup and making it little automated, I wrote couple of batch scripts.

Following batch script will auto insert one row into heartbeat table on per minute basis on Master.

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
##insert-master.bat
:begin
@echo off
set StartTime=%TIME%
set StartMin=%StartTime:~3,2%
:start
set EndTime=%TIME%
set EndMin=%EndTime:~3,2%
set /a Hour_Diff=StartMin - EndMin >nul
if %Hour_Diff%==0 (
goto start )
echo Beating...
mysql -uroot -pXXXX -P3307 -e "use master;insert into heartbeat(slave_time) values(SYSDATE());"
goto begin
pause

Similar batch created to monitor the lag time on Slave MySQL Server.

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:




19:
20:
21:
22:
23:
##monitor-slave.bat
@echo off
echo Observing slave delay - per minute basis
echo SBM -  Slave Behind Master / Last Query Executed.
echo ETD - Execution Time Difference
echo ----------------------------------
echo SBM  -  ETD - Slave Status
echo ----------------------------------
:begin
set StartTime=%TIME%
set StartMin=%StartTime:~3,2%
:start
set EndTime=%TIME%
set EndMin=%EndTime:~3,2%
set /a Hour_Diff=StartMin - EndMin >nul
if %Hour_Diff%==0 (
         goto start )
FOR /F "skip=1 tokens=*" %%I IN ('mysql -uroot -pXXXX -e
"use master;select TIME_TO_SEC(timediff(NOW(), max(master_time)) )
last_query_time, second(timediff(max(slave_time), max(master_time)))
master_slave_difference from heartbeat where DATE(master_time) = DATE(NOW())
order by master_time desc;"') DO set var=%%I%
@echo %var%
FOR /F "tokens=11 delims='|        '" %%G IN ('mysql -uroot -pXXXX -e "show slave status;"') do @echo                  %%G
FOR /F "tokens=12 delims='|        '" %%G IN ('mysql -uroot -pXXXX -e "show slave status;"') do @echo                  %%G
goto begin
pause

PS: Set passwords accordingly.

Using sample batch scripts we will be able to understand the replication lag.
ETD, the Execution Time Difference from master to slave shows us how long slave takes to replicate once master has executed the statement. By query we can understand it is difference between current_timestamp() and sysdate().
SBM, Slave Behind Master, points us the time in seconds last query executed on slave from master.
The monitoring script will also tell you the IO and SQL thread status after each minute.

-- Kedar Vaijanapurkar --