Personal blog of Yzmir Ramirez

So, this week, Drizzle released its beta, which is really exciting. But at the same time, I decided to ask the Ubuntu MOTU pull it out of Ubuntu 10.10 (a.k.a. maverick) entirely. The reasons, may not be entirely obvious.

• Licensing: There is some ambiguity on the licensing of certain non-critical source code in Drizzle that we weren’t certain Debian archive admins would accept. Since we like to follow Debian as closely as possible in Ubuntu, the MOTU sponsor we had was requesting that we upload into Debian first. Upon review of earlier packages, the debian archive maintainers pointed out some ambiguities in the copyright documentation, and it turns out, there are some ambiguities still in the source code. These things take time to sort out, though I’m confident we’ve figured most, if not all, of them out.
• Beta status: Drizzle released their first beta just yesterday. This is great, and would be a good release to have in Maverick, but its going to change *a lot* before the “elliot” milestone is released in early 2011. Monty Taylor assures me that they’re going to be ready to release before feature freeze of Natty (11.04). Until then, they’re going to be fixing bugs in the betas and releasing those fixes. In the face of that, its probably better to point people at a PPA that will have the latest bug fix release in it, and tools included to help debug/fix the release as well.
• Quality: Even though its clear that drizzle is beta to those following drizzle closely, it may not be entirely clear to everyone. Beta versions make it into Ubuntu all the time, but being a database engine, I’m hesitant to have the casual user try it out. In 6 months, Drizzle will be at a stable release stage, and all users should be feeling pretty good about running on it. That seems like the right time to put it into Debian and Ubuntu.

So, what should you do if you want to run Drizzle on Maverick?

There are two package archives maintained by the drizzle developers just for ubuntu.

The PPA for drizzle development – This should have the latest stable release, and all of the build-depends to rebuild it.
The Drizzle Trunk PPA – This should have the latest daily build of drizzle from the source code repository, which may have fixes made since the last stable release.

Those links include instructions for adding the PPA’s to your system, after that, just


apt-get install drizzle-server drizzle-client


And have fun!

Also, we’ll be discussing drizzle sometime at UDS-N in Orlando. So make sure to check the schedule out and join us (remotely or on site) if you want to chime in or hear what we’re going to do with the Narwhal and Drizzle.

If you have hung around the PHP community for any amount of time, you’ve probably heard of MWOP , Zend Framework’s Supreme Allied Commander, the man, the myth, the legend, Mr. Matthew Weier O’Phinney. ( MWOP …see how that works?) Matthew is a busy man these days working on Zend Framework 2.0, speaking at local user groups and in all his spare time being a dad and husband. I recently caught up with up with Matthew and in between asnwering my Zend Framework tech support questions, he agreed to answer…3 Questions.

We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s a Cisco UCS C250 server, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount of memory. It has 384GB of RAM, which is actually more space than the disks contain.  The disks are 270GB in total, with the underlying configuration RAID10 over eight 2.5″ 15K RPM disks. To make the system even more powerful, I put a FusionIO 320GB SLC card in the PCI-E slot. Here is a link to the box specs.

The server was generously provided by Cisco Systems, Inc.

So, obviously I’m anxious to see how Percona Server with XtraDB scales on this hardware, and you can expect a series of benchmarks. An especially interesting topic is what we can get from “threads”, as there are only 12 “real” cores, with each core having two “threads”.

So, I took Percona Server 5.1.47-11.2  and ran the sysbench oltp read-only and read-write benchmarks using from 1 to 32 threads. The database size was 100 million rows ( about 23GB of data). (Starting with Percona Server 5.1.49-12.0, we are going to provide regular builds dedicated to the Cisco UCS platform)

The full results are available on Wiki, and the graphical representation follows:

