NYCPHP Meetup

NYPHP.org

[nycphp-talk] mysql slow Internet connection trickery

Anirudh Zala arzala at gmail.com
Sun Jul 6 02:25:25 EDT 2008


On Saturday 05 Jul 2008 23:37:20 Edward Potter wrote:
> Can you take advantage of a bunch of PCs with EDVO cards?  Remove the
> bandwidth issue from the equation?
>
> ------
> Paraguay's mobile sector is far more dynamic. New investment and
> competition are leading to exceptional growth in the take-up of mobile
> services and innovative new mobile services. There are four major
> mobile operators offering mainly GSM/GPRS services. They are Telecel
> (Millicom), Hola (KDDI), Personal (Telecom Argentina) and CTI Movil,
> (Amercia Movil).
>
> The broadband sector is directly benefiting from these trends. Since
> 2001, several mobile operators have been implementing wireless
> broadband options (WiFi and WiMAX technologies) that since mid-2007,
> provide a serious alternative to fixed line broadband services. In the
> near future, Paraguay's ISPs are predicted to serve more homes and
> businesses via wireless broadband than ADSL.

I was thinking on same line. In developing countries like India, China, Brazil 
and other Latin american and African countries where purchasing PC, Internet 
connection etc. could be costly and sometimes not feasible, Using mobile 
services like SMS etc. can be very helpful.

Although my suggestion is not direct solution of your problem, but if you have 
control over design of your application, you can use use Mobile services to 
handle dynamic operations of your websites such as booking/canelling rooms 
and making requests which are bound to create conflict when internet is 
slow/down.

Hence you can put static data on website which may not effect slow connection 
like display of rooms/rates/information about hotel etc., and use mobile 
services (like sending SMS to book room) whenever dynamic operation is 
required.

This kind of solutions are being very popular in developing countries because 
mobile costs < 50$ and you can use it from anywhere as far as network is 
there.

Thanks

Anirudh Zala

>
> http://point-topic.com/content/operatorSource/profiles2/paraguay-broadband-
>overview.htm
>
> On Sat, Jul 5, 2008 at 12:58 PM, Hans Zaunere <lists at zaunere.com> wrote:
> >> > You may want to consider using web services.  Data would be stored in
> >> > a local MySQL database, and then as you mention, a central server
> >> > aggregates the data from all the locations.
> >> >
> >> > The reason I mention web services, is that HTTP is typically more
> >> > robust over flakey connectivity than database protocols are.
> >>
> >> Hans, have you seen something like this in production? It seems like a
> >> great open source project that could become part of MySQL's lineup,
> >> for use in exactly the type of situation that Allen describes.
> >>
> >> MySQL Master <--> HTTPS Transaction Broker <--> Remote MySQL Cache
> >>
> >> It's kind of the same architecture that Gears wants to put you in on
> >> the client: you keep a local copy of all the data that's important to
> >> you, synchronized whenever you are online with the main database. The
> >> pattern is everywhere, but I've never seen a tool that was
> >> purpose-built to do this between MySQL instances.
> >
> > I haven't seen a general purpose tool for this type of thing, but have
> > seen the same architecture done in a couple of places.  For example,
> > desktop patch level tracking and location tracking for trains.
> >
> > The caveat to all of this is the complexity of the data.  As data
> > increases in complexity, conflict resolution gets more difficult on the
> > aggregating web service.  And perhaps more importantly, the actual
> > XML/POST/GET/etc actions that transmit the data between remote and
> > central location can grow quickly and be complex to parse/structure
> > themselves.
> >
> > But as you mention, the pattern is good/growing, and useful wherever
> > connectivity can't be guaranteed, or is known to be intermittent.  HTTP
> > is a good fit because of its asynchronous nature, whereas database
> > protocols are often latency and connectivity sensitive.  But with a
> > flexible framework, the purpose specific logic could be dropped in where
> > needed, and this would be an interesting project.
> >
> > H
> >
> >
> > _______________________________________________
> > New York PHP Community Talk Mailing List
> > http://lists.nyphp.org/mailman/listinfo/talk
> >
> > NYPHPCon 2006 Presentations Online
> > http://www.nyphpcon.com
> >
> > Show Your Participation in New York PHP
> > http://www.nyphp.org/show_participation.php





More information about the talk mailing list