Many web developers consider security a low priority. Security is frequently relegated to the end of the software development life cycle, as little more than an afterthought. Sometimes, software security is neglected entirely, resulting in applications rife with common vulnerabilities. Because such bugs might manifest only under conditions present during an attack, they can be hard to detect prior to such events without knowledge of how the exploitation process works. Using a web application built with jQuery Mobile, PHP, and MySQL, this tutorial shows how many types of vulnerabilities occur along with common methods of exploitation and, most importantly, their respective countermeasures.

Although MySQL is one of the most popular programs, many developers have felt the need to branch it into other projects, each offering their own speciality. That need, along with the fear that Oracle will slow the growth of the core product, has led to many sub-projects and branches of interest to developers.

Take the rapid development of Roo a step further by creating applications to work in the cloud with Cloud Foundry, the first open platform as a service project created by VMWare. Learn more about the environment and then deploy an application into Cloud Foundry using the Roo shell.

Even though MySQL is a good general-purpose database, if your application is search-heavy, you may get better performance by using Sphinx instead. Despite Sphinx being a full-text search tool, it can increase the speed of your application even when working with non-full-text queries. This article shows how to configure Sphinx for this task, includes some example queries, measures their execution times, and demonstrates some of the trade-offs involved in the change considering what you need to use Sphinx in a general, systematic way.

Rich Internet Applications (RIAs) often utilize different bundled technologies. Choosing the right grouping of technologies can expedite development times and provide users a complete and rich Internet experience. Discover how to use Java™ EE platform components on the server side, the Adobe® Flex™ platform on the client side, and the MySQL® database server for storage persistence.

Description of many features in MySQL, which work as advertised, but not as those used to other databases may expect.

This article discusses:
* Setting up automatically updated slaves of a server based on a SQL dump
* Setting up automatically updated slaves of a selection of tables based on a SQL dump
* Setting up automatically updated slaves using data file copy
* Sharing read load across multiple machines

This article describes a very simple login technique implemented by using several contemporary technologies. It brings a scripting language (Perl), a free database (MySQL) together with a lightweight text-based open standard (JSON), a cross-browser JavaScript library (jQuery) and an asynchronous interactive web application technique (Ajax).

Does MySQL Cluster scale? Does MySQL Cluster rock? This article try to answer these questions with tests of MySQL Cluster 5.1.20.

Applications using the LAMP (Linux®, Apache, MySQL, PHP/Perl) architecture are constantly being developed and deployed. But often the server administrator has little control over the application itself because it's written by someone else. This series of three articles discusses many of the server configuration items that can make or break an application's performance. This third article, the last in the series, focuses on tuning the database layer for maximum efficiency.