Page 1 of 3 123 LastLast
Results 1 to 16 of 34

Thread: What is MY SQL?

  1. #1
    HEXUS.timelord. Zak33's Avatar
    Join Date
    Jul 2003
    Location
    I'm a Jessie
    Posts
    35,157
    Thanks
    3,105
    Thanked
    3,138 times in 1,916 posts
    • Zak33's system
      • Storage:
      • Kingston HyperX SSD, Hitachi 1Tb
      • Graphics card(s):
      • Nvidia 1050
      • PSU:
      • Coolermaster 800w
      • Case:
      • Silverstone Fortress FT01
      • Operating System:
      • Win10
      • Internet:
      • Zen FTC uber speedy

    What is MY SQL?

    What is MY SQL in laymans terms?
    And what PC would be required to run it, to supply 6 users in the same office?

    Reason? A close friend with an estate agency, is being offered a software solution requiring this.

    Now trust me I'm not trying to get involved...but to be able to explain it to someone who is totally PC illeterate in layman's terms would be cool

    And knowing what hardware is needed will help: ie a £400 dell box?

    Quote Originally Posted by Advice Trinity by Knoxville
    "The second you aren't paying attention to the tool you're using, it will take your fingers from you. It does not know sympathy." |
    "If you don't gaffer it, it will gaffer you" | "Belt and braces"

  2. #2
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts
    MySQL is an Open Source Database Server - like Microsofts SQL Server , but free

    A 6 Man office isn't going to be pushing a huge ammount of transactions through a database - it depends on the type of application its running.

    3 Very important things though.

    Backups , Backups and errr. Backups

    have them or go bankrupt.
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  3. #3
    HEXUS webmaster Steve's Avatar
    Join Date
    Nov 2003
    Posts
    14,276
    Thanks
    292
    Thanked
    837 times in 473 posts
    MySQL is database application.

    There are free versions of it. It'll run on more or less anything - it depends on the database as to whether the hardware's up to it.

    For six people, any PC can probably deal with it.
    PHP Code:
    $s = new signature();
    $s->sarcasm()->intellect()->font('Courier New')->display(); 

  4. #4
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS
    MySQL is a database server. It's for databases - think Access, but allowing read and write access to multiple users at the same time reasonably well

    It'll run on most any system capable of running an OS. Main supported OS is Linux, but it runs on things like Windows or Solaris too.

  5. #5
    Registered+
    Join Date
    Oct 2006
    Posts
    54
    Thanks
    0
    Thanked
    0 times in 0 posts
    Taken from the MySQL website

    The MySQL® database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use. It's used in more than 11 million installations ranging from large corporations to specialized embedded applications on every continent in the world. (Yes, even Antarctica!)

    Not only is MySQL the world's most popular open source database, it's also become the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.) MySQL runs on more than 20 platforms including Linux, Windows, OS/X, HP-UX, AIX, Netware, giving you the kind of flexibility that puts you in control.

    Whether you're new to database technology or an experienced developer or DBA, MySQL offers a comprehensive range of certified software, support, training and consulting to make you successful.
    www.mysql.com

    In simple terms it is a relational database that is cross platform. As to the requirements, all depends on what is is you are running and how many records / databases / users it will have. But if it is just for 6 users a £400 Dell machine should do the job I recon (for the time being anyway)

  6. #6
    HEXUS.timelord. Zak33's Avatar
    Join Date
    Jul 2003
    Location
    I'm a Jessie
    Posts
    35,157
    Thanks
    3,105
    Thanked
    3,138 times in 1,916 posts
    • Zak33's system
      • Storage:
      • Kingston HyperX SSD, Hitachi 1Tb
      • Graphics card(s):
      • Nvidia 1050
      • PSU:
      • Coolermaster 800w
      • Case:
      • Silverstone Fortress FT01
      • Operating System:
      • Win10
      • Internet:
      • Zen FTC uber speedy
    ok dudes, thanks....just waiting for TiG....who normally abuses me until I see the truth

    Quote Originally Posted by Advice Trinity by Knoxville
    "The second you aren't paying attention to the tool you're using, it will take your fingers from you. It does not know sympathy." |
    "If you don't gaffer it, it will gaffer you" | "Belt and braces"

  7. #7
    TiG
    TiG is offline
    Walk a mile in other peoples shoes...
    Join Date
    Jul 2003
    Location
    Questioning it all
    Posts
    6,213
    Thanks
    45
    Thanked
    48 times in 43 posts
    Quote Originally Posted by Moby-Dick View Post
    MySQL is an Open Source Database Server - like Microsofts SQL Server , but free

    A 6 Man office isn't going to be pushing a huge ammount of transactions through a database - it depends on the type of application its running.

    3 Very important things though.

    Backups , Backups and errr. Backups

    have them or go bankrupt.
    Yep Moby's completely right here, getting MYSQL up and running isn't going to be the problem, is going to be ongoing maintenance and its one of my little gripes about MYSQL, sure backups and everything with mysql is getting better and better over time, and while it is free, products that rely on this for a work place environment are dubious in my opinion. It means they don't want to have the cost of a proper product.

    If its anything really important or critical for the business, best to know exactly what you are letting your mate in for.

    TiG
    -- Hexus Meets Rock! --

  8. #8
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts
    especially as you can run something like SQL2005 Express for a system like this without any problems at all.
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  9. #9
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,048
    Thanks
    1,016
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable
    ongoing maintenance? I have a cron script running to back it up, beyond that I don't need to touch it save for adding/removing privilages (which is easy to do with phpmyadmin or MySQL Admin tool).

    MySQL is a database backend *only* though, it doesn't have a fancy frontend or VBA scripting, it's a real SQL server.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  10. #10
    HEXUS.timelord. Zak33's Avatar
    Join Date
    Jul 2003
    Location
    I'm a Jessie
    Posts
    35,157
    Thanks
    3,105
    Thanked
    3,138 times in 1,916 posts
    • Zak33's system
      • Storage:
      • Kingston HyperX SSD, Hitachi 1Tb
      • Graphics card(s):
      • Nvidia 1050
      • PSU:
      • Coolermaster 800w
      • Case:
      • Silverstone Fortress FT01
      • Operating System:
      • Win10
      • Internet:
      • Zen FTC uber speedy
    OK....
    I'm getting the vibe here.

    Can I ask.... is MY SQL renowned for being less than stable? And I guess the Microsoft version is serious money but uber stable?

    Quote Originally Posted by Advice Trinity by Knoxville
    "The second you aren't paying attention to the tool you're using, it will take your fingers from you. It does not know sympathy." |
    "If you don't gaffer it, it will gaffer you" | "Belt and braces"

  11. #11
    Gentoo Ricer
    Join Date
    Jan 2005
    Location
    Galway
    Posts
    11,048
    Thanks
    1,016
    Thanked
    944 times in 704 posts
    • aidanjt's system
      • Motherboard:
      • Asus Strix Z370-G
      • CPU:
      • Intel i7-8700K
      • Memory:
      • 2x8GB Corsiar LPX 3000C15
      • Storage:
      • 500GB Samsung 960 EVO
      • Graphics card(s):
      • EVGA GTX 970 SC ACX 2.0
      • PSU:
      • EVGA G3 750W
      • Case:
      • Fractal Design Define C Mini
      • Operating System:
      • Windows 10 Pro
      • Monitor(s):
      • Asus MG279Q
      • Internet:
      • 240mbps Virgin Cable
    Quote Originally Posted by Zak33 View Post
    OK....
    I'm getting the vibe here.

    Can I ask.... is MY SQL renowned for being less than stable? And I guess the Microsoft version is serious money but uber stable?
    No, MySQL runs on countless websites with silly high uptimes and even more ridiculous performance, I've never once had the daemon die on me.
    Quote Originally Posted by Agent View Post
    ...every time Creative bring out a new card range their advertising makes it sound like they have discovered a way to insert a thousand Chuck Norris super dwarfs in your ears...

  12. #12
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,027 times in 678 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS
    mysql has a reputation for being "good enough" for most tasks

    want commercial support (businesses like commercial support)? you can buy it

    want it free? you can download it

    want source? you can download it

    want functionality? most of what people use is there

    want speed? it's okay - nothing stellar, nothing dreadful

    when selecting a database server, there are an enormous number of factors to consider. mysql's the database of choice for most of the net mainly because it doesn't do anything badly - it's a jack of all trades

  13. #13
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts
    I doubt your mates requirements would require any of the more expensive MSSQL Solutions - Newer versions of MySQL are getting better ( the inclusion of stored procedures was quite a critical upgrade )

    MySQL does have an Enterprise Edition , which is not free , but has plenty of product support , which would probably make it more usefull for large scale applications than the 'free' version.

    Microsoft produced SQL2005 Express to compete with MySQL in the small scale RDBMS market.

    If you've got any more details on the software I'll cast my professional eye over it ( given that I used to run this kind of system for the 2nd largest estate agents in the UK )
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  14. #14
    HEXUS.timelord. Zak33's Avatar
    Join Date
    Jul 2003
    Location
    I'm a Jessie
    Posts
    35,157
    Thanks
    3,105
    Thanked
    3,138 times in 1,916 posts
    • Zak33's system
      • Storage:
      • Kingston HyperX SSD, Hitachi 1Tb
      • Graphics card(s):
      • Nvidia 1050
      • PSU:
      • Coolermaster 800w
      • Case:
      • Silverstone Fortress FT01
      • Operating System:
      • Win10
      • Internet:
      • Zen FTC uber speedy
    Quote Originally Posted by Moby-Dick View Post
    If you've got any more details on the software I'll cast my professional eye over it ( given that I used to run this kind of system for the 2nd largest estate agents in the UK )
    thought that....then thought I'd start at the start and not jump in to asking for your pro help yet...might be Pie in the old Sky, you know?

    Quote Originally Posted by Advice Trinity by Knoxville
    "The second you aren't paying attention to the tool you're using, it will take your fingers from you. It does not know sympathy." |
    "If you don't gaffer it, it will gaffer you" | "Belt and braces"

  15. #15
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,665
    Thanks
    53
    Thanked
    385 times in 314 posts
    no problem - I wonder if its the sort of solution that goes hand in hand with a website to automatically update the companies website with available stock.

    If the front end website is written with PHP/MySQL , it would make sence to have the back end application based around MySQL.
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  16. #16
    TiG
    TiG is offline
    Walk a mile in other peoples shoes...
    Join Date
    Jul 2003
    Location
    Questioning it all
    Posts
    6,213
    Thanks
    45
    Thanked
    48 times in 43 posts
    Quote Originally Posted by aidanjt View Post
    ongoing maintenance? I have a cron script running to back it up, beyond that I don't need to touch it save for adding/removing privilages (which is easy to do with phpmyadmin or MySQL Admin tool).

    MySQL is a database backend *only* though, it doesn't have a fancy frontend or VBA scripting, it's a real SQL server.
    Thats precisely my point. Say Cron job script to a standard non techy monkey and you've lost them for the next 20 minutes. Glazed eyes and game over.

    TiG
    -- Hexus Meets Rock! --

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 17
    Last Post: 15-07-2007, 03:59 PM
  2. SQL Process Manager
    By madman045 in forum Software
    Replies: 7
    Last Post: 14-09-2006, 10:28 AM
  3. Member Database SQL / PHP
    By realm in forum Software
    Replies: 4
    Last Post: 03-01-2006, 06:48 PM
  4. SQL Server 2000
    By Fatboy in forum Software
    Replies: 37
    Last Post: 17-08-2005, 07:05 PM
  5. SQL Server Connection string?
    By Stoo in forum Software
    Replies: 7
    Last Post: 04-05-2005, 05:48 PM

Posting Permissions

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