Archive for the ‘mysql’ category

MySQL Replication

August 19th, 2011 Leave a comment
MySQL Replication

You’ve finally done it: your MySQL database has gotten so large that it simply isn’t working on one machine anymore. You’ve tweaked it, you’ve optimized it, you’ve gotten it to the point where your system simply can’t read fast enough to accommodate the number of reads. Is it time to move to a NoSQL solution? Possibly, but even then, you’ll need a temporary solution to keep your site running smoothly during the transition phase! It’s time to add more MySQL servers to help handle the load. It’s time to use Replication! Replication is a great way to increase the amount of… View full post »

PHP & MySQL Best Practices for Rock-Solid Applications

March 11th, 2011 Leave a comment 2 comments
PHP & MySQL Best Practices for Rock-Solid Applications

PHP and MySQL are often the preferred technologies for building web applications because they allow you to build robust web applications very rapidly. This rapid development, however, sometimes leads to code that is hard to maintain, doesn’t scale well or performs poorly. Fortunately, there are a few things that you can do early in your application development cycle that will keep your application from developing problems. Follow these PHP/MySQL best practices to build rock-solid applications. Also, keep in mind in general that a bit of extra time invested upfront in keeping your code easily maintainable will save… View full post »

Data Mining with MySQL – Finding Value in Numbers

July 24th, 2010 Leave a comment 1 comment
Data Mining with MySQL - Finding Value in Numbers

When it comes to full scale database analysis, many servers have integrated software packages such as SSIS for Microsoft and dedicated business intelligence tools from SAP, SAS and other forms. Analyzing data with open source technology however requires a bit more work when it comes to implementing an end to end Business Intelligence (BI) tool. While there are a variety of ways to export MySQL data into software packages that can handle modeling, it is important to understand how the process works and the technology required. How MySQL can work with PMML Working with broad patterns and intuition on raw database technology… View full post »

Optimizing MySQL Queries

May 28th, 2010 Leave a comment
Optimizing MySQL Queries

MySQL is a very capable database server. It powers numerous web sites and applications and is so widely used that it was etched as the “M” in LAMP platform. One of the reasons MySQL has become so popular is that it can be extremely fast, particularly in cases where data is primarily being read such as web sites. Even with all its strengths, it is possible for a developer to right a bad query that slows down the database or for the volume of data to reach a point where a normally speedy query becomes quite slow…. View full post »

MySQL Caching Techniques

April 5th, 2010 Leave a comment
MySQL Caching Techniques

MySQL is an incredibly powerful and robust database which is why it powers so many web sites and web applications today. However, even the best database often needs additional help to keep up with the high volume demands of popular sites or web applications. MySQL is no exception. One way that many developers squeeze additional performance from MySQL is through caching in order to reduce the number of queries hitting the database. There are a number of techniques for caching MySQL queries. Cache Types File-based Cache The simplest system for MySQL caching is a file based system. In… View full post »