This article present techniques to help prevent the gaming of your MySQL-PHP Website. Some of them rely on shutting down scripts; others try to find the humans who are manually executing this behavior.
This two-part article shares some of the lessons learned and take you step by step through a standard process of scaling your PHP-MySQL application based on real-world experiences at Digg, TripAdvisor, and other high-traffic sites.
Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what a relational database is intended for. The tables of a relational database are not hierarchical (like XML), but are simply a flat list. Hierarchical data has a parent-child relationship that is not naturally represented in a relational database table.
In this article we explore how to program foreign keys into a MySQL Server. This is important when your application requires referential integrity and the storage engine you’d like to use, as in the case of MyISAM or NDB (Cluster), does not support this functionality natively. We should note that InnoDB and the upcoming code-named “Falcon” storage engine, both support foreign keys.
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.
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.
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.