A couple of weeks ago a friend of mine asked me how to use MySQL stored procedures with PHP’s mysqli API. Out of curiosity I asked another friend, a team lead, how things where going with their PHP MySQL project, for which they had planned to have most of their business logic in stored procedures. I got an email in reply stating something along the lines: "Our developers found that mysqli does not support stored procedures correctly. We use PDO.". Well, the existing documentation from PHP 5.0 times is not stellar, I confess. But still, that’s a bit too much… it ain’t that difficult. And, it works.

Using stored procedures with mysqli

The MySQL database supports stored procedures. A stored procedure is a subroutine stored in the database catalog. Applications can call and execute the stored procedure. The CALL SQL statement is used to execute a stored procedure.

Parameter

Stored procedures can …

MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for dump/reload, etc. The promise of scalable MySQL has remained largely unfulfilled, until TokuDB.

Time: 2PM EST / 11AM PST

REGISTER TODAY

TokuDB v5.0 delivers

• Exceptional Agility — Hot Schema Changes allow read/write operations during index creation or column/field addition
• Unmatched Speed — Fractal Tree indexes are optimized for index insertion performance
• Maximum Scalability — Fractal Tree index performance scales even as the primary index …

Dear data integration fans,

I’m a big fan of “appropriate” data modeling prior to doing any data integration work.  For a number of folks out there that means the creation of an Enterprise Data Warehouse model in classical Bill Inmon style.  Others prefer to use modern modeling techniques like Data Vault, created by Dan Linstedt.  However, the largest group data warehouse architects use a technique called dimensional modeling championed by Ralph Kimball.

Using a modeling technique is very important since it brings structure to your data warehouse. …

Today we registered MySQL Connector/Python with the Python Package Index (PyPI). It makes installing your favorite connector even easier (provided you first install setuptools or pip):

shell> easy_install mysql-connector
shell> pip install mysql-connector

Please report problems either using Launchpad or MySQL Bugs website.

…

MySQL Enterprise Backup (MEB) provides an easy way to perform incremental backups. You do have to know the log sequence number or LSN1 of the previous backup. And you can find the LSN in the meta/backup_variables.txt file from the previous backup.

MEB saves all the changes from the specified previous backup, see the mysqlbackup: INFO: Backup contains changes from lsn 14652513 to lsn 14659161 line from the following:


$ ./mysqlbackup --incremental -u root -p --incremental-backup-dir=/home/dstokes/foo2 --with-timestamp --start-lsn=14652512 backup

MySQL Enterprise Backup version 3.6.0 [2011/07/01]
Copyright (c) 2003, 2011, Oracle and/or its affiliates. All Rights Reserved.

INFO: Starting with following command line ...
./mysqlbackup --incremental -u root -p
--incremental-backup-dir=/home/dstokes/foo2 …

If you're one of those that thinks that HA is all about MySQL® Replication, or if you've tried to alter your tables to NDB to drink at the holy grail of shared nothing architectures, SkySQL has got a meet-up for you! Join Ivan Zoratti, SkySQL's Director of Field Services, at MySQL meet-ups in Seattle, San Francisco, and Boston where he'll cover old tricks and new tools for deploying highly available MySQL databases. The pizza's on us! Sign-up today:

Seattle, Monday, December 5th, 7:00PM
San Francisco, Wednesday, December 7th, 6:30PM
Boston, Monday, December 12th, 7:00PM

Next Tuesday I’ll be speaking at the DevOpsDC meetup at CustomInk’s offices. I’ll talk about why MySQL downtime happens and what you can do to avoid or prevent it. This is a research-based talk (but it’s not scientific… they’re different) that draws on hundreds of downtime issues I’ve studied. The related white papers are available on Percona’s website. Hope to see you there!

Further Reading:

• Speaking at MySQL Meetup in Northern Virginia
• …

If you're one of those that thinks that HA is all about MySQL Replication, or if you've tried to alter your tables to NDB to drink at the holy grail of shared nothing architectures, SkySQL has got a meet-up for you! Join Ivan Zoratti, SkySQL's Director of Field Services, at MySQL meet-ups in Seattle, San Francisco, and Boston where he'll cover old tricks and new tools for deploying highly available MySQL databases. The pizza's on us! Sign-up today:

Awesome. I can't wait to try out the 7.2 version.

MySQL users are used to outstanding replication between servers, starting with MySQL's native replication and now using the high-performance, open source Tungsten Replicator. But what about moving data from MySQL into Oracle? Well, Tungsten Replicator does that too, and it's all open source! In this webcast we describe how Tungsten Replicator works, then walk you through setup of