Database Replication in MySQL
451273
MySQL does not claim to be enterprise-ready for nothing, and Yahoo and other high-volume users of MySQL certainly do not run on one database server. There are a number of techniques to handle high volumes, one of which is introduced in this article - MySQL replication.
150071
On his blog today, Mike Lively has posted about the work h's done to create a database extension for the popular unit testing software for PHP, PHPUnit.   For those that may not have read any of my previous postings on the subject the goal of this software is to extend the functionality of PHPUnit to allow using seed data to put a given database into a known state prior to executing each test. It also provides an easy mechanism to compare database contents with an expected dataset.   Mike has just completed the initial feature set for his project - more or less a port of DBUnit over to PHP. The post includes not only details about this initial release but also code that demonstrates its use. In his example, it's used to validate that a bank account has been created properly by comparng database information before and after the insert.
765546
On the Zend Developer Zone, there's a new tutorial looking at one of the unsung heroes of the web development world - one that, when you need it, it does what it does well - SQLite.   Is a full-blown database server even necessary for most PHP applications? What about a data-driven website like a blog or a simple family photo album or message board? In these and may other cases, the small, simple, and extremely powerful SQLite may be all you need. Let's take SQLite out for a test drive and see how it performs, find some of the quirks you might run in to, and how to get the most use out of it.   They talk about SQLite being a "staple" in PHP for a while now and how PDO plays so well with it. They move on to the code quickly, giving a simple example of how to create a database, and table, and inserting content into the latter.    Other more advanced features are discussed - data types, speed of queries, using transactions, and cleaning up the code to really make it fly. They even talk about "user defined aggregate functions", a method to make running a set of data through the same processes over and over a snap.
676690
Welcome to phpMyAdmin 2.9.0.3, a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.   Release 2.9.0.3 contains a security fix. Details will follow on the security page of phpmyadmin.net.  Download the release from here: https://sourceforge.net/project/showfiles.php?group_id=23067
431270
Over on PHPMac.com there's a new article seeking to help you install PHPMyAdmin for MySQL multiuser environments.
664696
On the MSBWare.com site there's a new tutorial looking at the integration of the FCKeditor (a powerful web-based editor that works much like Word) with a MySQL database backend via PHP.   This article is intended to address the lack of documentation in integrating the FCKeditor with your MySQL database.  Their tutorials show how to configure and use the editor, but how to get it to save to your database isn't addressed at all.  While this article will utilize the MySQL DBMS, the concepts are the same for any DBMS.   They start with the download and install of the editor, including placing it in a page where it can be used (inclusion and configuration). The next step is to wrap the entire editor block in a form to make it submittable and, finally, write the update script to happen on submit. Complete code is included at the end of the tutorial.
444001
Those in the New York area might want to check out a new post Daniel Krook has concerning his talk he'll be giving on native XML databases at next week's New York PHP User Group meeting.   The presentation follows a mailing list thread and resulting blog post that generated a lot of interest and discussion on the topic. It should be a great talk for database administrators, application developers and content producers alike.   According to the summary of the talk, he'll be discussing what XML databases are good for and why you might choose them over a normal database. For more information on attending, check out the NYPHP User Group website.
311831
For the last few days I've been using MySQLs ALTER and REPAIR table functionality and its caused tons of countless problems and a great deal of lost sleep.  The first problem I noticed was that for large tables ALTER TABLE was taking hours!  Lets say you have a 30G table.  Good luck altering it as the default MySQL configuration will probably take 100 or more hours.  In MySQLs defense there are a number of variables you can use to increase the performance of an ALTER but the problem is that the two major ones (myisam_max_extra_sort_file_size, and myisam_max_sort_file_size) can't be set at runtime (during an ALTER). If these are set too low MySQL will revert to a "Repair with keycache" strate ...
676788
Andreas Gohr has posted about a script he's created to act as a simple replacement for the PHP/MySQL database tool phpMyAdmin - what he calls MySimple.php.   Kaddi needed to fix something in her employer's database today. Unfortunately she had FTP access only. So the database change had to be made through a PHP script. [...] I looked for a basic MySQL PHP interface but couldn't find one. So I quickly wrote it my self.   He has a screenshot of the app in action included and you can grab the code from his wiki.
499343
On the "Blond R" blog, there's a first posting that shares some of the knowledge that the author has gained from working to get IIS7 installed with MySQL and PHP 5.   As all of us are talking about the new coming Windows Vista, I decided to dedicate my first post to guide you all on how to setup IIS 7 along with MySQL and PHP 5.   He hadn't found a tutorial that covered getting all three working well together, so decided to create his own - complete with screen shots for each step of the way. First, IIS is set up, then PHP, then, finally, the MySQL installation is completed and all three are tied together. All downloads are linked as well to make it even easier to set your system up.
518213
So, what do you do to the worldâs nicest database, in order to get some enterprise salesâ¦ Letâs face it; MySQL is a fabulous database engine. Not only is it free, itâs small, powerful and easy to drive. It also runs happily on free operating systems and so it can be used to create incredibly cost-effective database servers.â¦
292058
MySQL at the end of January is expected to release a beta version of its MySQL 5.0 open source database, which is to feature enterprise-level functionality such as stored procedures and triggers, according to a company representative.
102940
In the world of industry database management, there are three major players: IBM DB2, Microsoft SQL Server and Oracle. There is a lot of literature about using both Microsoft and Oracle's products, but information on using DB2 specifically with PHP was difficult to find. I developed this tutorial to help the age PHP-MySQL application developer expand his or database horizons to include IBM's powerful database offering.
414274
Nice!  MySQL 4.1 final is now available   "MySQL AB, developer of the world's most popular open source database, today announced the general availability of MySQL 4.1. Certified by the company as production-ready for large-scale enterprise deployment, this significant upgrade to the MySQL database server features advanced querying capabilities through subqueries, faster and more secure client-server communication, new installation and configuration tools, and support for international character sets and geographic data. MySQL 4.1 can be downloaded now at http://dev.mysql.com/."  ""Our user community has been testing MySQL 4.1 for many months, and hundreds of businesses have already deployed  ...
480851
Today, MySQL rolled out a new hosting program that offers the company's top-of-the-line software and tools, plus 24-hour support, to partners. With Sun's acqusition of MySQL already under way, is this the start of something bigger?
405345
Greg Beaver, PEAR guru extraordinaire, has added a new post to his blog encouraging the use of the PEAR installer to help manage and deploy your website to a production server.   One of the most common tasks that we experience as web developers is synchronizing a development web server with a live site. There are many solutions that have been tried before. [...] However, every single method (described above) has the potential for immediate and catastrophic failure, even with a backup.   He suggests the use of the PEAR installer functionality along with version control to easily deploy a site, allowing for things file dependencies and versioning. So, if files are handled through that package, how is the database managed? Through another PEAR-related feature - the post-install database initialization the Installer makes possible. Check out Greg's post for the full details on how to get you and your site started.
450911
Mike Lively shares some info about a project he's been working on in a new post to his blog today - a port of Java's DBUnit functionality over to PHP to work happily with PHPUnit:   For those of you not familiar with DBUnit, it is a framework that allows you to easily and quickly test php code that modifies and works with database data. [...] With database code this [testing] is somewhat difficult because you have to ensure that your database is in a known state prior to running your tests.   He gives two examples, the first illustrates the difficulty that can come up when trying to test the database information with a normal unit test and the second an example of the same, but using his port of PHPDBUnit to delete information from the database. It uses two XML files in the test - one to seed the database and the other to give the expected export information.   Check out his post for more details on the port from Java and keep an eye out for a beta release of the library as soon as July.