Archive

Archive for April, 2012

Configure Master / Slave Replication MySQL XAMPP

April 24, 2012 1 comment
Mysql Master Server Configuration
First Lets go to Replication panel on XAMPP.
Screenshot at 2012-04-24 02_13_51
Next Select Configure as Master
Screenshot at 2012-04-24 02_14_03
You can configure Replication as ALL or Selective. I have done selective where I select few DBs to Replicate.
Once you are done you need to add the lines below in the my.cnf file.

# ***** Added Lines here ****
server-id=4745869
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=saggezza_cats,saggezza_catstesting
# ***** Till Here ****

Here are Ignoring all the DBs for Replication except the two above.
Screenshot at 2012-04-24 02_21_40

Go to /opt/lampp/etc/my.cnf


Screenshot at 2012-04-24 02_22_11
Added the lines as I mentioned above above. Also Make sure “max_allowed_packet = 16M”

Screenshot at 2012-04-24 02_23_07
Screenshot at 2012-04-24 02_23_16
Make sure to comment out he existing server-id as we have already given above.
Screenshot at 2012-04-24 02_23_39
Restart XAMPP

$ sudo ./opt/lampp/lampp restart

Screenshot at 2012-04-24 02_24_02
Once you restart XAMPP, you can see that Mysql Server is started as Master.
Screenshot at 2012-04-24 02_24_15
Next Lets Create a Replication user and give it privileges as the slave needs this information to connect to the Master.
Screenshot at 2012-04-24 02_24_40
I have given root but you can give any username you want.
Screenshot at 2012-04-24 02_25_13

MySQL Slave Configuration 
First lets add Server-id to our slave as mentioned.

server-id=9384593

Screenshot at 2012-04-24 02_28_29
Screenshot at 2012-04-24 02_29_29
Now lets connect to Master.
Screenshot at 2012-04-24 02_30_08
You will get a confirmation about he successful connection to Master.
Screenshot at 2012-04-24 02_30_20
Now we need to start SLAVE I/O and Sql Threads.
Screenshot at 2012-04-24 02_31_07
They are right under “Control Slave” as below
Screenshot at 2012-04-24 02_31_28
Now you can see the threads running.

NOTE: If you face any issues getting the threads started then please check logs. In my case IO Thread was not starting. When I checked the log I found that I had two server-id’s in the my.cnf file. Also sometimes you will get IO error due to max_allowed_packet as well, as this is by default set to 1MB, which needs to be around 16MB.

/opt/lampp/var/mysql/mysql-bin

Screenshot at 2012-04-24 02_31_37
Now we can see all the DBs in Replication Mode. Now any Updates to Master will reflect on the slave.
Screenshot at 2012-04-24 03_24_28
This will have the MASTER-SLAVE for Mysql Server is Ready.
Enjoy.

Categories: HOWTOs

Configure Master / Slave Replication MySQL XAMPP

April 24, 2012 4 comments

Mysql Master Server Configuration

First Lets go to Replication panel on XAMPP.

Screenshot at 2012-04-24 02_13_51

Read more…

Mobiles in INDIA – Google Trends and Google Public Data

April 18, 2012 Leave a comment

I was looking into the Mobile Trends in INDIA. There are as many as 650 million Mobile user in India. We are adding 9 million(approx) new users every month. Below is a look at how INDIA Mobile market fairs according to Google Trends and Google Public Data.

First Lets start at looking in to Mobile Phones in India.

Below are the details I got from my friend.

GSM SUBSCRIBER FIGURES FEBRUARY-2012

  • Total number of GSM Subs  as of February 2012 – 656.86 million
  • Total number of GSM Subs  additions in February 2012 –  8.77 million with 1.35% increase from previous month
  • Maximum GSM Subs addition in the month of February by – Idea – 2.58 million
  • Maximum GSM Subs addition in the month of February in – Maharashtra – 1,002,729 i.e 11.42% of the total Subscriber additions in February
  • Maximum GSM Subs  – Airtel – 178.78 Million

Lets Look into Google Public Data to see How INDIA has faired in the last few years against China.

US has reached its Saturation Point now as most of the users in US have a mobile. INDIA have not reach 100% Population yet and is around 65% mark. By 2025 we might reach 100% Mobile users in INDIA. By 2035 – 120% (20% Population will have 2 phones) of the population might have a Mobile Phone. That is around 1.4 – 1.5 billion users in INDIA alone. Now That is HUGE. (looking at Google Forecast on Indian Population – by the way we will surpass China by around 2035)

Forecast : Google Forcast INDIA Mobile Users

Google Public Data : Public Data Till 2010 – India, China, US

Read more…

NFC and Geo-Fencing

April 18, 2012 1 comment

