ML
    • Register
    • Login
    • Search
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. Tags
    3. databases
    Log in to post
    • All categories
    • mlnews

      MongoDB Most Wanted Database by Developers
      News • databases nosql mongodb • • mlnews

      1
      2
      Votes
      1
      Posts
      409
      Views

      No one has replied

    • mlnews

      MongoDB Drops ACID
      News • mongodb nosql databases mongodb 4.0 acid • • mlnews

      2
      1
      Votes
      2
      Posts
      370
      Views

      scottalanmiller

      Gotta love that MongoDB 🙂

    • Oksana

      Comparing MS SQL Server Basic Availability Groups and Failover Cluster Instances features
      Starwind • sql server 2016 disaster recovery failover cluster instances fci bags basic availability groups databases mission-critical database software-defined storage high availability starwind blog • • Oksana

      1
      3
      Votes
      1
      Posts
      662
      Views

      No one has replied

    • mlnews

      MS SQL Server 2017 on Linux Has Released
      News • databases linux ms sql server 2017 ms sql server rdbms microsoft ms sql server on linux ms sql server 2017 linux • • mlnews

      19
      3
      Votes
      19
      Posts
      1557
      Views

      Reid Cooper

      @tonyshowoff said in MS SQL Server 2017 on Linux Has Released:

      Does it allow odd number processors yet or do I still have to disable one if I don't have an even number?

      Even only for licensing, I believe. No change there.

    • AdamF

      MySQL configuration best practices
      IT Discussion • mysql best practices mariadb databases rdbms • • AdamF

      12
      3
      Votes
      12
      Posts
      1683
      Views

      Emad R

      @fuznutz04 said in MySQL configuration best practices:

      @emad-r

      What is your practice for log rotation? For example, the error log. If that grows (obviously indicating other issues) , and needs to be rotated, what procedure do you use to rotate logs?

      Currently the third party vendor uses this:

      expire_logs_days = 10
      max_binlog_size = 100M

      In our MySQL instance.

    • NetworkNerd

      Using In-Memory Databases, Anyone?
      IT Discussion • databases apache geode in-memory databases performance database sql sql server • • NetworkNerd

      18
      0
      Votes
      18
      Posts
      1696
      Views

      scottalanmiller

      We have plans to add an in memory database to ML in the future when more performance is needed, as well.

    • mlnews

      MS SQL Server 2017 Candidate Has Arrived
      News • database databases database management system ms sql server ms sql server 2017 ms sql server on linux el reg linux relational database rdbms • • mlnews

      1
      2
      Votes
      1
      Posts
      656
      Views

      No one has replied

    • scottalanmiller

      Shared File Databases vs Database Servers SAMIT Video
      IT Discussion • rdbms databases database embedded database scott alan miller samit youtube • • scottalanmiller

      6
      7
      Votes
      6
      Posts
      1032
      Views

      jmoore

      Oh that's funny and interesting! Might I ask what sort of work so I can see a little bit about what is done?

    • scottalanmiller

      Pronunciations of SQL Derived Database Names and Terms
      IT Discussion • sql sequel ms sql server postgresql mysql pronunciation database databases • • scottalanmiller

      77
      3
      Votes
      77
      Posts
      5061
      Views

      scottalanmiller

      @matteo-nunziati said in Pronunciations of SQL Derived Database Names and Terms:

      we have a company in my town: second quadrant. the provide professional postgresql support worldwide and they pronunce it "postgres". omitting the final "ql"

      That's the official pronunciation and it was originally spelled that way. The PostgreSQL spelling was added when it went open source.

    • scottalanmiller

      Why Does Everyone Still Focus on Relational Databases?
      IT Discussion • rdbms nosql database databases • • scottalanmiller

      51
      2
      Votes
      51
      Posts
      5402
      Views

      guyinpv

      @scottalanmiller said in Why Does Everyone Still Focus on Relational Databases?:

      I just built out a NoSQL ElasticSearch three node cluster in the lab. Whoo!

      The perfect DB setup for storing a hit counter for the number of times I've watched Tombstone!

    • scottalanmiller

      What is a Database Management System? (DBMS)
      IT Discussion • database databases dbms rdbms data it basics article • • scottalanmiller

      4
      2
      Votes
      4
      Posts
      1338
      Views

      scottalanmiller

      They work very differently too. MySQL's features vary significantly based on which engine is in use. They perform differently, have different relational abilities, store differently on disk (MyISAM is one file per table, InnoDB is one file for everything) and use different tools.

    • A

      RAID Stripe Size and Total Blocks Written for Databases
      IT Discussion • raid raid 5 ssd raid 10 databases storage • • alvama

      4
      3
      Votes
      4
      Posts
      1531
      Views

      KOOLER

      @alvama said:

      Scott, thank you for your topic. I am planning new installation and comparing between RAID 10 and RAID 5 on ssd drives. What do you think about stripe size and TBW for two types of raid? Do you know what size of blocks will be written on disks if service (sql for example) writes 8Kb on volume. For raid10 I think it will be two 8K blocks on mirror disks. But for RAID 5 it will be two blocks with size=stripe size and may be 32 or 64K. And in raid5 configuration TBW limit will be reached faster.

      I'm not Scott but in your context RAID5 seems to be preferred. Because 1) Flash and not spinning disk used so typical parity RAID issues associated with high-capacity spinners are gone (see URL below) 2) Database logs are sequential writes of a big sizes so should "touch" maximum amount of spinners possible and because of sequential nature read-modify-write is not going to happen and 3) RAID5 gives you write performance of (N-1) and RAID10 does (N/2) (where N = amount of spinners).

      https://slog.starwindsoftware.com/raid-5-was-great-until-high-capacity-hdds-came-into-play-but-ssds-restored-its-former-glory/

      Good luck 🙂

    • mlnews

      Google Provides Table Level Encryption to MariaDB
      News • security encryption google databases mariadb inforworld • • mlnews

      3
      2
      Votes
      3
      Posts
      1259
      Views

      scottalanmiller

      @JaredBusch said:

      What the hell is up with the author of that article basically down playing the entire thing because it does not prevent SQL injection?
      Seriously WTF?

      I agree, that is a bunch of BS. This is about on-disk data at rest security and is a decently big deal.

    • NetworkNerd

      Third Party Backups of Databases and White Space
      IT Discussion • databases backups white space • • NetworkNerd

      5
      0
      Votes
      5
      Posts
      1532
      Views

      StrongBad

      Good read, thanks.

    • scottalanmiller

      MongoDB vs. Redis
      IT Discussion • mongodb redis nosql database databases • • scottalanmiller

      25
      1
      Votes
      25
      Posts
      1828
      Views

      scottalanmiller

      @dyasny said in MongoDB vs. Redis:

      @jmoore said in MongoDB vs. Redis:

      ... I don't see how just using some flashy marketing terms would actually get good talent.

      my point exactly! 🙂

      Not really what companies using recruiters like that want. It's mostly a myth that people want to hire great talent. Most places want to hire cool sounding, middling talent.