Upgrading MySQL 5.5 to MySQL 8: A Step by Step Guide
#mysql #mysqlserver #optimization #upgradation #database #databaseadministration #databasemanagement #mysql8 #webmonetization
https://hackernoon.com/upgrading-mysql-55-to-mysql-8-a-step-by-step-guide-ltal35h3
#mysql #mysqlserver #optimization #upgradation #database #databaseadministration #databasemanagement #mysql8 #webmonetization
https://hackernoon.com/upgrading-mysql-55-to-mysql-8-a-step-by-step-guide-ltal35h3
Hackernoon
Upgrading MySQL 5.5 to MySQL 8: A Step by Step Guide | Hacker Noon
It is one of the dogmas that upgrading freeware libraries is a drag - but not anymore especially for MySQL. Check out this article for more information.
Log Slow Postgres Query Plans Automatically: An Introduction to auto-explain
#databaseadministration #postgresql #query #postgres #developer #databaseoptimization #auto_explain #goodcompany
https://hackernoon.com/log-slow-postgres-query-plans-automatically-an-introduction-to-auto-explain
#databaseadministration #postgresql #query #postgres #developer #databaseoptimization #auto_explain #goodcompany
https://hackernoon.com/log-slow-postgres-query-plans-automatically-an-introduction-to-auto-explain
Hackernoon
Log Slow Postgres Query Plans Automatically: An Introduction to auto-explain | HackerNoon
Automatically log slow query plans with auto_explain and learn how to fix the problematic PostgreSQL queries that are slowing you down.
Setting Up a Dedicated Database Server on Raspberry Pi
#programming #raspberrypi #server #database #databaseadministration #tutorial #beginners #hardware
https://hackernoon.com/setting-up-a-dedicated-database-server-on-raspberry-pi
#programming #raspberrypi #server #database #databaseadministration #tutorial #beginners #hardware
https://hackernoon.com/setting-up-a-dedicated-database-server-on-raspberry-pi
Hackernoon
Setting Up a Dedicated Database Server on Raspberry Pi
Learn how to set up a MariaDB database server on a Raspberry Pi 4 Model B with 8 GB of RAM that you can connect to your local network through WiFi or Ethernet
How to Manage Databases with CI/CD
#databases #database #databaseadministration #cicd #continuousintegration #continuousdeployment #databasemanagement #databasecicd
https://hackernoon.com/how-to-manage-databases-with-cicd
#databases #database #databaseadministration #cicd #continuousintegration #continuousdeployment #databasemanagement #databasecicd
https://hackernoon.com/how-to-manage-databases-with-cicd
Hackernoon
How to Manage Databases with CI/CD
If you’re still doing manual migrations on the database you’re doing it wrong. Databases are as much part of the application as the code.
The Hyper-V Admins' Guide to VMware Backup
#databases #data #databaseadministration #datascience #vmware #hyperv #virtualmachine #businessstrategy
https://hackernoon.com/the-hyper-v-admins-guide-to-vmware-backup
#databases #data #databaseadministration #datascience #vmware #hyperv #virtualmachine #businessstrategy
https://hackernoon.com/the-hyper-v-admins-guide-to-vmware-backup
Hackernoon
The Hyper-V Admins' Guide to VMware Backup | HackerNoon
The Hyper-V and VMware virtual environments may seem similar, but upon closer inspection, a number of important differences between these two platforms.
Why Normalizing Your Database Is Just Like Organizing Your Closet
#datanormalization #database #databaseadministration #normalizaion #databasemanagement #datamodeling #data #datasciencetopstory
https://hackernoon.com/why-normalizing-your-database-is-just-like-organizing-your-closet
#datanormalization #database #databaseadministration #normalizaion #databasemanagement #datamodeling #data #datasciencetopstory
https://hackernoon.com/why-normalizing-your-database-is-just-like-organizing-your-closet
Hackernoon
Why Normalizing Your Database Is Just Like Organizing Your Closet | HackerNoon
Explore database normalization in an easy-to-understand way using pet store examples. Discover the different levels from 1NF to 3NF and the importance of data
Decoding MySQL EXPLAIN Query Results for Better Performance
#sql #mysql #database #sqldatabase #data #datascience #databaseadministration #dataanalysis
https://hackernoon.com/decoding-mysql-explain-query-results-for-better-performance
#sql #mysql #database #sqldatabase #data #datascience #databaseadministration #dataanalysis
https://hackernoon.com/decoding-mysql-explain-query-results-for-better-performance
Hackernoon
Decoding MySQL EXPLAIN Query Results for Better Performance | HackerNoon
Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query.
Unveiling a MySQL Bug: Inconsistent Foreign Key Constraints
#sql #mysql #bug #programming #coding #bugs #database #databaseadministration
https://hackernoon.com/unveiling-a-mysql-bug-inconsistent-foreign-key-constraints
#sql #mysql #bug #programming #coding #bugs #database #databaseadministration
https://hackernoon.com/unveiling-a-mysql-bug-inconsistent-foreign-key-constraints
Hackernoon
Unveiling a MySQL Bug: Inconsistent Foreign Key Constraints | HackerNoon
In this article, I want to share an interesting bug that I stumbled upon in MySQL.
Optimize Data Migration in MongoDB: Resharding Techniques for Speed and Scalability
#mongodb #sharding #horizontalscaling #data #databaseoptimization #databaseadministration #documentdatabase #hackernoontopstory #hackernoones #hackernoonhi #hackernoonzh #hackernoonvi #hackernoonfr #hackernoonpt #hackernoonja
https://hackernoon.com/optimize-data-migration-in-mongodb-resharding-techniques-for-speed-and-scalability
#mongodb #sharding #horizontalscaling #data #databaseoptimization #databaseadministration #documentdatabase #hackernoontopstory #hackernoones #hackernoonhi #hackernoonzh #hackernoonvi #hackernoonfr #hackernoonpt #hackernoonja
https://hackernoon.com/optimize-data-migration-in-mongodb-resharding-techniques-for-speed-and-scalability
Hackernoon
Optimize Data Migration in MongoDB: Resharding Techniques for Speed and Scalability
Distribute a MongoDB collection fast, "reshard-to-shard" distributes data quicker than others methods, spreading your workload across multiple shards in hours.
Getting Started with Kvrocks and Go-redis
#redis #apachekvrocks #programming #opentelemetry #redisdatabase #database #databaseadministration #programmingtips
https://hackernoon.com/getting-started-with-kvrocks-and-go-redis
#redis #apachekvrocks #programming #opentelemetry #redisdatabase #database #databaseadministration #programmingtips
https://hackernoon.com/getting-started-with-kvrocks-and-go-redis
Hackernoon
Getting Started with Kvrocks and Go-redis | HackerNoon
Learn how to use the go-redis client to get started with Apache Kvrocks, a distributed key-value NoSQL database.
A Comprehensive Guide for Using DuckDB With Go
#go #duckdb #sql #dataanalysis #database #databaseadministration #goprogramminglanguage #sqldatabase
https://hackernoon.com/a-comprehensive-guide-for-using-duckdb-with-go
#go #duckdb #sql #dataanalysis #database #databaseadministration #goprogramminglanguage #sqldatabase
https://hackernoon.com/a-comprehensive-guide-for-using-duckdb-with-go
Hackernoon
A Comprehensive Guide for Using DuckDB With Go | HackerNoon
A comprehensive guide how to use popular embedded OLAP database DuckDB with Go.
Efficient Dockerized Database Monitoring with Dockerized PMM
#database #docker #containerization #databaseadministration #data #containers #datascience #mysql
https://hackernoon.com/efficient-dockerized-database-monitoring-with-dockerized-pmm
#database #docker #containerization #databaseadministration #data #containers #datascience #mysql
https://hackernoon.com/efficient-dockerized-database-monitoring-with-dockerized-pmm
Hackernoon
Efficient Dockerized Database Monitoring with Dockerized PMM | HackerNoon
Learn how to monitor your databases with ease using Docker and Percona Monitoring and Management (PMM). PMM is a free and open-source platform for monitoring an
Integrating Manticore Search with Apache Superset
#apachesuperset #apache #manticoresearch #mysql #data #dataanalysis #database #databaseadministration
https://hackernoon.com/integrating-manticore-search-with-apache-superset
#apachesuperset #apache #manticoresearch #mysql #data #dataanalysis #database #databaseadministration
https://hackernoon.com/integrating-manticore-search-with-apache-superset
Hackernoon
Integrating Manticore Search with Apache Superset | HackerNoon
In this article, we’ll provide a step-by-step tutorial that will guide you through connecting Manticore to Apache Superset and adding a chart.
Different Types of Normal Form
#programming #normalform #databasedesign #dataintegrity #redundancy #softwaredevelopment #database #databaseadministration
https://hackernoon.com/different-types-of-normal-form
#programming #normalform #databasedesign #dataintegrity #redundancy #softwaredevelopment #database #databaseadministration
https://hackernoon.com/different-types-of-normal-form
Hackernoon
Different Types of Normal Form | HackerNoon
Understanding the different types of normal forms is essential for anyone involved in designing and optimizing relational databases.
Connecting a Traditional Web App to a Postgres Database
#programming #webdevelopment #webappdevelopment #postgres #pythonflask #databaseadministration #dockercontainers #goodcompany #hackernoones #hackernoonhi #hackernoonzh #hackernoonvi #hackernoonfr #hackernoonpt #hackernoonja
https://hackernoon.com/connecting-a-traditional-web-app-to-a-postgres-database
#programming #webdevelopment #webappdevelopment #postgres #pythonflask #databaseadministration #dockercontainers #goodcompany #hackernoones #hackernoonhi #hackernoonzh #hackernoonvi #hackernoonfr #hackernoonpt #hackernoonja
https://hackernoon.com/connecting-a-traditional-web-app-to-a-postgres-database
Hackernoon
Connecting a Traditional Web App to a Postgres Database | HackerNoon
Learn how to connect a traditional web app to a Postgres database, in a way with requires minimal/no code changes and no firewall management
Automating MongoDB Sharded Cluster Deployment with Ansible
#ansible #mongodb #installmongodb #shardedcluster #automation #iac #ansiblerole #databaseadministration
https://hackernoon.com/automating-mongodb-sharded-cluster-deployment-with-ansible
#ansible #mongodb #installmongodb #shardedcluster #automation #iac #ansiblerole #databaseadministration
https://hackernoon.com/automating-mongodb-sharded-cluster-deployment-with-ansible
Hackernoon
Automating MongoDB Sharded Cluster Deployment with Ansible
Master the art of deploying MongoDB sharded clusters with Ansible—a detailed step-by-step guide for seamless automation.
Here's What to Know About Apache Cassandra 5.0
#opensource #apachecassandra #nosqldatabases #databaseadministration #distributeddatabase #opensourcedatabase #moansariinterview #cassandra50
https://hackernoon.com/heres-what-to-know-about-apache-cassandra-50
#opensource #apachecassandra #nosqldatabases #databaseadministration #distributeddatabase #opensourcedatabase #moansariinterview #cassandra50
https://hackernoon.com/heres-what-to-know-about-apache-cassandra-50
Hackernoon
Here's What to Know About Apache Cassandra 5.0 | HackerNoon
Learn about the new features of the open source Apache Cassandra 5.0 database, including performance, advanced querying, and more.
Do Database Administrators Still Matter in the Age of Managed Databases?
#databaseadministration #bigdata #cloudinfrastructure #cloudnative #database #manageddatabaseservices #databaseadministrators #businessstrategy
https://hackernoon.com/do-database-administrators-still-matter-in-the-age-of-managed-databases
#databaseadministration #bigdata #cloudinfrastructure #cloudnative #database #manageddatabaseservices #databaseadministrators #businessstrategy
https://hackernoon.com/do-database-administrators-still-matter-in-the-age-of-managed-databases
Hackernoon
Do Database Administrators Still Matter in the Age of Managed Databases?
Discover how the database administrator role is evolving with managed services like AWS RDS.