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

      MongoDB Most Wanted Database by Developers

      Watching Ignoring Scheduled Pinned Locked Moved News databases nosql mongodb
      1
      2 Votes
      1 Posts
      663 Views
      No one has replied
    • mlnewsM

      MongoDB Drops ACID

      Watching Ignoring Scheduled Pinned Locked Moved News mongodb nosql databases mongodb 4.0 acid
      2
      1 Votes
      2 Posts
      712 Views
      scottalanmillerS

      Gotta love that MongoDB 🙂

    • OksanaO

      Comparing MS SQL Server Basic Availability Groups and Failover Cluster Instances features

      Watching Ignoring Scheduled Pinned Locked Moved 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
      1
      3 Votes
      1 Posts
      967 Views
      No one has replied
    • mlnewsM

      MS SQL Server 2017 on Linux Has Released

      Watching Ignoring Scheduled Pinned Locked Moved News databases linux ms sql server 2017 ms sql server rdbms microsoft ms sql server on linux ms sql server 2017 linux
      19
      3 Votes
      19 Posts
      3k Views
      Reid CooperR

      @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.

    • AdamFA

      MySQL configuration best practices

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion mysql best practices mariadb databases rdbms
      12
      3 Votes
      12 Posts
      2k Views
      Emad RE

      @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.

    • NetworkNerdN

      Using In-Memory Databases, Anyone?

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion databases apache geode in-memory databases performance database sql sql server
      18
      0 Votes
      18 Posts
      2k Views
      scottalanmillerS

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

    • mlnewsM

      MS SQL Server 2017 Candidate Has Arrived

      Watching Ignoring Scheduled Pinned Locked Moved News database databases database management system ms sql server ms sql server 2017 ms sql server on linux el reg linux relational database rdbms
      1
      2 Votes
      1 Posts
      998 Views
      No one has replied
    • scottalanmillerS

      Shared File Databases vs Database Servers SAMIT Video

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion rdbms databases database embedded database scott alan miller samit youtube
      6
      7 Votes
      6 Posts
      1k Views
      jmooreJ

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

    • scottalanmillerS

      Pronunciations of SQL Derived Database Names and Terms

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion sql sequel ms sql server postgresql mysql pronunciation database databases
      77
      3 Votes
      77 Posts
      12k Views
      scottalanmillerS

      @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.

    • scottalanmillerS

      Why Does Everyone Still Focus on Relational Databases?

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion rdbms nosql database databases
      51
      2 Votes
      51 Posts
      8k Views
      guyinpvG

      @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!

    • scottalanmillerS

      What is a Database Management System? (DBMS)

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion database databases dbms rdbms data it basics article
      4
      2 Votes
      4 Posts
      2k Views
      scottalanmillerS

      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

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion raid raid 5 ssd raid 10 databases storage
      4
      3 Votes
      4 Posts
      2k Views
      KOOLERK

      @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 🙂

    • mlnewsM

      Google Provides Table Level Encryption to MariaDB

      Watching Ignoring Scheduled Pinned Locked Moved News security encryption google databases mariadb inforworld
      3
      2 Votes
      3 Posts
      2k Views
      scottalanmillerS

      @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.

    • NetworkNerdN

      Third Party Backups of Databases and White Space

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion databases backups white space
      5
      0 Votes
      5 Posts
      2k Views
      StrongBadS

      Good read, thanks.

    • scottalanmillerS

      MongoDB vs. Redis

      Watching Ignoring Scheduled Pinned Locked Moved IT Discussion mongodb redis nosql database databases
      25
      1 Votes
      25 Posts
      3k Views
      scottalanmillerS

      @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.

    • 1 / 1