My initial posting about using Zeroconf host names and Virtual Appliances on wasn’t quite complete…
It should be added that in order for Zeroconf-assigned host names (ie. in the form of https://mysql.local.) to resolve on Windows, it is necessary to install Apple’s Bonjour package. Without this, the system is unable to resolve Zeroconf host names.
For modern Linux distributions, the nss-mdns GNU Name Switch Service (NSS) plugin is necessary …
[Read more]MySQL Connector/ODBC is our next generation ODBC driver which allows access to the MySQL server using the ODBC standard - a cross-platform, cross-database C Call Level Interface. This version is being released to get community feedback but is NOT suitable for production environments. It is now available in binary form from the Connector/ODBC download pages at http://dev.mysql.com/downloads/connector/odbc/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can’t find this version on some mirror, please try again later or choose another download site.)
Install Notes
Please uninstall any existing Connector/ODBC v5 before installing this version.
Changes
At our MySQL Camp Jay and Brian pitted off in the Umbrella Joust. Not sure if there was a winner, or a looser, but in the end no blood was split (except Leslie, but that’s another story).
See these and more camp photos at Flickr.
New Report From The 451 Group Serves as a Practical Guide for Understanding and Calculating the Financial Benefits of Open Source, The 451 Group (Press Release)
Intalio Releases Most Standards-Compliant BPMS, Intalio (Press Release)
Palamida Announces Product Enhancements to Help Companies Leverage Sun’s Decision to Open Source Java Technology, Palamida (Press Release)
OASIS Forms Committee to Standardize Content Analytics Complementary Open Standards and Open Source Efforts Launch, OASIS (Press Release)
…
[Read more]Zmanda specializes in backup and recovery solutions. First they gave the world Amanda, and now they've given MySQL users a new reason to rejoice with the launch of Zmanda Recovery Manager (ZRM) for MySQL. I recently got to speak to Paddy Sreenivasan, the Vice President of Engineering and co-founder of Zmanda Inc., amidst his busy schedule, about what they do and why MySQL users should be jumping towards ZRM for MySQL for all their backup & recovery needs.
Running RPM based or other packaged MySQL Binary you may have a problem if you would like to rebuild binary for some reason - change some build settings, apply some third party patches or simply try latest snapshot (This time I was both applying patches for Innodb scalability and Vadim's patches to get proper slow query log). There are number of things as default paths and GCC build and link options you would like to keep the same as in original binary to minimize the change and finding this was not pleasant.
This time however Vadim advised me better solution - run mysqlbug script and get configure options from it. This is so easy.
After build is completed I simply take mysqld from sql directory and try it out as this is the only piece which I'm interested in. Quick to try, quick to rollback. You may run make install though if you need to but better to be ready to reinstall rpm after it
Back at our users conference in April we announced our pluggable storage engine program encouraging developers to extend MySQL with new innovative engines. Not only have we expanded our internal development with engines like Falcon, Cluster and others, but we're seeing significant new developments from the MySQL ecosystem. The pluggable storage engine architecture enables us to work with partners and with the community to reach a much broader range of needs with MySQL than we could on our own.
There are two new storage engines coming out of stealth mode. Both help strengthen MySQL in the rapidly growing Data Warehousing market, coming at …
[Read more]Unisys, which was the first large system integrator to build out an open source practice, has expanded its open source arsenal to include Alfresco, the open source alternative for Enterprise Content Management. From the press release:
The agreement enables Unisys to offer a team of Alfresco-certified consultants who can migrate, implement and deploy content and records management solutions based on open source software. Adding this team and capability rounds out an impressive Unisys worldwide set of ECM resources and solutions built around best-in-class ECM software products and providers.
The alliance also singularly positions Unisys, with its services-led solutions approach, to deliver highly scalable and available Alfresco implementations based on new open source or hybrid stacks. …
[Read more]Relational databases use indexes to speed up their performance usually due to the fact that their underlying storage is inherently slow (which has historically meant disk).
I've often created secondary indexes with MyISAM which aren't used in day-to-day operation but that are needed for debugging or exploration of the database.
For example, if you were to have a USER table with a handle (their account name) and an ID (the primary key) you could index by the handle but usually these are long strings and take up a good amount of CPU time to build the index and memory to cache the index.
It dawned on me the other day that this isn't necessary with MySQL Cluster (NDB). With MyISAM you need to use an index because a full table scan might take 10-20 minutes and hold back any INSERTs in the process which could become a big problem.
It also has secondary problems including confusing the OS level page cache and …
[Read more]
