Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    15

    Thumbs up Unanswered: MySQL 5.0 for Enterprise Solutions

    Hi

    New options for Enterprise Applications.

    MySQL 5.0 adds support for stored procedures, which can facilitate the adoption of MySQL for existing legacy database applications. In addition to better accessibility, stored procedures can improve data integrity and developer productivity.

    MySQL 5.0 Alpha
    http://www.mysql.com/downloads/mysql-5.0.html

    I test MySQL 5.0 with MySQL Turbo Manager 2.5.
    http://www.mentattech.com

    Regards,

    Pete

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: MySQL 5.0 for Enterprise Solutions

    Originally posted by expert-database
    Hi

    New options for Enterprise Applications.

    MySQL 5.0 adds support for stored procedures, which can facilitate the adoption of MySQL for existing legacy database applications. In addition to better accessibility, stored procedures can improve data integrity and developer productivity.

    MySQL 5.0 Alpha
    http://www.mysql.com/downloads/mysql-5.0.html

    I test MySQL 5.0 with MySQL Turbo Manager 2.5.
    http://www.mentattech.com

    Regards,

    Pete
    MySQL is just an alpha release and not in stable or production state!

  3. #3
    Join Date
    Jan 2004
    Posts
    24
    Actually most of the MySQL 5.0 code is the same code as what's in 4.0 and 4.1. It just has some new features like procedures. Is it stable code? Depends on what you call stable. Do you need stored procedures? If you have to have them and you use MySQL I would consider it to be stable enough.

    Donny
    http://www.phpscripts.com/

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by donsimon
    Actually most of the MySQL 5.0 code is the same code as what's in 4.0 and 4.1. It just has some new features like procedures. Is it stable code? Depends on what you call stable. Do you need stored procedures? If you have to have them and you use MySQL I would consider it to be stable enough.

    Donny
    I am not talking about features but i am talking about stability which is needed for database in production state.

    Managers look:

    - is it stable version for production state? Answer NO.
    - is there support for this release? Answer NO.
    - is there some company which have this version in production state? Answer: MAYBE

    MySQL developers claims 5.0 only for testing and development purposes.

  5. #5
    Join Date
    Jan 2004
    Posts
    24
    Originally posted by ika
    I am not talking about features but i am talking about stability which is needed for database in production state.

    Managers look:

    - is it stable version for production state? Answer NO.
    - is there support for this release? Answer NO.
    - is there some company which have this version in production state? Answer: MAYBE

    MySQL developers claims 5.0 only for testing and development purposes.
    - is it stable version for production state? Actually it's as stable as MySQL 4.0 and MySQL 4.1.1. Since the source code is exactly the same, it just has some new features. So technically if there are any bugs in the code it would only be with brand new features. If there are bugs in anything else, the bugs would be in every release they have out today.

    - is there support for this release? Why would there not be support? I installed it had a question sent it to the mysql list and got a response about 5 minutes later.

    - is there some company which have this version in production state? I'm using it on 3 MySQL boxes right now. Do those boxes make me a few million a month? No. But do they make me a few hundred grand a year, sure. But I also have some boxes running 4.1.1 and even one running 4.1.2 which isn't even out yet. Because I want to know everything about every version and which is the best for me to run in the long run.

    So if you are already using 4.1.x would I install 5.0 on a backend server, personally I would. If I were using 4.0 or 3.23.x would I upgrade them to 5.0? No. Too many new changes. Do one version number at a time. Your life will be much easier.

    Donny
    http://www.phpscripts.com/

  6. #6
    Join Date
    Jan 2004
    Posts
    15

    Cool

    Hi

    We agree MySQL 5.0 totally is a not stable database , is only for evaluation but is a good approach of the future of
    this popular database.

    regards,

    Pete

  7. #7
    Join Date
    Jan 2004
    Location
    Prague, Czech Republic
    Posts
    1

    Re: MySQL 5.0 for Enterprise Solutions

    Okay, that sounds fine but...

    Connector/J doesn't seem to support stored procedures yet (I use the very late nightly build). I can't manage to retrieve a result from mysql sp to java ... I can't return neither ResultSet nor scalar data type. (But if i call the sp from command-line client it works OK.)

    Have you experienced this?? If anyone of you know how to fix the problem please let me know.

    Honza

    P.S. I use Win 2000 Proff. SP4, j2sdk1.4.2, Connector/J 2004-01-14 nightly.



    Originally posted by expert-database
    Hi

    New options for Enterprise Applications.

    MySQL 5.0 adds support for stored procedures, which can facilitate the adoption of MySQL for existing legacy database applications. In addition to better accessibility, stored procedures can improve data integrity and developer productivity.

    MySQL 5.0 Alpha
    http://www.mysql.com/downloads/mysql-5.0.html

    I test MySQL 5.0 with MySQL Turbo Manager 2.5.
    http://www.mentattech.com

    Regards,

    Pete

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •