A survey of more than 400 developers showed that MySQL is closing the lead Microsoft's SQL server has in emerging markets. More than 50 percent of developers in the emerging market countries said they are using Microsoft's SQL Server, but 46 percent said they are using MySQL.

This is another great news, after the results coming from the european SMBs survey. The adoption and usage of MySQL is still growing despite the economic downturn. Go MySQL!

The NoSQL event in New York had a number of presentations on non relational technologies including of Hadoop, MongoDB and CouchDB.

Coming historically from a relational background of 20 years with Ingres, Oracle and MySQL I have been moving my focus towards non relational data store. The most obvious and well used today is memcached, a non persistent distributed key/value pair store. There are a number of persistent key/value stores in the marketplace, Tokyo Cabinet, …

Reference: MySQL Manual

If you are trying to evaluate some free open source application available on various websites(which are especially developed using PHP) and when the application try to access newer version of MySQL server you may end up seeing a error message like below


Client does not support authentication protocol requested by server; consider upgrading MySQL client


 Reason for this unwanted welcome message is that In older versions of PHP, the mysql extension does not support the authentication protocol used in MySQL 4.1.1 and higher. This is true regardless of the PHP version being used. If you wish to use the mysql extension with MySQL 4.1 or newer, you may need to follow one of the options discussed above for configuring MySQL to work with old clients. The mysqli extension (stands for "MySQL, Improved"; added in PHP 5) is …

6.3.27a and 7.0.8a source releases are now available from ftp://ftp.mysql.com/pub/mysql/download/cluster_telco/

The source releases for MySQL Cluster 6.3.27 and 7.0.8 have been withdrawn so that a bug can be fixed; new versions should be out very soon.

A regression in MySQL Cluster 7.0.8 and 6.3.27 has caused them to be removed from download.

Problem:
If you have a mysql server with higher node id than 49, then it will cause cluster to crash.

An updated version of MySQL Cluster 7.0.8, called 7.0.8a will be released very soon.

The Configurator has been reverted back to use 7.0.7 and 6.3.26.

Patents. M&A. Adoption. Business strategies. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

This bumper edition of 451 CAOS Links is brought to you courtesy of the Open World Forum’s temperamental wireless connection.

Patents
# Red Hat urged the Supreme Court to to make clear that it excludes software from patentability, while the SFLC and the FSF also filed briefs with the US Supreme Court arguing against software patents.

Investment and M&A
# The WSJ …

Error message:Slave I/O thread: error reconnecting to masterLast_IO_Error: error connecting to masterDiagnosis:Check that the slave can connect to the master instance, using the following steps:Use ping to check the master is reachable. eg ping master.yourdomain.comUse ping with ip address to check that DNS isn't broken. eg. ping 192.168.1.2Use mysql client to connect from slave to master. eg

Error message: Slave I/O thread: error reconnecting to master Last_IO_Error: error connecting to master Diagnosis: Check that the slave can connect to the master instance, using the following steps: Use ping to check the master is reachable. eg ping master.yourdomain.com … Continue reading →

Ok, I know that most of you reading this would think of this as painfully obvious, but it's also clear that a lot of beginning mysql users are timid about actually diving in and discovering answers. In an effort to answer fewer simple questions, I'm hoping to get this out to more people who may be beginners with mysql.

The most common barrier seems to be "I don't have a test environment!" This is easily remedied:

1. Even if your production enviroment is linux, you can still install mysql on your windows-based workstation to play around with. The installation on any environment can be done in minutes, so lack of SQL is not a good excuse.

2. The perfect companion for testing mysql is MySQL Sandbox. You can even test replication setups!

3. Even if you just have a production environment, small test cases can be done inside a …

I’ll be attending and presenting at the 2009 Central Pennsylvania Open-Source Conference. My session is on Maatkit. I see Tom Clark has a session on MySQL performance! I hope to see you there — I’ve really become a fan of these regional conferences.

By the way, I’ve also created a speaker badge by adapting a wallpaper someone else made — you can find it on the sidebar of my blog if you’re also a speaker.

Related posts:

1. Speaking about Maatkit at CPOSC I’m
2. Speaking at EdUI Conference 2009 I’m

3. …