While attending Lars Thalmann’s session on Row Based Replication I began to think about how the new features will allow us to do creative new things with MySQL Replication. For example we can now issue an update query with a join and have one slave update only rows from table a and another slave only update rows from table b. This is very powerful but also very dangerous.

My experience has been that the average php developer can write average sql but doesn’t tend to think about the overall impact on a system when writing code. This is where system architects apply. A system architect can view an entire system and design it’s components to scale well, be fault tolerant and easily maintained. An application level developer will implement the system based on the design. Replication is a very deceptive convergence between the architect role and the developer …

John David Duncan is talking about UDFs in MySQL 5 (or SQL as a Glue Language) at the MySQL Users Conference. I just realized that this is JD.

Why do we like MySQL? Because it's open source fast, reliable, and easy to use. This has been true since the early days of MySQL.

For many years MySQL did not have stored procedures which can make client/server apps more efficient. MySQL made up for this with lots of internal functions and UDFs.

In SQL standard (SQL92) there are 7 defined string functions. Oracle 8i had 11 string functions. MySQL 4 had 40+ string functions.

JD looks at PHP, Perl and MySQL and how they all are a part of a stack.

User-Defined Functions are fairly simple C programs loaded into the server at runtime. In MySQL you do CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so".

In MySQL 5 there are triggers, …

This is cool, although I haven't used it so it will have to be a theoretical coolness.

A few months back Anders Karlsson posted a UDF and accompanying application for debugging stored procedures on sourceforge. The idea is that you can insert statements into your stored procedure for debugging purposes. The statements use a UDF that sends UDP messages to a debug server (provided with the UDF) to allow you to discover information about what is happening as your stored procedure is executed.

I can relax now, My talk is done and I’ve been talkinq to people about more specific things. Several have congratulated me on it.

Looking forward to the BOF, although sleep would be nice.oh how I’m going to sleep on the plane

Why is this needed?
“world” database current sample is 3 tables, cities, countries and langs.
Not the Intellectual Property of MySQL, so it can’t be bundled with the software
No table type diversity, not a lot of data type diversity
No MySQL 5 features
Not a lot of data
Not really used in tutorials and articles because it’s not robust enough

Scenario
Basically, needed a sample database that was new, that allowed for many queries.
Used an idea from a Dell Sample DB
It’s 2 stores, in 2 different countries.

Designing the Database
Designed with MySQL Query Browser
Normalized
Community provided feedback and content
Trick was balance between simplicity and completeness
Learning db, so people need to understand it
After schema was approved, data was loaded
Stored …

MySQL Users Conference 2006, SANTA CLARA, Calif. - MySQL AB today announced plans for a certification program for the many powerful database storage engines being developed for its flagship MySQL database server by third-party partners and the open source developer community. Several industry-leading companies -- including Innobase OY (a subsidiary of Oracle Corporation) and Solid Information Technology -- are supporting the new program by joining MySQL AB in producing open source engines for the millions of MySQL database users worldwide.

Today, a few days later than originally planned and after 91 days in beta testing, the new version of XAMPP for Linux and Windows is ready for downloading. The major updates in this version are PHP 5.1.2 and 4.4.2, MySQL 5.0.20, eAccelerator 0.9.4 and phpMyAdmin 2.8.0.3.

Find more details on the specific XAMPP project page.

I am at the scale out panel where DBA gurus from Technorati, MySQL (Brian Aker), Google and Yahoo! are answering questions about scaling.

Some Windows based sites are storing up to 30-40 TB of data using MyISAM tables. That site is masochist.com (joke)

A question was asked whether the date in database should be stored as formatted or stored as time only and then formatted by application. The answer given was (the room was jam packed so I couldn't see the faces) that optimization like this should be done at the end. At first, you should try to add indexes where ever needed. Once all the indexes have been added, only then we should move with other smaller optimizations.

Power consumption having effect on business as you scale out?
There is power, power per watt etc. Power is huge concern for us (Technorati).

Some CPUs use a lot less power than others. At Yahoo! and Google, power is a …