Planet MySQL

Webinar on migrating SQL Server to MySQL

+0

-0

posted by Reggie Burnett on Mon 14 Dec 2009 17:32 UTC
Tags:

(edit) mysql, Technology

We have an exciting webinar coming up tomorrow (12/15) on migrating from SQL Server to MySQL. LiveTime Software is a leader in ITIL service management and help desk products. They have started offering a free migration service and this webinar will go over everything from toolsets used to character sets.

You can read more about it and register for this webinar here (http://mysql.com/news-and-events/web-seminars/display-466.html). So I know you have an hour you can spare and when it comes time to renew that SQL Server license you’ll be glad you did.

[Read more...]

Whatever Happened to "Do No Evil?"

+1

-3

posted by Zack Urlocker on Tue 01 Dec 2009 08:51 UTC
Tags:

(edit) mysql, Technology, Misc, Google, Music, JBoss, Blogger, ad sense, ad words, disclosure, doug marks, Fleury, FTC, metal method, scam review sites

A buddy of mine, Doug Marks, recently opened my eyes to some sites that are putting out misleading product reviews fueled by Google Ad Words. I wrote about this on my InfoWorld blog with a story entitled "FTC and Google need to crack down on scam review

[Read more...]

Digg Moved from MySQL to Cassandra?

+0

-0

posted by Mike Kruckenberg on Wed 18 Nov 2009 01:18 UTC
Tags:

(edit) Technology

At today's Web 2.0 Expo keynote with Kevin Rose and Jay Adelson they mentioned they'd done a lot of architecture work on Digg including moving things from MySQL to Cassandra.

I guess something like this was on the table in 2006, mentioned in this O'Reilly article, but the comments clear it up as more of a "we've thought about it and are sticking with MySQL."

This whole idea of NoSQL, and that developers would rank performance over normalization and ability to use joins is interesting. At today's NoSQL talk there was a good

+0

-0

posted by Reggie Burnett on Mon 16 Nov 2009 18:10 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.1.3, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.1.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.)

This release builds on the cool new features introduced with 6.1.2 and adds the following changes/bugfixes.

fixed session state provider table definition to allow more than 64K per-session data (bug#47339)
fixed compilation problem in

+0

-0

posted by Reggie Burnett on Mon 16 Nov 2009 18:04 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.2.1, a new version of the all-managed .NET driver
for MySQL has been released. This is a beta release and is intended to
introduce you to the new features and enhancements we are planning. This
release should not be used in a production environment.

It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.2.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.)

The new features or changes in this release are:

fixed SessionProvider to be compatible with 4.x MySQL, replaced TIMESTAMPDIFF with

+0

-0

posted by Reggie Burnett on Mon 16 Nov 2009 06:10 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.1.3, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.1.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.)

This release builds on the cool new features introduced with 6.1.2 and adds the following changes/bugfixes.

fixed session state provider table definition to allow more than 64K per-session data (bug#47339)

+0

-0

posted by Reggie Burnett on Mon 16 Nov 2009 06:04 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.2.1, a new version of the all-managed .NET driver
for MySQL has been released. This is a beta release and is intended to
introduce you to the new features and enhancements we are planning. This
release should not be used in a production environment.

It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.2.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.)

The new features or changes in this release are:

fixed SessionProvider to be compatible with 4.x

+0

-0

posted by Reggie Burnett on Thu 12 Nov 2009 15:30 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.0.5, a new version of the all-managed .NET driver
for MySQL has been released. This is a maintenance release and is approved for use
in all situations.

It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.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.)

There are lots of bug fixes in this release so please review the change log.

Thank you!

MySQL Connector/Net 6.0.5 has been released

+0

-0

posted by Reggie Burnett on Thu 12 Nov 2009 03:30 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.0.5, a new version of the all-managed .NET driver
for MySQL has been released. This is a maintenance release and is approved for use
in all situations.

It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.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.)

There are lots of bug fixes in this release so please review the change log.

Thank you!

+1

-0

posted by Reggie Burnett on Wed 21 Oct 2009 17:36 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.2.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.2.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.)

The new features or changes in this release are

Connection pool cleanup timer. We now utilize a timer that cleans idle connections that are no longer connected every 3 minutes

