|
|
Lenz has just published an interview to Adam Donnison, Senior Web Developer in the MySQL web team. Under his watch, the site at mysql.com has been powered by MySQL 5.1 for one and half years. In production! Talk about eating your own dog food! In addition to the database server, Adam has spearheaded the test of Enterprise tools and the Query Analyzer. Excellent example, Adam! |
Nov
26
2008
Nov
25
2008
|
If you hear a distant rumble in the air, it could be either Dups testing his new mountaineering gear, or, more likely, MySQL 5.1-GA seeding to the mirrors. We promised that it would come soon, and it's coming. All internal QA automated tests were passed, a batch of additional manual tests with the packaged binaries (called "smoke tests" internally) were performed to make sure that no embarrassing errors were left, and now the train of bits is traveling to the mirrors. Once the mirrors are loaded, expect the announcement, within a few days. |
Nov
16
2008
The MySQL 5.1 GA Release will be on or about Dec. 6th, 2008.
How do I know?
(more…)
Nov
14
2008
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced.
The -percona release includes:
PLAIN TEXT CODE:
- | innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <info@percona.com> | GPL | The names are Innodb_scan_* …
Oct
29
2008
|
|
MySQL 5.1.29 is available. This is the last RC. Yes. You heard me right. The long wait is almost over. The next release will be GA. Sharpen your tools, and get ready to use partitions, row-based replication, and the event scheduler in production without that uneasy sense of guilt that you feel when using non-GA software. |
There are a few small changes in MySQL 5.1.29.
SHOW PROFILESIt was already in a preview, but now SHOW PROFILES is available in
5.1 binaries. As you may recall, it is not active …
Oct
25
2008
Google patches V1 contain interesting patch to mirror binary log on slave. Although Google is preparing GlobalTransactionId patch, which going to be replacement for MirroredBinlogs, we still think mirroring binary logs is very useful for:
- Backup of binary logs in real time
- High availability, to switch master load to slave with mirrored binary logs
By request of our friends EngineYard we extracted this patch from Google's patchset and going to include in our next releases. Actually our patch contains features for both MirroredBinlogs and FastMasterPromotion patches, as second provides feature to make slave as master in case of main master failure.
At …
[Read more]
Sep
06
2008
We made new patches, improved previous and want to announce new
builds for 5.0.62, 5.0.67 and 5.1.26 versions. One of biggest
changes we separated releases of 5.0 into two branches.
First, just "-percona" release is more stable and contains only
stable and proven on many installation patches. Second is
"-percona-highperf" release, which contains experimental patches
that can improve performance significantly. On this stage
"percona-highperf" contains patches from Yasufumi Kinoshita (more
info on Maximum performance of OLTP benchmark is not so
scalable on multi-cpu.
Most important patch "split_buf_pool_mutex" to separate InnoDB
buffer->pool mutex into several, and it allows to get 1.5x -
2.5x improvements in DBT2 benchmarks on 8cores boxes (benchmark
results is coming and will be published)
For all three versions we added SHOW PATCHES command, which is based …
[Read more]
Aug
10
2008
In two words: online operations. In a paragraph: Forget partitioning, row-based replication and events. The big reasons most people are going to salivate over 5.1, and probably start plans to upgrade now, are the online operations:
- online ALTER TABLE for column rename, column default value change, and adding values to the end of an ENUM/SET
- Online, table-based logging. No more need to restart your server to enable or change the general or slow query logs. You can have the standard file-based output or choose a table format…which you can query.
Aug
03
2008
Today I’ve managed to finish initial version of our bounces-handler package we use for mailing-related stuff in Scribd.
Bounces-handler package is a simple set of scripts to automatically process email bounces and ISP‘s feedback loops emails, maintain your mailing blacklists and a Rails plugin to use those blacklists in your RoR applications.
This piece of software has been developed as a part of more global work on mailing quality improvement in Scribd.com, but it was one of the most critical steps after setting up reverse DNS records, DKIM and SPF.
The package itself consists of two parts:
- Perl scripts to process incoming email:
- bounces processor — could be …
Jul
28
2008
The MySQL Community version is different in theory from the Enterprise version in relation to the following points:
0) It’s free
1) It has community patches
2) It is released less often
3) It is tested less strictly
In reality, the first two differences are not applicable — the binaries and source code for Enterprise can be freely and legally downloaded at http://mirror.provenscaling.com/mysql/enterprise/. The process for adding community patches to the MySQL source code has not been changed sufficiently to be able to actually add community patches and encourage more community development.
I understand that MySQL (and now Sun) needs to make money. I also understand that development takes a lot of effort, and seeing an ROI is important. The Community/Enterprise split was designed to have tradeoffs on both sides. …
[Read more]