Navigation

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

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

      1
      2
      Votes
      1
      Posts
      348
      Views

      No one has replied

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

      2
      1
      Votes
      2
      Posts
      308
      Views

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

      1
      3
      Votes
      1
      Posts
      622
      Views

      No one has replied

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

      19
      3
      Votes
      19
      Posts
      1425
      Views

      @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.
    • MySQL configuration best practices
      IT Discussion • best practices mysql mariadb rdbms databases • • AdamF  

      12
      3
      Votes
      12
      Posts
      1485
      Views

      @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.
    • Using In-Memory Databases, Anyone?
      IT Discussion • database sql server sql performance databases apache geode in-memory databases • • NetworkNerd  

      18
      0
      Votes
      18
      Posts
      1641
      Views

      We have plans to add an in memory database to ML in the future when more performance is needed, as well.
    • MS SQL Server 2017 Candidate Has Arrived
      News • linux database el reg rdbms databases ms sql server relational database ms sql server 2017 ms sql server on linux database management system • • mlnews  

      1
      2
      Votes
      1
      Posts
      604
      Views

      No one has replied

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

      6
      7
      Votes
      6
      Posts
      999
      Views

      Oh that's funny and interesting! Might I ask what sort of work so I can see a little bit about what is done?
    • Pronunciations of SQL Derived Database Names and Terms
      IT Discussion • database mysql sql postgresql databases ms sql server sequel pronunciation • • scottalanmiller  

      77
      3
      Votes
      77
      Posts
      4995
      Views

      @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.
    • Why Does Everyone Still Focus on Relational Databases?
      IT Discussion • database rdbms nosql databases • • scottalanmiller  

      51
      2
      Votes
      51
      Posts
      5292
      Views

      @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!
    • What is a Database Management System? (DBMS)
      IT Discussion • database article rdbms databases data it basics dbms • • scottalanmiller  

      4
      2
      Votes
      4
      Posts
      1296
      Views

      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 • storage raid ssd raid 10 databases raid 5 • • alvama  

      4
      3
      Votes
      4
      Posts
      1398
      Views

      @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
    • Google Provides Table Level Encryption to MariaDB
      News • security google encryption mariadb databases inforworld • • mlnews  

      3
      2
      Votes
      3
      Posts
      1238
      Views

      @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.
    • Third Party Backups of Databases and White Space
      IT Discussion • backups databases white space • • NetworkNerd  

      5
      0
      Votes
      5
      Posts
      1510
      Views

      Good read, thanks.
    • MongoDB vs. Redis
      IT Discussion • database mongodb nosql databases redis • • scottalanmiller  

      25
      1
      Votes
      25
      Posts
      1808
      Views

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