Firstly, I have to apologize. I have been busy with some personal
things and also been looking for a new job, so I haven't had a
lot of time to update my blog.
I have read something on Coding Horror (which is a really good blog, by the
way) about whats called "analysis paralysis".
I myself, often get stuck in this stage. Especially in a
paradigm-rich environment like java, which gives you many
philosophies about how to do things more effectively, when I
myself have to admit that it would take less time to just start
to do some code and make corrections later. For the people, that
have been following my blog, I do talk a lot about theory and not
a lot about action. This is something I would very much like to
change. So I plan to take my idea for " …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
mysql connector/odbc 5.1.1-beta is
available.
we didn?t implement all of the features in our original plan, but
we decided to close out 5.1 to new features so that we could work
on getting it to a production (GA) release as soon as
possible.
5.1 has it?s share of bugs still, but we have tackled
the most serious ones, and now that we are done with features
(for the time being) we can focus on making the GA release
shine.
now the race is on to see who gets out a 5.1 GA release first ?
the server or connector/odbc!
Today to debug one of the issue related to InnoDB where the INSERT INTO .. SELECT simply bails with an error as “ERROR 1105 (HY000): Unknown error”; I simply started loading the data onto 5.1 server as it was consistent in 4.1 version (even though it was noted as fixed). So, LOAD DATA INFILE suddenly pops with an error as ..
| [Copy to clipboard][-]View Code | |
1 2 3 4 5 6 7 8 9 |
mysql> LOAD DATA LOCAL INFILE 'venudata-all.txt' INTO TABLE DOCUMENT_DESC FIELDS TERMINATED BY ',';
ERROR 1148 (42000): The used command IS NOT allowed with this MySQL version
mysql> SHOW variables LIKE '%infile%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| … |
- Flickr Stats how is it built.
- All Collection is done realtime
- MYISAM and INNODB is used
- The data is spread across 6 clusters (12 servers-6 used, 6
for fail over) mainly for data storage requirements
- Memcache is not used at all in the core of the product.
In summary this was the longest project that I worked on, other
then rebuilding the backend for Flickr when I first came on. The
inner workings are very complex to achieve real-time
collection-while not affecting page load times of a photo page.
Most of my time was spent on creating a distributed lock once my
DB design was solid.
Things that would really make life easier:
MYSQL AB gets rid of MYISAM and makes PBXT its replacement. I
don't need all the great features of INNODB but I would like
some. I'll go more into this later.
…
Wohoo! Jon Stephens just published an excellent article on the possibilities for
working with XML and MySQL on the MySQL devzone!
I'm very proud that he chose to highlight the lib_mysqludf_xql library of MySQL User Defined
functions authored by Arnold Daniels. Some time ago, Arnold joined the
MySQL UDF Repository and so far he's been the
most active member of the group.
Arnold also took the …
I’ve written an article highlighting some recent developments with XML support in MySQL 5.1 and MySQL 6.0. Topics include:
- Outputting MySQL data in XML format; includes a look at the 3rd-party lib_mysqludf_xql library
- Getting XML into MySQL; includes a discussion of the LOAD XML statement (new in MySQL 6.0)
- The ExtractValue() and UpdateXML() functions (new in MySQL 5.1)
- Security issues, including a look at a little nasty known as “XPath injection”
You can read it at the MySQL Developer Zone.
Alexander Barkov contributed a nifty stored procedure and a very helpful pre-publication review. Thanks, Bar!
I constantly wonder what my former co-workers would say if I popped into work wearing what I have been accustomed to wearing since I joined MySQL AB in July 2007. Would they actually get used to me showing up in nothing but shorts, sleepily stretching out in front of the computer, boiling a a cup of tea and then trundling into the office laptop in one hand and hoping that no video conference would be required today?
It’s the beauty of MySQL: 80% of the company works on a distributed basis, as in out of their homes. With IRC, phone and email, if you can avoid video, you can pretty much be sitting naked while you work if that is your preference. But wait, there’s more. It means that you can work from anywhere in the world: An airport, in the car, in the train and ultimately in a completely foreign country. I promised that six months after I joined the company I would reflect on …
[Read more]In yet another sign that the world's leading software companies are losing their inhibitions around open source, Adobe announced today the launch of the open-source BlazeDS project, high-performance remoting and messaging technology used to "connect back-end data sources to rich Internet applications written with its Flex development tool." This is very cool.
BlazeDS will be made available for free under the Lesser General Public License (LGPL). Adobe will initially hosts the open-source project and next year plans to create a separate site to host BlazeDS and its Flex developer tool which it intends to open source, said Phil Costa, director of product management for Adobe's Platform Business Unit.
The software is not meant to replace other messaging products, such as enterprise service buses, Costa said. Instead, it can get data from messaging software …
[Read more]Today MySQL releases the first beta version of MySQL Connector/ODBC 5.1. This means that Connector/ODBC 5.1 is now feature complete. Go download it!
Connector/ODBC 5.1 is suitable for most MySQL versions in active use today. It works with MySQL 4.1, 5.0, 5.1 and 6.0. If anyone is still on 4.0 or earlier releases, you should have upgraded ages ago; consider Connector/ODBC 5.1 “the final straw”.
As I wrote in September when we released the alpha version,
It is a partial rewrite of the the original MyODBC 3.51 code base, originally developed by Monty and Venu Anuganti, including individual parts of the current 65K ODBC 5 code base.
The new ODBC 5.1 driver, like 3.51, supports all relevant platforms …
[Read more]Stefan Hinz, MySQL’s Docs Team Lead, just showed me the new restructured documentation overview page http://dev.mysql.com/doc/. The intention of the restructuring is to make it easier for you to find the information you need.
We’ve amended the MySQL
Reference Manual section with a subsection labeled
“Excerpts from the Reference Manual“, examples
of which are a standalone Connectors book (covering all MySQL
connectors and APIs) and guides for each individual MySQL
Connector.
The key new document there is the “MySQL Server Version Reference” that should make life easier for everyone who needs cross-version …
[Read more]