You can see from the graph that it scales pretty well even up to 24 threads, despite the fact that half of them are not real CPU cores. For up to 10 threads, the scale factor is quite impressive: it is 8.2 for read-only and 9.2 for read-write.  (I calculate the scale factor as the result with 10 threads divided by the result with 1 thread.) Above 10 threads, the rate of increase is not as large, and for 24 threads we have a scale factor of 12.6 for read-only and 13.3 for read-write.

Of course, it will be interesting to compare these results with the latest MySQL 5.5 releases, and especially in cases with the number of threads is > 100. I’m going to do these comparisons in my next round of testing.

(Edited by Fred Linhoss)

Entry posted by Vadim |
14 comments

Add to: | | | |

Drizzle7 Beta Released! now with MySQL migration! « LinuxJedis /dev/null.

Drizzle is a project that is near and dear to my heart.

To sum it up, Drizzle took all that was really good in MySQL, cut out all that was mediocre, and replaced some of it with really good stuff. The end product is, I think, something that is leaner, should be more stable, and definitely more flexible.

So go check out the beta! I guess I should use Andrew’s migration tool and see if I can migrate this blog to drizzle.

ZendCon is coming up and for those attending for the first time, let’s take a minute or two to meet some of the people involved. Today’s special guest is Michaelangelo (DragonBe) van Dam. Mike is hosting the 4th annual ZendCon UnCon. If you are planning on attending, you will want to know Mike. If you are still on the fence, maybe knowing who the players are will help you decide to get your ticket now.

When building a Web application, you’ll often find it necessary to save and retrieve user-defined configuration values. Rather than rolling your own code, consider using Zend_Config, which offers a complete API to read and write configuration data in INI, XML and PHP array formats. In this article, I’ll give you a crash course in how Zend_Config works, and show you how you can integrate it into a PHP application.

During my visit to Moscow, Russia next month I’m going to give a full day training/tutorial presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was so popular it was sold out earlier this year. This also will be the only full day training event open to the public during this trip. There are few conference talks, user meetings and private training engagements which I’m doing on this trip as well. I’ll blog about these later.

Entry posted by peter |
No comment

Add to: | | | |

Dear Community,

Percona Server version 5.1.50-rel11.4 is now available for download.

The changes in this release include:

New features

The primary purpose of this release is to update to the latest version of MySQL 5.1.

• Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50.

Fixed bugs

• innodb_use_sys_stats_table – The SYS_STATS table is now used only for non-temporary tables.

The binary packages are available on our website.

Percona Server can be installed from either our RPM or Debian repository.
It is worth mentioning that Percona Server doesn’t obsolete MySQL packages, so, if you’re migrating from MySQL to Percona Server, you have to remove your MySQL packages and then install Percona Server. To keep applications which depend on MySQL during migration, you need to install the Percona-Server-shared-compat package.

The latest source code for Percona Server, including the development branch, can be found on LaunchPAD.

Please report any bugs found at Bugs in Percona Server.
For general questions, use our Pecona-discussions group, and for development questions our Percona-dev group.

For support, commercial, and sponsorship inquiries, contact Percona.

Entry posted by Aleksandr Kuzminsky |
One comment

Add to: | | | |

The PHP Barcelona User Group is pleased to announce the 4th edition of the PHP Barcelona Conference . Come to the shores of the Mediterranean for two fun-packed days of cutting edge PHP, Application Scalability, High Performance, Databases, Integration, Testing, Clouds (not in the sky, we hope) and many many more topics and surprises. The event will take place from the 29th to the 30th of October and will bring together Ilia Alshanetsky, Fabien Potencier, Stefan Priebsch, Lorenzo Alberton, Enrico Zimuel and many more of the shiniest names in the industry for 48 hours of intensive PHP and fiesta! Fore more information visit http://phpconference.es and book your spot now before tickets run out and do not lose out on one of the most appealing events on the PHP calendar :) See you in Barcelona!

