MySQL

Manage Your Money with Simple Invoices

by | May 2010 | MySQL e-Commerce Open Source PHP

Simple Invoices provides freelancers, non-profits, and small business a user-friendly way to bill customers and track invoices. It's an application for people who don't want the hassle of larger accounting programs, such as GNU Cash, Quicken, or Quickbooks.

This article on Simple Invoices by Michael Badger, author of Scratch 1.4 Beginner's Guide and Zenoss Core Network and System Monitoring, provides an alternative to bulky accounting programs and the haphazard system of managing individual files by providing an intuitive web-based invoicing system. Because it's open source project, you enjoy free access to your software and your invoicing data.

Read Manage Your Money with Simple Invoices in full

MySQL Cluster Management : Part 2

by Alex Davies | May 2010 | Cookbooks MySQL Open Source Web Development

In the first part of this two-part article series, we covered Configuring multiple management nodes, Adding storage nodes online and Replication between MySQL Clusters. In this article series by Alex Davies, author of High Availability MySQL Cookbook, we will cover:

  • Replication between MySQL Clusters with a backup channel
  • User-defined partitioning
  • Disk-based tables
  • Calculating DataMemory and IndexMemory

(Other related articles on MySQL High Availability are listed at the end of this page.)

Read MySQL Cluster Management : Part 2 in full

MySQL Cluster Management : Part 1

by Alex Davies | May 2010 | MySQL

In this article series by Alex Davies, author of High Availability MySQL Cookbook, we will cover:

  • Configuring multiple management nodes
  • Obtaining usage information
  • Adding storage nodes online
  • Replication between MySQL Clusters
  • Replication between MySQL Clusters with a backup channel
  • User-defined partitioning
  • Disk-based tables
  • Calculating DataMemory and IndexMemory
Read MySQL Cluster Management : Part 1 in full

Setting up MySQL Replication for High Availability

by Alex Davies | May 2010 | Cookbooks MySQL Open Source Web Development

MySQL Replication is a feature of the MySQL server that allows you to replicate data from one MySQL database server (called the master) to one or more MySQL database servers (slaves). MySQL Replication has been supported in MySQL for a very long time and is an extremely flexible and powerful technology. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.

In this article, by Alex Davies, author of High Availability MySQL Cookbook, we will cover:

  • Designing a replication setup
  • Configuring a replication master
  • Configuring a replication slave without synchronizing data
  • Configuring a replication slave and migrating data with a simple SQL dump
  • Using LVM to reduce downtime on master when bringing a slave online
  • Replication safety tricks

Installing and Managing Multi Master Replication Manager(MMM) for MySQL High Availability is covered seperately.

Read Setting up MySQL Replication for High Availability in full

Installing and Managing Multi Master Replication Manager(MMM) for MySQL High Availability

by Alex Davies | May 2010 | Cookbooks MySQL Open Source Web Development

Multi Master Replication Manager for MySQL ("MMM") is a set of open source Perl scripts designed to automate the process of creating and automatically managing the "Active / Passive Master" high availability replication setup discussed earlier in the article on MySQL Replication design recipe, which uses two MySQL servers configured as masters with only one of the masters accepting write queries at any point in time. This provides redundancy without any significant performance cost.

In this article, by Alex Davies, author of High Availability MySQL Cookbook, we will cover:

  • Multi Master Replication Manager (MMM)
    • Initial installation
    • Installing the MySQL nodes
    • Installing the monitoring node
  • Managing and using Multi Master Replication Manager (MMM)
Read Installing and Managing Multi Master Replication Manager(MMM) for MySQL High Availability in full

Programming PHP-Nuke

by Douglas Paterson | April 2010 | MySQL Content Management Open Source PHP

In the previous article of the series by Douglas Paterson, author of Building Websites with PHP-Nuke, we transformed the look of the Dinosaur Portal with the help of a new PHP-Nuke theme. In this article, which is the concluding article of the article series, we will look at programming PHP-Nuke. Specifically, this means creating new blocks and modules. Before we get stuck into that, we will have a look at what actually happens inside PHP-Nuke when a page is requested by a browser.

After that, we will create a new block, a better version of the Dinosaur of the Day block we created in Article 4. That, if you recall, was a static HTML block, and we had hard-coded the image of the dinosaur and its title into the block. Here we will create a block that takes the image to display and title of the dinosaur from the database. This will introduce us to data access in PHP-Nuke, a topic that you will use a lot as you begin to code more with PHP-Nuke.

Read Programming PHP-Nuke in full

Managing Data in MySQL

by Daniel Schneller Udo Schwedt | March 2010 | MySQL

In this article by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will discuss the following:

  • Exporting data to a simple CSV file
  • Exporting data to a custom file format
  • Importing data from a simple CSV file
  • Importing data from custom file formats
Read Managing Data in MySQL in full

Configuring MySQL

by Daniel Schneller Udo Schwedt | March 2010 | MySQL

In this article by Daniel Schneller and Udo Schwedt, authors of MySQL Admin Cookbook, we will discuss the following:

  • Setting up a fixed InnoDB tablespace
  • Setting up an auto-extending InnoDB tablespace
  • Storing InnoDB data in one file per table
  • Decreasing InnoDB tablespace
  • Enabling and configuring binary logging
Read Configuring MySQL in full

Documentation with phpDocumentor: Part 1

by Dirk Merkel | March 2010 | MySQL Open Source PHP

In this two-part article by Dirk Merkel, author of Expert PHP 5 Tools, we will take a look at documentation. We will learn to create code-level documentation using phpDocumentor, PHP's entry into the xDoc family of documentation tools and the de facto standard for documenting PHP code. Specifically, we will install phpDocumentor. Next, we will learn the general syntax for DocBlocks and how to run phpDocumentor to generate the documentation.

Read Documentation with phpDocumentor: Part 1 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