Planet MySQL

Log Buffer #96: a Carnival of the Vanities for DBAs

posted by Dave Edwards on Fri 09 May 2008 16:37 UTC

This is the 96^th edition of the weekly review of database blogs, Log Buffer.

Let’s start this one in SQL Server Land, with a question from Dennis Gobo. First, should SQL Server have the CREATE [OR REPLACE] PROCEDURE syntax? There are, he writes, advantages: “When scripting out a database you don?t have to generate if exists…..drop statements,” and disadvantages: “I can overwrite a proc without even knowing it.” Of course, the commenters have opinions of their own, and the piece becomes a straw poll for the desirability of that syntax as a feature.

Aaron
[Read More...]

Linux: How do you rename a user account in linux?

posted by Sunny Walia on Fri 09 May 2008 11:13 UTC

In Linux, there is no command which will rename a user account. If you make a mistake creating a user account, user changes their name or if user does not like his user name, there is no real easy way of going and making the change. Only thing I know you can do is [...]

posted by The Aquarium on Fri 09 May 2008 08:00 UTC

You may have seen Jonathan's note on OpenSolaris, MySQL and GlassFish being available on Amazon EC2.

Details on the OpenSolaris portion are available at the EC2 Blog (Welcome, Launch and New

[Read More...]

MySQL enjoying its new home

posted by Lukas Smith on Fri 09 May 2008 06:16 UTC

So it seems that Sun has made it clear that the core product will remain open source. Of course the definition of what is core and what isn't is up to Sun/MySQL to decide, but it seems that overall more things will be released as open source than if MySQL would have gone through with its planned IPO. So this is a good thing. Speaking of non core products, I really like what Mike and his team are doing in the GUI department with the workbench and their other GUI tools. However since Sun is friendly to

[Read More...]

Pics from CommunityOne & JavaOne

posted by Barton George on Fri 09 May 2008 02:18 UTC

Here are a few pictures from earlier this week taken at CommunityOne and day one of JavaOne.

Podcasts a comin'

In the next few days I will also be posting a bunch of podcasts I did while in San Francisco including a bunch from key OpenSolaris folks, a post-Distro-smackdown recording, an interview with the Fedora IcedTea guys and a chat with the JRuby dudes.

[Read More...]

PHP: PDO_MYSQLND 1.0.2-alpha released

posted by Ulf Wendel on Thu 08 May 2008 20:27 UTC

I am glad to announce the availability of the first alpha version of PDO_MYSQLND. PDO_MYSQLND is a PHP PDO driver for MySQL based on the MySQL native driver. PDO_MYSQLND 1.0.2-alpha is available for download on http://downloads.mysql.com/forge/pdo_mysqlnd_preview. Please read the announcement and check the MySQL Forge project page on PDO_MYSQLND for further information.

What is PDO_MYSQLND?

PDO (PHP Data Objects) is a data-access abstraction layer for PHP. PDO consists of a core and a rich set of database specific drivers. Traditionally there has been one PDO driver for MySQL called PDO_MYSQL. PDO_MYSQL is a

[Read More...]

Free and Open Source Software: Use and Production by the Brazilian Government

posted by Colin Charles on Thu 08 May 2008 18:47 UTC

First up, I want to say, I’m truly impressed with Brazil. One day I will visit this amazing place, and spread the good word of open source with projects that are close to my heart: MySQL, OpenOffice.org, Fedora, and in due time, a lot more. This is a live-blog, from a most interesting talk, at JavaOne 2008. As I wrote on Twitter, “Brazil, simply impresses me. Their use of open source in government, makes me think that the rest of the world has a lot to learn from them”.

Free and Open Source Software: Use and Production by the Brazilian Government
Rogerio Santana <rogerio.santanna@planejamento.gov.br> +55 61 313 1400, Logistics and Information Technology Secretariat
Planning, Budget and Management

posted by Jonathan Schwartz on Thu 08 May 2008 17:32 UTC

We made some big announcements this week at our annual developer forums, CommunityOne and JavaOne. I thought I'd highlight a couple in particular.

We announced the first commercial release of OpenSolaris - targeting high speed developers and development teams (not consumers...). OpenSolaris focuses on developers wanting to be freed from proprietary software models, who see innovation and automation in operating systems as a source of competitive advantage.

If Solaris 10, OpenSolaris's older brother, is for IT departments prioritizing carrier grade stability over rapid innovation, OpenSolaris targets the exact opposite - developers, from high performance computing

[Read More...]

Who's the geek?

posted by Giuseppe Maxia on Thu 08 May 2008 16:04 UTC

An article on PostgreSQL online gives a quick assessment of the difference between MySQL and PostgreSQL.

PostgreSQL people look like a gang of geeks and Martin Mickos looks polished

Who's the geek in this picture?

UAE Broken Proxys - how to work around them

posted by Dathan Pattishall on Thu 08 May 2008 13:42 UTC

In the UAE there is a goverment enforcement of all traffic to go through goverment proxy servers. All requests are proxied and cached. What does this mean in the mysql world? Imagine you have a web application that records comments to a media object. Then a single person from the UAE makes a comment to that media object. The UAE Cache Proxy caches the HTTP-POST. Now every person in the country that visits your domain causes a HTTP-POST to that same media object. From a outside view it looks like content is being added to the system and the numbers are good. But ALL THE CONTENT is the SAME which is not valuable to the media owner nor the DBA who has to manage that data due to the BROKEN-CACHE-PROXY.

So how do you bust the BROKEN-CACHE-PROXY?

A simple method is to look at the contents of the last few posts and see if the same data is being added prior

[Read More...]

What is PDO_MYSQLND?

Top 30 Most Active

MySQL Links

Other Links

Planetarium