This week, the activity of the symfony developers’ mailing list soared with lots of interesting discussions. Among many other topics, developers discussed about Symfony2 default template engine (PHP or Twig) and the default configuration format (PHP, XML or YAML). Remember that this mailing list is the best place to get the latest news from Symfony2 and to influence its future development.

Development mailing list

• [Symfony2] Default to Twig?
• Symfony2 forms: feedback from symfony 1
• Controller Dependency Injection
• Default format for configurations

symfony 1 development highlights

Changelog:

• r30951:
  [1.3, 1.4]
  fixed WDT injects multiple times
• Milestone 1.3.7 completed
• Milestone 1.4.7 completed
• r30961:
  [1.3, 1.4]
  fixed missing WDT javascript

sfPropelPlugin:

• r30966:
  [1.3, 1.4]
  updated Slovenian translations for Doctrine and Propel messages
• r30967:
  [1.3, 1.4]
  fixed i18n support for traditional chinese
• r30968:
  [1.3, 1.4]
  fixed Persian Translation of admin generator
• r30969:
  [1.3, 1.4]
  added more translations to german and italian translations

Activity summary: 64 changesets, 21 bugs reported, 4 bugs fixed, 3 enhancements suggested, 1 enhancement closed, 8 documentation defects reported, 1 documentation defect fixed, and 4 documentation edits

Symfony2 development highlights

Changelog:

• 5f9c365:
  [DoctrineMongoDBBundle] fixed formatting of booleans in query log
• e6bff04:
  [DoctrineMongoDBBundle] added a quick profiler panel
• 71cc3a7:
  [Form] avoid double-escape and then unescape (using the fourth parameter of htmlspecialchars)
• 2862c6c:
  refactored configuration names (have a look at the skeleton for how to upgrade)
• 82f6a68:
  [Validator] allow DateTime objects as valid DateTimes
• 2d80788:
  [FrameworkBundle] added support for services as controllers
• f3993b4:
  added width, height, alt tags for all images used in web profilers (for proper html)
• d62befd:
  [FrameworkBundle] fixed Filesystem when used within a phar archive
• 69b538b:
  [FrameworkBundle] removed the app:init command

New developers for hire

• Gaurang Rajvir (gaurangrajvir@gmail.com): Web developer and Project manager with more than 4 years experience. I work on LAMP, AJAX, php frameworks like symfony, codeigniter … and Javascript frameworks like JQuery, JQueryUI, Prototype and more… I have more then 3 years of experience on symfony framework and provide any kind of solution.

New plugins

• sfDoctrineFaq: allows you to embed a FAQ module within your symfony application with backend modules to manage categories and questions.
• sfMultiTenant: allows you to create a multi-tenant-aware application. The plugin lets you add a tenant identifier column & reference the Tenant model, populate the tenant identifier column when saving records and adapt select queries to filter records for a tenant.
• sfAuditable: allows you to automatically create audit fields in the model (e.g. created_by, updated_by, …) and populate user details in these fields when a row is created or updated.
• sfActivateable: allows you to automatically create a is_active flag (or name of your choice), create timestamp & user detail fields (e.g. activated_by, activated_at, …) and populate timestamps & user details when is_active flag is toggled on a record.
• sfObjectLink: allows you to identify the object type & object owning the record in the model by automatically create obj_type_id & obj_id fields on the model which need to be programatically populated.
• sfCk: offers an unobtrousive integration between the CK WYSIWYG editor and symfony.
• sfGagatemplate: integrates Gagatemplate engine in symfony.
• sfAdminHijack: simple JQuery widget for doctrine one-to-many relations that “hijacks” a generated admin module for its functionality.
• smagBootstrap: reads and parses tasks from a yaml file and executes them.
• sfGoogleChart: allows the use the Google Chart API in your symfony project.

Updated plugins

• lyMediaManager:
  • improved error checking on asset file/folder deletion
  • made small changes to default list view
  • updated README with instruction on how to customize list view layout
  • improved error checking on asset/folder creating, moving, renaming, deleting operations
