Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Apache, MySQL, and .Net - The Adventure Continues

Apache, MySQL, and .Net - The Adventure Continues

Scheduled Pinned Locked Moved The Lounge
csharpasp-netapachemysqlsysadmin
33 Posts 14 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N Nemanja Trifunovic

    John Simmons / outlaw programmer wrote:

    The benefit of running Apache instead of IIS is that when I do move back to an earlier (non-server) version of Windows, I don't have to start from scratch with an older version of IIS and worry about having to do stuff different ways.

    OK, that makes sense.

    John Simmons / outlaw programmer wrote:

    Actually, MySQl is equally as viable as SQL Server. Besides, now I can use either one, where you're stuck with just SQL Server.

    At my previous job (until a couple of weeks ago) I was using MySQL from C++ on Linux. It is OK for light loads and small databases, but when things grow a little bit, better stay away from MySQL.

    Programming Blog utf8-cpp

    P Offline
    P Offline
    Paul Watson
    wrote on last edited by
    #24

    Nemanja Trifunovic wrote:

    It is OK for light loads and small databases

    AFAIK you are right that in a one to one comparison SQL Server will beat MySQL. SQL Server will ultimately hold more data and respond better. As a monolithic RDBMS interface SQL Server > MySQL. But as soon as you compare a real world situation with multiple servers, application layers, caching systems, sharding etc. then I think MySQL has been proven to work very well and at lesser cost (not free) than SQL Server. The platform support is also better. Google is also having good success with the open nature of MySQL and being able to patch problems they come across. If they find a problem they don't have to seek permission, engage with Microsoft engineers, check their license or wait for updates, they just fix the problem.

    regards, Paul Watson Ireland & South Africa

    Fernando A. Gomez F. wrote:

    At least he achieved immortality for a few years.

    1 Reply Last reply
    0
    • N Nemanja Trifunovic

      John Simmons / outlaw programmer wrote:

      The benefit of running Apache instead of IIS is that when I do move back to an earlier (non-server) version of Windows, I don't have to start from scratch with an older version of IIS and worry about having to do stuff different ways.

      OK, that makes sense.

      John Simmons / outlaw programmer wrote:

      Actually, MySQl is equally as viable as SQL Server. Besides, now I can use either one, where you're stuck with just SQL Server.

      At my previous job (until a couple of weeks ago) I was using MySQL from C++ on Linux. It is OK for light loads and small databases, but when things grow a little bit, better stay away from MySQL.

      Programming Blog utf8-cpp

      S Offline
      S Offline
      si618
      wrote on last edited by
      #25

      Nemanja Trifunovic wrote:

      At my previous job (until a couple of weeks ago) I was using MySQL from C++ on Linux. It is OK for light loads and small databases, but when things grow a little bit, better stay away from MySQL.

      You are joking right? I must have missed the smiley. MySQL excels at read often, write seldom databases. There are many large databases with huge loads running MySQL. I guess that's why Sun bought them.

      1 Reply Last reply
      0
      • J Johan Pretorius

        Nemanja Trifunovic wrote:

        It is OK for light loads and small databases, but when things grow a little bit, better stay away from MySQL.

        Companies using MySql : Wikipidia Nokia Youtube NetQos flicker its is said that google also runs MySql (unconfirmed)


        Artificial Intelligence is no match for Natural Stupidity
        No one can understand the truth until he drinks of coffee's frothy goodness. ~Sheik Abd-al-Kadir
        I can't always be wrong ... or can I?

        S Offline
        S Offline
        si618
        wrote on last edited by
        #26

        C aveFox wrote:

        its is said that google also runs MySql (unconfirmed)

        Confirmed.[^]

        1 Reply Last reply
        0
        • N Nemanja Trifunovic

          Shog9 wrote:

          If your web host allows you to install them, or you self-host.

          It was my impression that John was self-hosting? :~

          Programming Blog utf8-cpp

          R Offline
          R Offline
          realJSOP
          wrote on last edited by
          #27

          I am.

          "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
          -----
          "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

          1 Reply Last reply
          0
          • J Jim Crafton

            For 1, I would say bad experiences with IIS (at least prior to the newer versions). For 2, I have no idea, other than cost :)

            ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! VCF Blog

            T Offline
            T Offline
            Tomz_KV
            wrote on last edited by
            #28

            Although I like IIS but I have not seen it working for 3 months continously without a "iisreset". Is this just my experience?

            TOMZ_KV

            1 Reply Last reply
            0
            • N Nemanja Trifunovic

              John Simmons / outlaw programmer wrote:

              The benefit of running Apache instead of IIS is that when I do move back to an earlier (non-server) version of Windows, I don't have to start from scratch with an older version of IIS and worry about having to do stuff different ways.

              OK, that makes sense.

              John Simmons / outlaw programmer wrote:

              Actually, MySQl is equally as viable as SQL Server. Besides, now I can use either one, where you're stuck with just SQL Server.

              At my previous job (until a couple of weeks ago) I was using MySQL from C++ on Linux. It is OK for light loads and small databases, but when things grow a little bit, better stay away from MySQL.

              Programming Blog utf8-cpp

              M Offline
              M Offline
              MajorTom123
              wrote on last edited by
              #29

              http://www.mysql.com/why-mysql/case-studies/[^] If you look down the page of case studies you'll see: "Utel handles 10,000 Requests per Second Using a Scale out Deployment of MySQL Network" Not a bad scale out in my opinion. Are you sure you researched this topic enough to flame the product? Maybe you didn't optimize your db or something.

              1 Reply Last reply
              0
              • A Al Ortega

                Apache running .Net - is that via Mono?

                -Al

                M Offline
                M Offline
                MajorTom123
                wrote on last edited by
                #30

                i thought mono was only for Linux installations. John's running Windows.

                D 1 Reply Last reply
                0
                • M MajorTom123

                  i thought mono was only for Linux installations. John's running Windows.

                  D Offline
                  D Offline
                  Dan Neely
                  wrote on last edited by
                  #31

                  It's OSS, you can probably find a distro that'll run on your digital watch. :rolleyes:

                  Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop. -- Matthew Faithfull

                  M 1 Reply Last reply
                  0
                  • D Dan Neely

                    It's OSS, you can probably find a distro that'll run on your digital watch. :rolleyes:

                    Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop. -- Matthew Faithfull

                    M Offline
                    M Offline
                    MajorTom123
                    wrote on last edited by
                    #32

                    Yeah I just looked on the mono-project.com site and there is a windows install of it. If you want cross compatibility you program for Mono and it "should" run on both platforms. It will be interesting if commercial packages convert their code to support Mono or not.

                    1 Reply Last reply
                    0
                    • R realJSOP

                      Well, after a couple of weeks (four full days and only an hour a night on week days) of developing a website, integrating a MySQL membership/role/profile provider, and implementing Forms Authentication, I copied the whole shebang to the (windows 2003) server running Apache 2.0.55, and waddayaknow - it bloody well worked! I think this whole experiment can be marked down as a resounding success, so if you've been holding back on running Asp.Net 2.0 under Apache, or using MySQL with .Net, there's no real reason you shouldn't be able to proceed.

                      "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
                      -----
                      "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

                      N Offline
                      N Offline
                      nilotic
                      wrote on last edited by
                      #33

                      Nice to about unexpected success. Caused an interesting thread, too. Most of the time I hear about unexpected failures (bugs). This is like a juicy raisin in the muesli - a surprisingly rare sweet moment of positivity that doesn't turn out to be artificial on closer inspection. I once built a simple website using VS2005 and was pleasantly surprised at how well it worked with the major browsers on my friends' PC's. In fact I could hardly believe it. I cling to stuff like that at times of deep MSdespair.

                      I'm peculiar to myself, therefore I am.

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups