Migrating Databases from Heroku Postgres to AWS
Many teams host their relational data storage on Heroku. However, over time, a significant number find themselves migrating their Postgres workloads over to AWS. In this article, I'll discuss why many teams are making this jump. I'll also detail the ...
Read: https://blog.tinystacks.com/migrate-heroku-postgres-aws
Many teams host their relational data storage on Heroku. However, over time, a significant number find themselves migrating their Postgres workloads over to AWS. In this article, I'll discuss why many teams are making this jump. I'll also detail the ...
Read: https://blog.tinystacks.com/migrate-heroku-postgres-aws
New MariaDB Enterprise Server Releases with backported Features and Rocky Linux Support now available
Read: https://mariadb.com/?p=31832
Read: https://mariadb.com/?p=31832
Most Significant Data Breaches Of The Twenty-first Century
Multiple databases of stolen records are freely exchanged on Dark Web networks, which is nothing new. Stolen data may be utilised in a variety of attacks, such as spear-phishing, random malspam campaigns, and so on. However, a new, alarming data brea...
Read: https://khansa.hashnode.dev/most-significant-data-breaches-of-the-twenty-first-century
Multiple databases of stolen records are freely exchanged on Dark Web networks, which is nothing new. Stolen data may be utilised in a variety of attacks, such as spear-phishing, random malspam campaigns, and so on. However, a new, alarming data brea...
Read: https://khansa.hashnode.dev/most-significant-data-breaches-of-the-twenty-first-century
Automate AI Model Building in SkySQL: MariaDB & MindsDB Collaboration
Read: https://mariadb.com/?p=31716
Read: https://mariadb.com/?p=31716
How the N+1 query problem can burn your database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-problem-can-burn-your-database
Overview
Have you ever watched a movie/series or experience your self going to a hotel where they have room service?, let's put that you go to one of these hotels, where the hotel’s restaurant is at the first floor, and you’re hosteling at the 10th f...
Read: https://hernanreyes.dev/how-the-n1-query-problem-can-burn-your-database
Amazon Aurora PostgreSQL backups and long-term data retention methods
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-backups-and-long-term-data-retention-methods/
Read: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-backups-and-long-term-data-retention-methods/
MySQL Support in Database Tools in OCI
Database Tools in OCI now supports connections to the MySQL Database Service.
Read: https://blogs.oracle.com/database/post/mysql-support-in-database-tools-in-oci
Database Tools in OCI now supports connections to the MySQL Database Service.
Read: https://blogs.oracle.com/database/post/mysql-support-in-database-tools-in-oci
Oracle
MySQL Support in Database Tools in OCI
Database Tools in OCI now supports connections to the MySQL Database Service.
Cloud Database Services for Every Workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to choose the best database service to meet your specific needs, whether it’s features, SLAs, or even data residency requirements.
Read: https://blogs.oracle.com/database/post/cloud-database-services-for-every-workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to choose the best database service to meet your specific needs, whether it’s features, SLAs, or even data residency requirements.
Read: https://blogs.oracle.com/database/post/cloud-database-services-for-every-workload
Oracle
Cloud Database Services for Every Workload
Oracle offers three cloud database service families that are 100% compatible with the industry leading Oracle Database: Oracle Autonomous Database, Oracle Exadata Database Service, and Oracle Base Database Service. These services give you the freedom to…
Databases Migrations
Introdução
Esse trimestre estou estudando a disciplina de DBRE(Database Reliability Engineer) no curso de Pós Graduação DevOps and Cloud Solutions do Mackenzie que está sendo ministrada pelo professor Walter o qual solicitou um trabalho acadêmico sob...
Read: https://santospedroh.hashnode.dev/databases-migrations
Introdução
Esse trimestre estou estudando a disciplina de DBRE(Database Reliability Engineer) no curso de Pós Graduação DevOps and Cloud Solutions do Mackenzie que está sendo ministrada pelo professor Walter o qual solicitou um trabalho acadêmico sob...
Read: https://santospedroh.hashnode.dev/databases-migrations
Built With MongoDB: Overcoming Employee Burnout Through Pioneera
Read: https://www.mongodb.com/blog/post/built-mongodb-overcoming-employee-burnout-through-pioneera
Read: https://www.mongodb.com/blog/post/built-mongodb-overcoming-employee-burnout-through-pioneera
Announcing Open Source Realtime Analytical database Apache Doris as a Top-Level Project
Apache Doris is a modern, high-performance and real-time analytical database based on MPP. It is well known for its high-performance and easy-to-use. It can return query results under massive data within only sub-seconds. It can support not only high...
Read: https://github.com/apache/incubator-doris/announcing-open-source-realtime-analytical-database-apache-doris-as-a-top-level-project
Apache Doris is a modern, high-performance and real-time analytical database based on MPP. It is well known for its high-performance and easy-to-use. It can return query results under massive data within only sub-seconds. It can support not only high...
Read: https://github.com/apache/incubator-doris/announcing-open-source-realtime-analytical-database-apache-doris-as-a-top-level-project
Designing Data Intensive Applications: Ch3. Storage and Retrieval | Part 2
In the previous article of this series, we discussed the first part of chapter 3 in Data Intensive Applications which discussed storage and retrieval. We discussed many storage related topics, mainly data structures used for storage in data stores, s...
Read: https://sayedalesawy.hashnode.dev/designing-data-intensive-applications-ch3-storage-and-retrieval-or-part-2
In the previous article of this series, we discussed the first part of chapter 3 in Data Intensive Applications which discussed storage and retrieval. We discussed many storage related topics, mainly data structures used for storage in data stores, s...
Read: https://sayedalesawy.hashnode.dev/designing-data-intensive-applications-ch3-storage-and-retrieval-or-part-2
Building Together: MongoDB Is Google Cloud’s Technology Partner of the Year for Data Management
Read: https://www.mongodb.com/blog/post/mongodb-google-clouds-technology-partner-year-data-management
Read: https://www.mongodb.com/blog/post/mongodb-google-clouds-technology-partner-year-data-management
Optimized bulk loading in Amazon RDS for PostgreSQL
Read: https://aws.amazon.com/blogs/database/optimized-bulk-loading-in-amazon-rds-for-postgresql/
Read: https://aws.amazon.com/blogs/database/optimized-bulk-loading-in-amazon-rds-for-postgresql/
👍1
Generate an assessment report for a fleet of database servers using the AWS SCT multiserver assessor
Read: https://aws.amazon.com/blogs/database/generate-an-assessment-report-for-a-fleet-of-database-servers-using-the-aws-sct-multiserver-assessor/
Read: https://aws.amazon.com/blogs/database/generate-an-assessment-report-for-a-fleet-of-database-servers-using-the-aws-sct-multiserver-assessor/
Неожиданная находка, которая освобождает 20 GB неиспользованного индексного пространства
Раз в несколько месяцев мы получаем предупреждения от системы мониторинга базы данных о том, что свободное место скоро закончится. Обычно мы просто выделяем больше места и забываем об этом, однако в этот раз мы мы были на карантине и система была нагружена меньше, чем обычно. И тут мы подумали, что это хорошая возможность провести чистку.
Начнем с конца: в итоге нам удалось освободить более чем 70 GB не оптимизированного и неиспользуемого пространства без удаления индексов и данных.
Читать: https://habr.com/ru/post/672102/
Раз в несколько месяцев мы получаем предупреждения от системы мониторинга базы данных о том, что свободное место скоро закончится. Обычно мы просто выделяем больше места и забываем об этом, однако в этот раз мы мы были на карантине и система была нагружена меньше, чем обычно. И тут мы подумали, что это хорошая возможность провести чистку.
Начнем с конца: в итоге нам удалось освободить более чем 70 GB не оптимизированного и неиспользуемого пространства без удаления индексов и данных.
Читать: https://habr.com/ru/post/672102/
10 Things We Learned at MongoDB World 2022
Read: https://www.mongodb.com/blog/post/10-things-learned-mongodb-world-2022
Read: https://www.mongodb.com/blog/post/10-things-learned-mongodb-world-2022
Making automatic backups to the cloud for free
There are many things you might want to make backups of. It could be of your code, of assets, or of your entire database.
Whatever it is, backups will make sure you don't lose them. In this blog post, we'll look at making backups of your MySQL databa...
Read: https://robinmartijn.hashnode.dev/making-automatic-backups-to-the-cloud-for-free
There are many things you might want to make backups of. It could be of your code, of assets, or of your entire database.
Whatever it is, backups will make sure you don't lose them. In this blog post, we'll look at making backups of your MySQL databa...
Read: https://robinmartijn.hashnode.dev/making-automatic-backups-to-the-cloud-for-free
Triggers in T-SQL
Introduction
Triggers:
A special type of Stored Procedure that is automatically executed when events like (data modifications) occur on the database server
Types of Triggers:
In T-sql server there are 3 main types of triggers
Data Manipulation ...
Read: https://meska54.hashnode.dev/triggers-in-t-sql
Introduction
Triggers:
A special type of Stored Procedure that is automatically executed when events like (data modifications) occur on the database server
Types of Triggers:
In T-sql server there are 3 main types of triggers
Data Manipulation ...
Read: https://meska54.hashnode.dev/triggers-in-t-sql
Triggers in T-SQL - Part 1
Introduction
Triggers:
A special type of Stored Procedure that is automatically executed when events like (data modifications) occur on the database server
Types of Triggers:
In T-sql server there are 3 main types of triggers
Data Manipulation ...
Read: https://meska54.hashnode.dev/triggers-in-t-sql-part-1
Introduction
Triggers:
A special type of Stored Procedure that is automatically executed when events like (data modifications) occur on the database server
Types of Triggers:
In T-sql server there are 3 main types of triggers
Data Manipulation ...
Read: https://meska54.hashnode.dev/triggers-in-t-sql-part-1