+0

-0

posted by Reggie Burnett on Wed 21 Oct 2009 05:36 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.2.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release and is intended to introduce you to the new features and enhancements we are planning. This release should not be used in a production environment.

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.2.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.)

The new features or changes in this release are

Connection pool cleanup timer. We now utilize a timer that cleans idle connections that are no longer connected every 3 minutes
We

[Read more...]

AWS Management Console is nice

+0

-0

posted by Haidong Ji on Mon 05 Oct 2009 03:26 UTC
Tags:

(edit) mysql, Technology, Windows, Linux, Web

If you want to play with Amazon cloud computing stuff, I think using AWS Management Console web interface is the best, easiest, and most intuitive approach, based on my experience so far.

My usage with Amazon Web Services has been only with EC2 up to this point. Prior to AWS Management Console, I had to set up Java, EC2 API tools, various path and environmental variables, certificates, keys, etc., etc.. It is a fairly convoluted process.

AWS Management Console is much easier, except for downloading PuTTY and PuTTYgen on Windows and tsclient on Linux, and a private key pair, everything else is handled inside the browser. Here are a few things I learned:

Once you are in, create a Key Pair. The web interface will prompt you to save it. Do so, because you will need it to start

+0

-0

posted by MC Brown on Mon 05 Oct 2009 01:46 UTC
Tags:

(edit) mysql, General, Technology, Databases

Feels like a long time ago, but my talk at the MySQL User’s Conference back in April 09 on running MySQL Multiple Times to get better performance is now available online at YouTube. The original PDF of the presentation is available here.View it here: YouTube – Improving Performance by Running MySQL Multiple Times

YouTube – Improving Performance by Running MySQL Multiple Times

+0

-0

posted by Martin 'MC' Brown on Sun 04 Oct 2009 18:46 UTC
Tags:

(edit) mysql, Technology, Databases

Feels like a long time ago, but my talk at the MySQL User’s Conference back in April 09 on running MySQL Multiple Times to get better performance is now available online at YouTube. The original PDF of the presentation is available here.

View it here: YouTube – Improving Performance by Running MySQL Multiple Times

MySQL Connector/Net 6.1.2 GA has been released

+1

-0

posted by Reggie Burnett on Tue 08 Sep 2009 19:41 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.1.2, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!

It is now available in source and binary form from [http://dev.mysql.com/downloads/connector/net/6.1.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.)

This release introduces a couple of exciting new features.

Website Configuration Dialog -- This is a new wizard that is activated by clicking a button on the toolbar at the top of the solution explorer. It is meant to work in conjunction with the ASP.Net

[Read more...]

MySQL Webinars in the upcoming weeks...

+0

-0

posted by Luca Olivari on Thu 27 Aug 2009 14:41 UTC
Tags:

(edit) mysql, Technology, Databases, webinars

After the slow down due to vacation and warm weather we are ready for a series of educative Italian webinars on MySQL. Here is the list:

Semptember 10@10am CET - "Top 5 Tuning tips for MySQL (http://www.mysql.it/news-and-events/web-seminars/display-390.html)"
Are your applications slow during peak times? Is the database running slowly? Do you find difficult to pinpoint performance problems? Then this webinar is for you!I will cover the top 5 tips to speed up your MySQL databases from a developer as well as DBA point of view.

October 8@10am CET - "Introduction to MySQL for Windows (http://www.mysql.it/news-and-events/web-seminars/display-421.html)"
Do you know that MySQL is used extensively on Windows? Would you like to learn the tools that we provide?
Join this webinar! We will discuss the

[Read more...]

MySql Connector/Net 6.1.1 beta has been released

+0

-0

posted by Reggie Burnett on Thu 20 Aug 2009 03:58 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.1.1, a new version of the all-managed .NET driver
for MySQL has been released. This is a beta release and is intended to
introduce you to the new features and enhancements we are planning. This
release should not be used in a production environment.

It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.1.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.)

This release introduces a couple of exciting new features.

Website Configuration Dialog -- This is a new wizard that is activated

+0

-0

posted by Masood Mortazavi on Wed 19 Aug 2009 07:27 UTC
Tags:

(edit) mysql, Technology, Databases, tests, binaries, current, pushbuild

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!