• sfPHPUnit2:
  • updated documentation
• csDoctrineActAsSortable:
  • fixed moveToLast failed because of “moveToPosition requires an Integer as the new position
  • fixed moveToPosition moving down failed because of integrity constraint violation

• sfTrafficCMS:

  • added subnav
  • checking for images relation rather than assuming it
  • added slot to indicate the page being show for use with a nav menu on-state

• ExtjsGenerator:

  • added filterinputdate widget
  • added check so gridpanel javascript and css files are not included when listpanel is used
  • added allowClear and defaultValue to ux.TwinDateField
  • fixed quoting of iconCls for edit and list action buttons when iconCls is in the generator configuration
  • changed buildQuery and filter classes to support adding queryMethods and with statements before the form criteria is created
• sfAssetsLibrary:
  • preparations for using sfAssetsLibraryPlugin as browser for CK Editor
  • added to documentation how to use sfAssetsLibraryPlugin with CK Editor

• sfDoctrineTaggable:

  • fixed bug in getTaggings() when a non existing tag is requested
  • added unit tests
  • fixed bug in getRelatedTags()
  • changed findOrCreateByTagname() so that it is not static anymore
• cleverFilesystem:
  • in the case of a local disk filesystem, the cache method now returns the original filename, as caching is useless
• sfTaskLogger:
  • modified sample task short description
• diemProject:
  • added filter to prevent throwing exception on non-textual :input elements
  • enhanced to use `System / Dev / Server` admin action available in production environment
• apostrophe:
  • re-ordered a media item portion of the migration task
  • categories have been refactored (Apostrophe now has one set of categories, replacing the redundant implementations for the media repository and the blog plugin)
  • fixed overlay bug where the edit button for a selected image in a slideshow could not be clicked
  • fixed markup for Download Original button
  • implemented migration of existing category refclass data
  • fixed migrations for existing categories and assignments of existing media items to categories
  • getAllTagNameForUserWithCount now respects the pre-filtered categories for media engines
  • added the File slot, which is similar to the PDF slot (now deprecated) but allows any downloadable media type, thus providing a nice way to call attention to other file types
• apostropheBlog:
  • the apostrophe:migrate hooks that add blog plugin tables were accidentally disabled
  • categories have been refactored, moving quite a bit of code upstairs to apostrophePlugin

They talked about us

• Symfony2 PR3
• JustMarried : mise en place du projet Symfony2
• Interesting symfony plugins: sfBehatPlugin
• Symfony CMF
• sfAdminHijackPlugin – Hijacking a symfony admin module to manage doctrine one-to-many relations with JQuery modal dialogs
• Propel 1.6 + phpsh = Awesome CLI to your Database
• Conférencier à l’OSDC et Forum PHP 2010
• Propel2 and Doctrine2: Together but not scrambled
• A quick start guide for sfImageTransformExtraPlugin (for use with doctrine or propel records)
• Rilasciato symfony 1.4.7
• Interview with Frantisek Troster and Ludek Vodicka (Inventic)
• sfAdminHijackPlugin – How a hijacked symfony admin module will look like
• To JCR or not: Choosing the right persistence solution for the Symfony CMF
• Speaking at the International PHP Conference and SymfonyDay
• Rilasciato symfony 1.4.8
• Se publican Symfony 1.3.8 y 1.4.8
• symfony 1.3.8 and 1.4.8 released and available at ServerGrove
• symfony ? Web API ???????????????? | tech.kayac.com – KAYAC engineers’ blog
• symfony ? Web API ????????????????
• Here is my 2 cents on Doctrine (ORM)
• symfony 1.4????????????
• Overview of PHPEdit extension for Symfony
• Symfony mit schnellem Bugfix
• Mac OS X & Symfony – problem z build-all
• ???????????symfony?????????????
• Include partial from app/template directory in symfony
• sfMobileIPPlugin?symfony 1.4??????
• [Symfony]Symfony2.0??