Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 149 Next 30 Older Entries

Displaying posts with tag: Web (reset)

Use MySQL API Extensions to Create Dynamic Web Pages
Employee_Team +0 Vote Up -0Vote Down

To create dynamic web pages, you can use PHP, a server-side, HTML-embedded scripting language. PHP is available for most operating systems and can access the MySQL database. PHP provides MySQL API extensions, MySQL Improved Extension and MySQL Functions.

To learn more about using MySQL and PHP, you can consult the MySQL and PHP reference manual. You can also take the MySQL and PHP: Developing Dynamic WebApplications training course.

Through a hands-on approach, this 4-day instructor-led course

  [Read more...]
Join Companies in Web and Telecoms by Adopting MySQL Cluster
Employee_Team +0 Vote Up -0Vote Down

Join Web and Telecom companies who have adopted MySQL Cluster to facilitate application in the following areas:

Web:

  • High volume OLTP
  • eCommerce
  • User profile management
  • Session management and caching
  • Content management
  • On-line gaming

Telecoms:

  • Subscriber databases (HLR/HSS)
  • Service deliver platforms
  • VAS: VoIP, IPTV and VoD
  • Mobile content delivery
  • Mobile payments
  • LTE access

To come up to speed on MySQL Cluster, take the 3-day MySQL Cluster training course. Events already

  [Read more...]
Setting up WordPress on Debian/Ubuntu running Tengine web server
+0 Vote Up -0Vote Down

I will change my host provider within a month. I’ve been using Midphase for several years and have decided to use Linode as my next virtual private service provider. I will move this site there in the next few weeks. This will be my first time moving a domain and I hope the transfer will be smooth without too much down time. After all, I know my readers worldwide are hanging on to every word I type and deserve a site that runs 24 by 7

Since I will have total control of this host, I decided to use Tengine, a great fork of the Nginx web/proxy server. Here is my note on how to compile and config Tengine on Debian/Ubuntu, and then setup WordPress. During my study and testing, the following sites are pretty

  [Read more...]
MySQL and PHP as a Foundation for Web Applications
Employee_Team +1 Vote Up -0Vote Down

Learn to design web-based applications with MySQL and PHP - Developing Dynamic Web Applications. In this 4-day live, instructor-led class, you will learn to:

  • Design schemas based on MySQL
  • Use include files to make code easier to maintain
  • Use PHP 5 and takes advantage of its advanced features
  • Build applications following a precise flow
  • Authenticate users in a secure way against a database
  • Handle errors in your PHP applications efficiently and gracefully
  • Writes composite queries using JOINs and subqueries
  • Use indexing efficiently in order to manipulate large amounts of data
  [Read more...]
MySQL Web Reference Architectures: On Demand
Employee_Team +2 Vote Up -0Vote Down

