Our new LAMP Virtual Appliance provides turnkey Apache HTTP Server, PHP, Perl, Python, and MySQL in one easy to use 65MB download.
This appliance features optional use of virtual hard disks for MySQL and web content. Uniquely, this Virtual Appliance shares the web content via CIFS/Windows Networking for extremely easy to use content publication and mnagement. Many popular web applications can be deployed using this appliance.
As usual, free to download and use …
[Read more]Next week, backup experts from Zmanda, will present a webinar on how you can use ZRM for MySQL to backup your MySQL server remotely over the internet. If you are a ISP or host your own site, you would want to attend this webinar. For that matter, the infromation will be useful for any MySQL dba. This is a technical seminar where we will go through step by step of actually implementing the solution. We already published a detailed white paper on this topic. You can get to that white paper by registering with Zmanda Network.
Hope to see you at the Webinar.
|
Contrary to some reports in the community, MySQL will continue providing binaries both for Windows and other operating systems. All our download pages, including those for MySQL 5.0, have binaries today, and will continue to have them.
The source-only releases we introduced with 5.0.33 (and will continue to provide in the future)are just in addition to the binary-and-source releases. The current latest binary-and-source MySQL Community Server release is 5.0.27, and I expect MySQL 5.0.35 Community Server to be released as binary-and-source within a month, both for Windows and our other platforms. …
[Read more]Jonathan Haddad writes about REPLACE INTO and INSERT ON DUPLICATE KEY UPDATE. Really, Why MySQL has both of these, especially both are non ANSI SQL extensions ?
The story here seems to be the following - REPLACE INTO existed forever, at least since MySQL 3.22 and was a way to do replace faster and what is also important atomically, remember at that time MySQL only had ISAM tables with table locks and no transactions support. Of course you could use LOCK TABLES but it is not efficient.
The reason REPLACE could be efficient for ISAM and MyISAM, especially for fixed length rows is - it could perform row replacement without reading old data first, and of course because you could set it to replace multiple values at the same time just as you have multiple value INSERT.
As a side note: the …
[Read more]
The objective of this exercise is compiling MySQL from a source
tree (BitKeeper) on Mac OS X.
I bought a new laptop, a MacBook running Mac OS X Tiger. I was
captivated by the user interface, and I was willing to try this
new experience, after a long and successful relationship with
Linux (I gave up Windows many years ago). Everything went well,
until the moment I tried to compile MySQL from source.
Using the default Xcode tools, I was able to compile the source
packages provided with the GA release (5.0.x). But with 5.1 it
was a different story. I was not even able to complete the
compile part. something was breaking quite soon during the
process.
After unsuccessfully trying all the tools made by the MySQL Build
Department, I finally decided to take things into my own hands,
and to create a reliable compiling environment.
I - Isolating the environmentI decided that the sanest course of
action was to get the …
There have been a lot of good talks at linux.conf.au so far that I’ve attended (and the one’s that I’ve missed due to scheduling difficulty, I’ve already started watching some videos of). There are lots of good reports about it on Planet Linux Australia even, but one of the most useful talks in my opinion was Jono Bacon’s talk on Herding Cats and Influencing People (watch the video when its uploaded), his thoughts on running a Community.
He talked about McDonalds, and how they package things, that are consumable by all (his point was that projects generally might even need bite size tasks, not get new contributors chucked into the deep end). Which got me thinking, a little more. McDonalds are in the real estate business, and they’re one of the major players in the fast food industry. I’ve always believed that there are too many Linux distributors in the market, …
[Read more]REPLACE INTO will actually perform a delete and then an insert, while INSERT … ON DUPLCIATE KEY UPDATE will perform an update (as the name suggests). I would think the latter would be faster. I have not done any performance testing between the two, but it only seems logical the update would be faster than the delete/insert. Please correct me if I’m wrong.
Since the two statements both end up with the same result, I’m not sure yet what the benefit of REPLACE into it.
Yes, I realize both are MySQL additions, so please don’t bother telling me they’re not ANSI standard.
References:
Although I have not updated the website, documentation, or how to for mysqlsla, I am tossing mysqlsla v1.4 “out there” to view or wget at:
http://hackmysql.com/scripts/mysqlsla-1.4
I don’t like to release new versions without having everything else updated too, but for various reasons I’m making an exception this time.
mysqlsla v1.4 is much better than v1.3 and a lot has changed. So much has changed that the entire script was essentially re-written. Without an updated doc or how to, I suggest starting with the –help command line op, then contact me if you have specific questions or issues. I will, eventually, update the website, doc, how to, and officially package this new version.
With the start of the new year there are around 20 new job openings at MySQL. There are worldwide positions available for web developers, software developers, support engineers, consultants, trainers, QA engineers and more. Take a look at www.mysql.com/jobs for more information.
One of the new features in upcoming MySQL 5.1 Server will be the Event Scheduler. This feature was implemented by Andrey Hristov within the scope of a master's thesis for the University of Applied Sciences in Stuttgart. We incorporated his contribution into our code base - you can read more about this feature in this article from Peter Gulutzan. Andrey is now employed by MySQL AB as a Software Developer. Lenz Grimmer asked him if he would be interested in sharing his story and provide some more background about himself.