Advancing MySQL Open Development One Important Step Forward

+0

-0

posted by Masood Mortazavi on Wed 19 Aug 2009 00:27 UTC
Tags:

(edit) mysql, Technology, Databases, tests, binaries, current, pushbuild

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!

Advancing MySQL Open Development One Important Step Forward

+0

-0

posted by Masood Mortazavi on Wed 19 Aug 2009 00:27 UTC
Tags:

(edit) mysql, Technology, Databases, tests, binaries, current, pushbuild

Giuseppe Maxia writes about the availability of the active development/test ("pushbuild") MySQL binaries for users—on multiple platforms.

This is a wonderful step forward in bringing greater openness to current MySQL development and in bringing greater value to the MySQL user community!

MySql Connector/Net source code has a new home!

+1

-0

posted by Reggie Burnett on Wed 12 Aug 2009 20:46 UTC
Tags:

(edit) mysql, Technology, .NET

I would like to proudly announce that we have migrated our Connector/Net source code repositories to LaunchPad (www.launchpad.net) and are using BZR for our source control. We have taken our old public SVN repository (http://svn.mysql.com/svnpublic/connector-net/) offline.

We will be using LaunchPad for source control and feature management. This means we'll use blue prints and the series system. We will continue to use our existing bugs database found at bugs.mysql.com and our existing forum found at forums.mysql.com.

You can find the new source repositories for Connector/Net at https://launchpad.net/connectornet. If you have any questions about how this affects you, please don't hesitate to send me an email.

ADO.Net Entity Framework on MySQL

+0

-0

posted by Masood Mortazavi on Mon 10 Aug 2009 21:23 UTC
Tags:

(edit) mysql, Technology, software, Databases, Announcements, Web, microsoft, connectors, .NET

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL (http://mysql.com/news-and-events/web-seminars/display-397.html" target="_blank)", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

Develop your application against SQL Server and then switch it to MySQL with zero code changes
Optimize your database schema without requiring any code changes in your application
Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual

[Read more...]

ADO.Net Entity Framework on MySQL

+0

-0

posted by Masood Mortazavi on Mon 10 Aug 2009 14:23 UTC
Tags:

(edit) mysql, Technology, Windows, software, Databases, Announcements, Web, microsoft, Programming, connectors, .NET

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL (http://mysql.com/news-and-events/web-seminars/display-397.html" target="_blank)", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

Develop your application against SQL Server and then switch it to MySQL with zero code changes
Optimize your database schema without requiring any code changes in your application
Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual

[Read more...]

ADO.Net Entity Framework on MySQL

+0

-0

posted by Masood Mortazavi on Mon 10 Aug 2009 14:23 UTC
Tags:

(edit) mysql, Technology, Windows, software, Databases, Announcements, Web, microsoft, Programming, connectors, .NET

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL (http://mysql.com/news-and-events/web-seminars/display-397.html" target="_blank)", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

Develop your application against SQL Server and then switch it to MySQL with zero code changes
Optimize your database schema without requiring any code changes in your application
Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual

[Read more...]

I’m Offering Pro-Bono Consulting

+1

-0

posted by Brian K. Jones on Tue 21 Jul 2009 04:10 UTC
Tags:

(edit) Technology, Linux, web services, database, ruby, Python, Sysadmin, Scripting, Big Ideas, Freelancing

I started my company about a year ago, but I’ve been doing consulting for a long time. In fact, my first job in the IT industry was working for a consulting firm. Before that, starting as far back as grade school, I was involved in a lot of volunteer civic and community service activities. I admire companies who get involved in their communities, or even outside of their communities, wherever help is needed.

As part of my business plan, I’ve put in place a policy of accepting one pro-bono consulting project per year. So far, I haven’t gotten any requests for free consulting work, so here’s my public shout out to let you know what types of services are available:

1. Speaking or Training. My specialties are things like advanced Linux administration and SQL, but I’m perfectly capable of delivering

+0

-0

posted by Reggie Burnett on Tue 16 Jun 2009 22:10 UTC
Tags:

(edit) mysql, Technology, .NET

MySQL Connector/Net 6.0.4, a new version of the all-managed .NET driver
for MySQL has been released. This is the first post-GA release of the new
6.0 connector and includes several bug fixes from the initial GA release.

This release is approved for use in all scenarios and officially
supports MySQL servers 4.1 and higher. It is now available in source and binary form from
[http://dev.mysql.com/downloads/connector/net/6.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.)

IMPORTANT
We have had some reports of installer problems with this package. We are working hard to find the problem. For

[Read more...]

SQL code for SQL and Relational Theory

+1

-0

posted by Haidong Ji on Thu 04 Jun 2009 22:17 UTC
Tags:

(edit) mysql, Technology, Oracle, sqlserver, DatabaseInteroperability

I am reading SQL and Relational Theory by C. J. Date. Baron Schwartz wrote a nice review for it. I am reading the online version, about half way through, so am not sure if it has an accompanying CD with source code. In any case, if you want to play with some SQL code listed in the book, here is the script to generate the tables and rows (or should I say relations at a certain point in time with tuples?)

CREATE TABLE S
   ( SNO    VARCHAR(5)   NOT NULL ,
     SNAME  VARCHAR(25)  NOT NULL ,
     STATUS INTEGER      NOT NULL ,
     CITY   VARCHAR(20)  NOT NULL ,
     UNIQUE ( SNO ) ) ;

 CREATE TABLE P
   ( PNO    VARCHAR(6)   NOT NULL ,
     PNAME  VARCHAR(25)  NOT NULL ,
     COLOR  CHAR(10)     NOT NULL ,
     WEIGHT NUMERIC(5,1) NOT NULL ,
     CITY

+0

-0

posted by Haidong Ji on Wed 20 May 2009 04:07 UTC
Tags:

(edit) mysql, Technology

I’ve been to the Chicago MySQL meetups a few times at Uncommon Ground near Wriggly Field. Honestly I don’t think I gained much out of it. The few times I was there, the group was small, which is not necessarily bad. (In fact, a small group can even be a good thing.) But the thing got me was that there was too much talk, not enough action. I haven’t been to its meetings for a few years so I cannot comment on its state after I left.

When I think a user group, I think about fans getting together hacking stuff: demonstrating cool tips and techniques, dissecting a new technology such as MySQL proxy by a user who have done that and learned some hard lessons along the way with no marketing talk, discussing solutions to problems a user has, providing pointers and efficient scripts, etc. In such a setting, each member of the group takes turns

[Read more...]

Customizing db_STRESS

+0

-0

posted by Amir Javanshir on Thu 14 May 2009 14:28 UTC
Tags:

(edit) mysql, Technology, database, stress, test

One of our colleagues, Dimitri, at the Paris Sun solution center has developed a real neat and useful tool called dim_STAT. To make it short it's a tool for both high-level and detailed, monitoring and performance analysis of Solaris and Linux systems.

Data is collected and saved in a MySQL database, and it provides a very functional web base user interface. It allows real time or off line monitoring, multi-host etc.

Actually what is really interesting with dim_STAT is that, when I'm benchmarking or tryinng to find a performance bottleneck, I can collect all the data I need and come back later for analysis.

Recently, Dimitri has added a new tool db_STRESS, that allows us to put load on a database system and gives a high level metric (TPS: Transactions per seconds) and therefor allows us to compare how different systems

[Read more...]

Customizing db_STRESS

+0

-0

posted by Amir Javanshir on Thu 14 May 2009 14:28 UTC
Tags:

(edit) mysql, Technology, database, stress, test

One of our colleagues, Dimitri, at the Paris Sun solution center has developed a real neat and useful tool called dim_STAT. To make it short it's a tool for both high-level and detailed, monitoring and performance analysis of Solaris and Linux systems.

Data is collected and saved in a MySQL database, and it provides a very functional web base user interface. It allows real time or off line monitoring, multi-host etc.

Actually what is really interesting with dim_STAT is that, when I'm benchmarking or tryinng to find a performance bottleneck, I can collect all the data I need and come back later for analysis.

Recently, Dimitri has added a new tool db_STRESS, that allows us to put load on a database system and gives a high level metric (TPS: Transactions per seconds) and therefor allows us to compare how different systems

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

Oracle MySQL Blogs

MySQL Links

Other Links

Planetarium