Last week we ran a live webinar presenting the new MySQL Web Reference Architectures (http://www.mysql.com/why-mysql/white-papers/mysql-reference-architectures-for-scalable-web-infrastructure/), a set of documented and repeatable best practices for building highly available, scaleable and secure database infrastructure to power new generations of web and mobile services.

The webinar replay is now available on-demand (http://www.mysql.com/news-and-events/web-seminars/mysql-reference-architectures-best-practices-for-web-mobile-cloud-applications/) so you can listen in from the comfort of your own desk…or commute.

As a taster - we discuss sizing and design patterns - you can see a sample below:



  [Read more...]
Adzuna Relies on MySQL to Support Explosive Growth
Employee_Team +3 Vote Up -0Vote Down

Adzuna is a fast growing search engine for classified ads specialized in jobs, properties and cars. Headquartered in the UK and launched in 2011, Adzuna searches thousands of sites and tens of millions of ads to make it very easy to find the perfect job, home or car locally. It furthermore provides a wealth of statistics such as salaries trends graphs and comparisons, geographic jobs maps, house prices...and more. Additionally, Adzuna is integrated with Facebook and LinkedIn and shows open vacancies one is connected to through his/her own network. The search engine powers a number of government applications and is integrated into the UK's Prime Minister economic dashboard.

Challenges

  • When Adzuna's founders were selecting the database powering the search engine's architecture, they were planning for


  [Read more...]
jQuery, PHP and CSS.. NetBeans IDE Still Rocks..
+1 Vote Up -1Vote Down

Recently, got an opportunity to do some implementation using Ajax and PHP. Having previously used NetBeans IDE 6.1/6.5 for PHP, it was an obvious choice to come back to NetBeans IDE again.

Although, I am yet to download the latest version, I am currently using 6.8 and I enjoyed every bit of it, while playing with CSS and jQuery for the first time, while implementing Ajax with PHP.

As I am gonna stay with PHP for sometime now, so I guess I better get my NetBeans IDE upgraded, before I miss out on any useful features.

It’s good to be back :)


Filed under: MySQL, NetBeans, PHP, Web
  [Read more...]
Site update with a welcome news
+0 Vote Up -2Vote Down

As I updated my website, migrating from Drupal to WordPress, a welcome news followed in the evening when Swansea beating Manchester City 1-0. The female assistant to the referee, Sian Massey, gladly judging Micah Richards for an offside. United had a rough time taking over WBA, but ensuring a relatively comfortable 2-0.

Where Would I Use MySQL Cluster?
Employee_Team +0 Vote Up -0Vote Down
0 0 1 910 5191 Homework 43 12 6089 14.0 Normal 0 false false false EN-US JA X-NONE

0 0 1 881 5025 Homework 41 11 5895 14.0 Normal 0 false false false EN-US JA X-NONE

  [Read more...]
Recommendation: Vagrant and Veewee
+0 Vote Up -0Vote Down

Note: I’ve decided not to use Veewee due to silly compatibility issues for now.

Quoting from Vagrant’s web site:

Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual environments.

A complementary technology called Veewee makes building VirtualBox VMs easier by automating away a lot of manual steps. Marius Ducea has a great blog post on how to use it.

My observations:
1. According to

  [Read more...]
Welcome to Insatiable Demand
+0 Vote Up -0Vote Down

In early 2006 Paul Hurley (ideeli’s CEO) and I (Mark Uhrmacher, CTO) were thinking about a new business. We had the idea to create a community based around great deals for Women’s fashion products where we saw a great deal of potential for great content and product sales. Now, over five years later, we’ve realized much of that vision. Our business success has been chronicled over the years in several places (see here and here). Though we’re very proud of our achievements there, that isn’t what this blog is about.

Insatiable Demand is about a mostly untold story. Over the past five-plus years we’ve built a phenomenal technology platform and team. From two people and three servers to a

  [Read more...]
On Password Strength
+6 Vote Up -0Vote Down
XKCD (as usual) makes a very good point – this time about password strength, and I reckon it’s something app developers need to consider urgently. Geeks can debate the exact amount of entropy, but that’s not really the issue: insisting on mixed upper/lower and/or non-alpha and/or numerical components to a user password does not really improve security, and definitely makes life more difficult for users. So basically, the functions that do a “is this a strong password” should seriously reconsider their approach, particularly if they’re used to have the app decide whether to accept the password as “good enough” at all. Update: Jeff Preshing has written an   [Read more...]
Scaling Web Databases, Part 3: SQL & NoSQL Data Access
Employee_Team +3 Vote Up -0Vote Down
0 0 1 281 1602 Homework 13 3 1880 14.0 Normal 0 false false false EN-US JA X-NONE

Supporting successful services on the web means scaling your back-end databases across multiple dimensions. This blog focuses on scaling access methods to your data using SQL and/or NoSQL interfaces.

  [Read more...]
Scaling Web Databases, Part 2: Adding Nodes, Evolving Schema with Zero Downtime
Employee_Team +3 Vote Up -0Vote Down

In my previous post, I discussed scaling web database performance in MySQL Cluster using auto-sharding and active/active geographic replication - enabling users to scale both within and across data centers.  

I also mentioned that while scaling write-performance of any web service is critical, it is only 1 of multiple dimensions to scalability, which include:

- The need to scale operational agility to keep pace with demand. This means being able to add capacity and performance to the database, and to evolve the schema – all without downtime;

- The need to scale queries by having flexibility in the APIs used to access the database – including SQL and NoSQL interfaces;

- The need to scale the database while maintaining continuous availability.

  [Read more...]
Scaling Web Databases: Auto-Sharding with MySQL Cluster
Employee_Team +3 Vote Up -0Vote Down
0 0 1 322 1841 Homework 15 4 2159 14.0 Normal 0 false false false EN-US JA X-NONE

The realities of today’s successful web services are creating new demands that many legacy databases were just not designed to handle:

- The need to scale writes, as well as reads, both within and across

  [Read more...]
Unlocking New Value from Web Session Management
Employee_Team +2 Vote Up -0Vote Down

Join us for a live webinar (http://www.mysql.com/news-and-events/web-seminars/display-630.html) and download a new whitepaper (http://www.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.php) where we discuss how to realize new value from data collected during web session management.

Session management has long been a key component of any web infrastructure – enhancing the user browsing experience through improved reliability, reduced latency and tighter security.

Increasingly organizations are looking to unlock more value from session management to further improve user loyalty (i.e. making the web service more “sticky”) and improve monetization of web services.  There are two distinct developments that offer the promise of unlocking more value from session data:
1.    Provide highly personalized browsing experiences by




  [Read more...]
Four short links: 11 February 2012
+0 Vote Up -0Vote Down

  • Phantom of the Flopera (YouTube) -- Bach's Tocata and Fugue in D Minor (BWV 565) as performed by floppy drives. Creative intimacy with one's tools is a sign of mastery. (via Andy Baio)
  • Save Entire BBC Archive (Ben Goldacre) -- I pointed earlier to the questionable BBC closure of scores of websites in the name of cost-cutting. It's a torrent of an archive of spidered BBC websites. (via Andy Baio)
  • Android Hidden NFC Capabilities Unlocked -- Gibraltar Software Factory, based in Argentina, went through the source
  •   [Read more...]
    Thoughts on group buying sites
    +0 Vote Up -0Vote Down

    Congratulations to Khailee for getting GroupsMore sold to Groupon (in a record five months since its inception!). He tells me they’re now Groupon Malaysia and Joel (his partner, co-founder of YouthSays) is going to be CEO of Groupon Malaysia. A lot of people instantly said that since Groupon is now in Malaysia, all the other deal sites can go the way of the dodo.

    I don’t think so. For a site that does group purchases to be successful, people need to know it exists. Savvy Malaysians have always been into group purchases because a) our currency generally sucks, b) its difficult to get cool stuff shipped to Malaysia. Of course the currency is improving now, and there are virtual postboxes that ship stuff to Malaysia for a small fee.

    But I digress. Group purchasing

      [Read more...]
    A last look at 2010... and what's in sight?
    +0 Vote Up -0Vote Down

    For a few years, I've tried to recap here some events I've found notable over the past year and offering some guesses on what might be ahead of us. I'm somewhat late on these things this year, due to being busy with other stuff, but I didn't want to break the tradition, no matter how silly my wrong guesses might seem later. And again, others have covered generals, so I'll try to focus on specifics, in particular as they relate to what I do. For a look at what we achieved for Habbo, see my recap post on the Sulake blog.

    This time last year Oracle still had not successfully completed the Sun acquisition due to some EC silliness, but that finally happened over the 2010. It seems to be

      [Read more...]
    MySQL 5.5 GA launchd issues with Snow Leopard
    +2 Vote Up -0Vote Down

    I did a clean install on my Macbook Pro this morning, part of the clean install means, re-downloading things like MySQL.

    When I installed it, I noticed that the pref-pane wouldn’t start MySQL. Even when it asked for my admin password. I thought maybe it was a boot up issue, so I rebooted, and got an error telling me that the permissions for the start up item were in secure.

    Here’s what I did to debug/fix the problem.

    • Change permission of /Library/StartupItems/MySQLCOM/MySQLCOM
    • edit /usr/local/mysql/support-files/mysql.server and edited line 46 and 47 to say
    chown -R root:wheel /Library/StartupItems/MySQLCOM
    x

    [content_box style="yellow-box" title="Edit mysql.server file"]
    basedir=/usr/local/mysql
    datadir=/usr/local/mysql/data
    [/content_box]

    [break]
    There is already a bug filed for this..

    How to test your WordPress Cache
    +0 Vote Up -0Vote Down

    How I lost 30 pounds in 2010 – a weight loss guide for developers

    Posted on December 30th, 2010 in blog, personal, zippykid.

    2010 was a great year for me, I started a new company, and it’s been profitable since month 2, I closed my consulting company, and most importantly, I lost 30 pounds, and am more mobile/agile than I was in college. I’m 32 and I feel better than I did when I was 24. I’ve talked [...]

    View  [Read more...]
    How to make WordPress faster without the use of a plugin
    +0 Vote Up -0Vote Down

    When it comes to web page load time, she should always say “wow, that was fast”.

    A Quick update based on Frederick’s comment below

    ** Please do not take these tips as THE answer, this is a complement, not a replacement. I have purposely not given specifics on how to configure anything, or what value to set, because I don’t want people copy pasting things, and then having their site crashing. Regarding mod_pagespeed, I said it’s the most bang for OUR buck.. it’s not recommended in production, nor do we have it on for everyone else. **.

    Webpage load time is getting more and more important these days, if you go into

      [Read more...]
    DuckDuckGo and Web of Trust have a trust metric partnership
    +0 Vote Up -3Vote Down

    There are two search engines that have promise that made themselves public in 2010: DuckDuckGo and Blekko. DuckDuckGo has active search spam removal, you can access it via secure HTTP (HTTPS), and is a search engine that also relies on crowd sourced data.

    Web of Trust has reputation ratings of over millions of websites, and has an active community of about 15 million users now. Best of all, there’s no bots doing these ratings, but community members (trust metrics are crowd sourced).

    DuckDuckGo and Web of Trust have a

      [Read more...]
    mycheckpoint (rev 208): aggregation tables, enhanced charting, RPM distribution
    +1 Vote Up -0Vote Down

    Revision 208 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision:

    • Aggregation tables: aggregated data makes for fast reports on previously slow queries.
    • Enhanced charting: interactive charts now present time stamps dynamically (see demo); “Zoom in” charts are available (see demo) on mycheckpoint‘s HTTP server.
    • RPM distribution: a “noarch” RPM
      [Read more...]
    mycheckpoint (rev. 190): HTTP server; interactive charts
    +2 Vote Up -0Vote Down

    Revision 190 of mycheckpoint, a MySQL monitoring solution, has been released. New and updated in this revision:

    • HTTP server: mycheckpoint can now act as a web server. Point your browser and start browsing through HTML reports. See mock up demo.
    • Interactive charts: HTML line charts are now interactive, presenting with accurate data as you move over them. See sample.
    • Enhanced auto-deploy: now auto-recognizing failed upgrades.
      [Read more...]
    Free webinar – Scaling web apps with MySQL (an alternative to the MEMORY storage engine)
    Employee +6 Vote Up -0Vote Down

    Mat Keep and I will be presenting this free webinar on Wednesday 14 July.

    The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. As these services evolve to support more users, so the scalability and availability demands can start to exceed the capabilities of the MEMORY storage engine.

    The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands. MySQL Cluster can be configured and run in the same way as the MEMORY storage

      [Read more...]
    Four short links: 1 July 2010
    +0 Vote Up -0Vote Down

  • Conflict Minerals and Blood Tech (Joey Devilla) -- electronic components have a human and environmental cost. I remember Saul Griffith asking me, "do you want to kill gorillas or dolphins?" for one component. Now we can add child militias and horrific rape to the list. (via Simon Willison)
  • Meteor -- an open source HTTP server that serves streaming data feeds (for apps that need Comet-style persistent connections). (via gianouts on Delicious)
  • Hobby King RC Store -- online
  •   [Read more...]
    Webinar today – Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
    Employee +7 Vote Up -2Vote Down

    The replay of this webinar is now available from http://www.mysql.com/news-and-events/on-demand-webinars/display-od-545.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-545.html" target="_blank)

    MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services however that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability. This webinar will discuss the use-cases for both

      [Read more...]
    Four short links: 19 March 2010
    +2 Vote Up -0Vote Down

  • Tsung -- GPLed multi-protocol (HTTP, PostgreSQL, MySQL, WebDAV, SOAP, XMPP) load tester written in Erlang.
  • Myth of China's Manufacturing Prowess -- The latest data shows [...] that the United States is still the largest manufacturer in the world. In 2008, U.S. manufacturing output was $1.8 trillion, compared to $1.4 trillion in China (UN data. China’s data do not separate manufacturing from mining and utilities. So the actual Chinese manufacturing number should be much smaller). Also contains pointers to an interesting discussion of lack of opportunities for college grads in China.
  • OpenSSO and the Value of Open
  •   [Read more...]
    Static charts vs. interactive charts
    +1 Vote Up -1Vote Down

    I’m having my usual fun with charts. Working on mycheckpoint, I’ve generated monitoring charts using the Google Chars API. But I’ve also had chance to experiment and deploy interactive charts, JavaScript based. In particular, I used and tweaked dygraphs.

    I’d like to note some differences in using charts of both kinds. And I think it makes a very big difference.

    Static charts

    I’ll call any image-based chart by “static chart”. It’s just a static image. Example of such charts are those generated by Google Image Charts (they now also have new, interactive charts), or RRDtool. Show below is

      [Read more...]
    Showing entries 1 to 30 of 149 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.