MySQL

Disaster Recovery in MySQL for Python

by Albert Lukaszewski, PhD | September 2010 | MySQL Open Source

One thing that is certain in computing is that hardware will fail even if the software is written soundly. For this reason, a disaster recovery plan should be implemented for every database server. Even if you are not the administrator of the server, this article will show you how to back up the data you use.

In this article, Albert Lukaszewski, PhD, author of MySQL for Python, we will have covered:

  • When to implement one of several kinds of database backup plans
  • What methods of backup and disaster recovery MySQL supports
  • How to use Python to back up databases
Read Disaster Recovery in MySQL for Python in full

Inserting Multiple Entries with MySQL for Python

by Albert Lukaszewski, PhD | September 2010 | MySQL Open Source

When we deal with large amounts of data that are all going into the same database, running single instances of individual INSERT commands can take a ridiculous amount of time and waste a considerable amount of I/O. What we need is a way to insert multiple items in one go.

In this article, Albert Lukaszewski, PhD, author of MySQL for Python, we will look at the following:

  • How iteration can help us execute several individual INSERT statements rapidly
  • Using executemany() to submit several INSERT statements in one go
  • When not to use executemany()
  • Throttling how much data is inserted at a time
Read Inserting Multiple Entries with MySQL for Python in full

Using Templates to Display Channel Content in ExpressionEngine

by Leonard Murphy | September 2010 | MySQL Content Management PHP

In this two-part article series by Leonard Murphy, author of Building Websites with Expression Engine 2.X, you will take an existing website that was written outside of ExpressionEngine and adapt it to ExpressionEngine. In the first part you created your own channel with fields customized to the content that you will be displaying.

In this article you will be:

  • Using templates to display your channel content
  • Creating a 404 page for visitors who get lost on your site
Read Using Templates to Display Channel Content in ExpressionEngine in full

Creating Channel for Moving a Website to ExpressionEngine

by Leonard Murphy | September 2010 | MySQL Content Management PHP

The vast majority of a website is content, and ExpressionEngine makes it easy to create and maintain such content. In this two-part article series we will create an actual website and learn how to use channels and templates to display our content.

In this article by Leonard Murphy, author of Building Websites with Expression Engine 2.X, you will take an existing website that was written outside of ExpressionEngine and adapt it to ExpressionEngine. As part of this transition, you will be creating your own channel with fields customized to the content that you will be displaying.

Read Creating Channel for Moving a Website to ExpressionEngine in full

Examples of MySQL Daemon Plugin

by Andrew Hutchings | August 2010 | MySQL Open Source Web Development

In the previous article, A look inside a MySQL Daemon plugin, we were introduced to the MySQL Plugin API. It talked about the most simple plugin type—Daemon plugins. It starts with the basic structure of a plugin—what a plugin declaration should look like, what plugin types are, and so on. Then it described features common to all plugin types—initialization and de-initialization callbacks, status variables, and configuration system variables.

This article, by Andrew Hutchings, co-author of MySQL 5.1 Plugin Development, describes and analyzes line by line four Daemon plugin examples—from a simple plugin that prints Hello World! when loaded, to a system monitoring plugin that periodically logs the number of connections, to a system usage status plugin that displays the memory and I/O usage of the MySQL server.

We will specifically cover:

  • A Hello World! Daemon plugin
  • A system and status variables demo plugin
  • A simple monitoring plugin
  • System Status Variables plugin
Read Examples of MySQL Daemon Plugin in full

MySQL 5.1 Plugin: HTML Storage Engine—Reads and Writes

by Sergei Golubchik | August 2010 | MySQL Open Source Web Development

In this article by Sergei Golubchik, co-author of MySQL 5.1 Plugin Development, we will consider a complex example, a complete read-write storage engine, but with no support for indexes. Let's say, it will be an "html" engine—an engine that stores tables in HTML files. Such a file can be later loaded in a web browser and the table will be shown as an HTML table. Thus Reads and Writes presents a storage engine plugin that keeps table data in HTML tables and uses it to explain how to implement an updatable data stores.

Read MySQL 5.1 Plugin: HTML Storage Engine—Reads and Writes in full

A Look Inside a MySQL Daemon Plugin

by Andrew Hutchings | August 2010 | MySQL Open Source Web Development

In this article, by Andrew Hutchings, co-author of MySQL 5.1 Plugin Development, we will be introduced to the MySQL Plugin API. It talks about the most simple plugin type—Daemon plugins. It starts with the basic structure of a plugin—what a plugin declaration should look like, what plugin types are, and so on. Then it describes features common to all plugin types—initialization and de-initialization callbacks, status variables, and configuration system variables.

We will specifically cover:

  • A look inside a Daemon plugin
  • Why write a Daemon plugin
  • Installing and using Daemon plugins
  • The role of a version
  • Defining Daemon plugins
Read A Look Inside a MySQL Daemon Plugin in full

There is More to the ORDER BY Clause than Sorting a Column

by Djoni Darmawikarta | August 2010 | Architecture & Analysis MySQL

You can do more with the ORDER BY clause in a query than just putting in it a column or two. By mixing and matching the cases and solution examples in this article you will have virtually unlimited sorting flexibilities in your armory. This article by Djoni Darmawikarta shows how to solve various ordering cases in SELECT queries.

Read There is More to the ORDER BY Clause than Sorting a Column in full

Indexing in MySQL Admin

by Daniel Schneller Udo Schwedt | June 2010 | MySQL

In this article series by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

  • Adding indexes to tables
  • Adding a fulltext index
  • Creating a normalized text search column
  • Removing indexes from tables
  • Estimating InnoDB index space requirements
  • Using prefix primary keys
  • Choosing InnoDB primary key columns
  • Speeding up searches for (sub)domains
  • Finding duplicate indexes

Read the first part of this article series—Optimizing your MySQL Servers' performance using Indexes here.

Read Indexing in MySQL Admin in full

Optimizing your MySQL Servers' performance using Indexes

by Daniel Schneller Udo Schwedt | June 2010 | MySQL Web Development

In this article series by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will cover:

  • Adding indexes to tables
  • Adding a fulltext index
  • Creating a normalized text search column
  • Removing indexes from tables
  • Estimating InnoDB index space requirements
  • Using prefix primary keys
  • Choosing InnoDB primary key columns
  • Speeding up searches for (sub)domains
  • Finding duplicate indexes
Read Optimizing your MySQL Servers' performance using Indexes in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software