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
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 fullInstalling 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)
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 fullManaging 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
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
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 fullInteractive Page Regions with Drupal 6: Part 2
by
J. Ayen Green | March 2010 | MySQL Content Management Drupal PHP Web Development
Read Part One of Interactive Page Regions with Drupal 6 here.
Read Interactive Page Regions with Drupal 6: Part 2 in fullInteractive Page Regions with Drupal 6: Part 1
by
J. Ayen Green | March 2010 | MySQL Content Management Drupal PHP Web Development
In this two-part article by J. Ayen Green, author of Drupal 6 Attachment Views, you will learn the following:
- How to configure Drupal's Contact system
- What the default Contact system does (and does not do)
- How to add just a little pizazz to a page with an Attachment view and a module
- How to add the Contact form to a view
- The first steps you need to take with Drupal's module architecture and hook mechanism
- How to modify the Contact form via a custom module
- How to use an add-on module to make the Contact form available in a view
- How to create an Attachment view
Drupal and Ubercart 2.x: Install a Ready-made Drupal Theme
by
George Papadongonas Yiannis Doxaras | March 2010 | MySQL Drupal e-Commerce Open Source PHP Web Development
Consider that you have built an e-store, and it is full of products, has great functionality, and offers the client a great browsing experience. The only problem is that you're still using the default Drupal theme, so your website looks too ordinary and rather ugly. People won't be able to perform proper searches and you cannot interfere with the UI by simply promoting items from your stock or communicating special deals and offers.
This article by George Papadongonas and Yiannis Doxaras, authors of Drupal E-commerce with Ubercart 2.x, shows you how to install a ready-made theme, free or commercial, and use it as is.
Read Drupal and Ubercart 2.x: Install a Ready-made Drupal Theme in full
