Secure your Server

March 14, 2011

It does not matter what data is stored in your database, you want to prevent unauthorized access to it. If the data is not secure then anyone with the time and motivation can potentially access it over the internet. Once they are in to your database they can take all your data or delete it [...]

Read More

Tighten up the schema

March 14, 2011

It does not matter how good you can write queries in MySQL, if the underlying schema is not optimized it will slow your database performance down. This is not just removing unwanted fields, but you need to make sure that your fields are storing data with the correct size. One example of this is a [...]

Read More

Partition Tables

March 13, 2011

One of the big deciding factors in the performance of your database is the design of the database. Research from various parties, including Oracle has found that poor database design is a major factor in poor database performance and unscheduled system downtime. One great way to improve the performance of your MySQL database is to [...]

Read More

Isolate Slow MySQL Processes

March 13, 2011

Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on effect on any other processes running on the server and can have a major effect on performance. In an ideal world, you could just increase the resources available to the [...]

Read More

Use Benchmarking to Improve Performance

March 13, 2011

One of the best ways to check the performance of your MySQL application is to benchmark it regularly. Put the application under as much load as you can to simulate the worst possible reasonable load and check the performance. Several functions within MySQL can help you to test your databases. One of the most useful [...]

Read More

Automate MySQL Database Backups

March 12, 2011

One of the most important tasks for a MySQL administrator is the ability to backup and restore all your databases on a regular basis. This will help to prevent data loss in the event of a hardware failure or data corruption. One great way to do this is to use a script to perform the [...]

Read More

MySQL Performance Optimization

March 12, 2011

MySQL can support large databases, but as the size of the data grows, the performance of your database can start to suffer. As a database administrator, there are a few things that you can do to improve the performance of your databases. The first place to start is with your hardware. As MySQL uses many [...]

Read More