Well I was looking into Potential NFC Benefits or use cases which we can use it for. Few of the first primary target is the Financial Sector. Most of the usecase are about Mobile Money. (like the Google Wallet). First I was very much interested/excited in the Mobile Money kind proposition, slowly came to realization that it has too many overheads. You need to sync up with a BANK, then Involve Retailers, etc etc too much of hassle if you take the INDIAN Market.

Read more…

Categories: Internet Tags:

Mobiles in INDIA – Google Trends and Google Public Data

April 18, 2012 Leave a comment
I was looking into the Mobile Trends in INDIA. There are as many as 650 million Mobile user in India. We are adding 9 million(approx) new users every month. Below is a look at how INDIA Mobile market fairs according to Google Trends and Google Public Data.

First Lets start at looking in to Mobile Phones in India.
Below are the details I got from my friend.

GSM SUBSCRIBER FIGURES FEBRUARY-2012

  • Total number of GSM Subs  as of February 2012 – 656.86 million
  • Total number of GSM Subs  additions in February 2012 –  8.77 million with 1.35% increase from previous month
  • Maximum GSM Subs addition in the month of February by – Idea – 2.58 million
  • Maximum GSM Subs addition in the month of February in – Maharashtra – 1,002,729 i.e 11.42% of the total Subscriber additions in February
  • Maximum GSM Subs  – Airtel – 178.78 Million

Lets Look into Google Public Data to see How INDIA has faired in the last few years against China.

US has reached its Saturation Point now as most of the users in US have a mobile. INDIA have not reach 100% Population yet and is around 65% mark. By 2025 we might reach 100% Mobile users in INDIA. By 2035 – 120% (20% Population will have 2 phones) of the population might have a Mobile Phone. That is around 1.4 – 1.5 billion users in INDIA alone. Now That is HUGE. (looking at Google Forecast on Indian Population – by the way we will surpass China by around 2035)





Now Lets Looking into Google Trends. On How INDIANS are looking into Smartphone and other Phones. What we can see in coming years.

Smartphone has Increased after iPhone and Android. And might keep growing. Unless we have a newer better invention than a mobile phone. Which is not likely to happen I think in next 10years. 🙂 



Non-Smartphone has not lost mush (A slightly hit but Not much) even though we have an increased Interest in Smartphones above.


While we are at it. Lets look into NFCs (Near Field Communications) in Google Trends. 
NFC has start of well around 2010 – NFCs has been well before that. I think NFC will grow for sometime now and might go down as we go into GeoFencing Mode. 


GeoFencing has started to get interesting and has good potential in the area/regions where smartphones are very common. GeoFencing as well will start from the US, Europe, Japan, regions as the smartphones have larger peace of the pie.

Thats it for now. Will post as I find more into Analytic, which Interests me now a days. 🙂
With Ever growing trends there is lot to Analyze. 

Bye.

Categories: Internet

NFCs and GeoFencing

April 18, 2012 Leave a comment

Well I was looking into Potential NFC Benefits or use cases which we can use it for. Few of the first primary target is the Financial Sector. Most of the usecase are about Mobile Money. (like the Google Wallet). First I was very much interested/excited in the Mobile Money kind proposition, slowly came to realization that it has too many overheads. You need to sync up with a BANK, then Involve Retailers, etc etc too much of hassle if you take the INDIAN Market.

Here are few things which I think can be used other than Financial Sector.
– NFC card for getting into your hotel room. 
– NFC enabled Phone as your car keys. 
– your business card.
– your public transportation.
– concert, sports or other event tickets.
– your boarding pass for getting on a plane. 
– coupons and Many more.
Then I came across an article, quite interesting.
Well-known entrepreneur and investor and former Google SA boss Stafford Masie believes near-field communication (NFC) technology will fail as a mainstream transactional platform and local banks’ attempts to implement systems based on it are “farcical” and offer “no value”
Masie Proposes about new Technology called GeoFencing.  But this is again catering to the SmartPhones.
(fyi – INDIAN NON SMARTPHONE market is around 70% of the total Mobile Market – though Smartphone Market is increasing, non-smartphone market has not seen a slump – will post Analysis on this)
GeoFencing.
Geo-fencing creates virtual perimeters around a merchant and if someone is within that perimeter with a supported device (usually a smartphone) then a transaction can take place, but without the need for any need to swipe a card or establish contact between a device and reader. They simply pay with their presence and their face appears on the merchant’s point of sale terminal with their name.
A celebrated example of geo-fenced payments is Square Card Case (video below), which runs on the iPhone and Android-based smartphones. It reads a repository of geo-fenced merchants on a map and allows users to permit merchants to withdraw money electronically from their wallets.

Categories: Internet

Installing OpenNMS on CentOS – using RPM.

April 13, 2012 Leave a comment
As from my previous post. This again is for the IT Team. Was helping them setup and network Monitoring tool.

Here are the step to follow to install OpenNMS.

Step 1: configure theOpenNMS Repository RPM
]# yum install yum-fastestmirror
Categories: How To