Why CockroachDB Serverless is the real deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
After writing my last article about Next Gen databases, I wanted to dig into CockroachDB and all it had to offer. It seemed like such an interesting new technology to me. I had heard of them before but never put aside the time to dive in and see how ...
Read: https://pythondev.hashnode.dev/why-cockroachdb-serverless-is-the-real-deal
Physical migration of Oracle databases to Amazon RDS Custom using Data Guard
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Read: https://aws.amazon.com/blogs/database/physical-migration-of-oracle-databases-to-amazon-rds-custom-using-data-guard/
Day 1/100
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
HDFS - [Hadoop Distributed File System]
HDFS architecture looks like this -
NameNode holds all the metadata about files and directory structure and then there are
DataNodes which basically hold files in the form of blocks so DataNode holds blocks o...
Read: https://rawdatareaders.hashnode.dev/day-1
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Read: https://blogs.oracle.com/database/post/oracle-database-19c-running-memory-speed
Oracle
Oracle Database 19c Running @Memory Speed
Persistent Memory Database starting Oracle 19.12 using Oracle Memory Speed (OMS).
Building a Vector Database for Scalable Similarity Search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
According to statistics, about 80%-90% of the world's data is unstructured. Fueled by the rapid growth of the Internet, an explosion of unstructured data is expected in the coming years. Consequently, companies are in urgent need of a powerful databa...
Read: https://angela.hashnode.dev/building-a-vector-database-for-scalable-similarity-search
Accelerating Similarity Search on Really Big Data with Vector Indexing (Part II)
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii
From computer vision to new drug discovery, many popular artificial intelligence (AI) applications are powered by vector databases. Indexing, a process of organizing data that drastically accelerates big data search, enables us to efficiently query m...
Read: https://angela.hashnode.dev/accelerating-similarity-search-on-really-big-data-with-vector-indexing-part-ii
How to Install Adminer MySQL Database Management Tool on Alma Linux 8
Read: https://www.howtoforge.com/how-to-install-adminer-on-alma-linux-8/
Read: https://www.howtoforge.com/how-to-install-adminer-on-alma-linux-8/
Отчёт с митапа: PostgreSQL-as-Service — можем, умеем, практикуем
Выкладываем запись с Ozon Tech PostgreSQL Meetup. Ранее я уже описывал нашу инфраструктуру: весь PostgreSQL основан на виртуальных машинах — 2К в тестовой среде и ~8К в проде. Это около 2К кластеров баз данных. Так как у нас микросервисная архитектура, мы придерживаемся принципа 1 сервис = 1 база. Нагрузка на базы может быть приличная: 2-2,5 млн транзакций в секунду, а WAL-трафик порядка 1.5 ГБ/c.
Рассказали, как наша команда управляет всей этой инфраструктурой, как пришли к парадигме выдачи базы по кнопке и как воплотили её в жизнь.
Видео и слайды пол катом
Читать: https://habr.com/ru/post/653521/
Выкладываем запись с Ozon Tech PostgreSQL Meetup. Ранее я уже описывал нашу инфраструктуру: весь PostgreSQL основан на виртуальных машинах — 2К в тестовой среде и ~8К в проде. Это около 2К кластеров баз данных. Так как у нас микросервисная архитектура, мы придерживаемся принципа 1 сервис = 1 база. Нагрузка на базы может быть приличная: 2-2,5 млн транзакций в секунду, а WAL-трафик порядка 1.5 ГБ/c.
Рассказали, как наша команда управляет всей этой инфраструктурой, как пришли к парадигме выдачи базы по кнопке и как воплотили её в жизнь.
Видео и слайды пол катом
Читать: https://habr.com/ru/post/653521/
How to use HarperDB custom functions to build your entire backend
What is HarperDB
When HarperDB first started they were a distributed database platform. Essentially this meant that anyone could spin up a cloud instance for creating a database for storing your data online. These databases supported both SQL and NoS...
Read: https://andrewbaisden.hashnode.dev/how-to-use-harperdb-custom-functions-to-build-your-entire-backend
What is HarperDB
When HarperDB first started they were a distributed database platform. Essentially this meant that anyone could spin up a cloud instance for creating a database for storing your data online. These databases supported both SQL and NoS...
Read: https://andrewbaisden.hashnode.dev/how-to-use-harperdb-custom-functions-to-build-your-entire-backend
EDB Postgres 13 Installation on Oracle Linux 7.8
In today’s article, I will talk about EDB Postgres 13 Installation on Oracle Linux 7.8. First of all, we install the packages that need to be installed before installation. [crayon-6239ae47a6cd4526090328/] We load the repository configuration file. [crayon-6239ae47a6cdd844206122/] After the installation is complete, we enter the edb.repo file with vi and enter the registered edb user …
Read: EDB Postgres 13 Installation on Oracle Linux 7.8.
In today’s article, I will talk about EDB Postgres 13 Installation on Oracle Linux 7.8. First of all, we install the packages that need to be installed before installation. [crayon-6239ae47a6cd4526090328/] We load the repository configuration file. [crayon-6239ae47a6cdd844206122/] After the installation is complete, we enter the edb.repo file with vi and enter the registered edb user …
Read: EDB Postgres 13 Installation on Oracle Linux 7.8.
PostgreSQL_Backup and Restore database
🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
Step 1 - Create DB backup
In pgAdmin 4 LMB click on the needed DB name and choose Backup...
2.Choose path an...
Read: https://dataviz.hashnode.dev/postgresqlbackup-and-restore-database
🎯 Target: create plain dump of PostgreSQL Database and move it to another server
🛠️ Tools and prerequisites: PostgreSQL DB and pgAdmin 4
Step 1 - Create DB backup
In pgAdmin 4 LMB click on the needed DB name and choose Backup...
2.Choose path an...
Read: https://dataviz.hashnode.dev/postgresqlbackup-and-restore-database
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Add support for security invoker views.
Read: https://postgr.es/p/5hU
Read: https://postgr.es/p/5hU
PostgreSQL_Drop Mainantanance DB
🎯 Target: drop mainantanance database
🛠️ Tools and prerequisites: Mainantanance DB and another DB and pgAdmin 4
Step 1 - Disconnect Server and Change Mainantanance DB
1.In pgAdmin 4 LMB click on the PostgreSQL 14 name, choose Disconnect Server and ...
Read: https://dataviz.hashnode.dev/postgresqldrop-mainantanance-db
🎯 Target: drop mainantanance database
🛠️ Tools and prerequisites: Mainantanance DB and another DB and pgAdmin 4
Step 1 - Disconnect Server and Change Mainantanance DB
1.In pgAdmin 4 LMB click on the PostgreSQL 14 name, choose Disconnect Server and ...
Read: https://dataviz.hashnode.dev/postgresqldrop-mainantanance-db
Introducing Hyperledger Fabric 2.2 LTS Support on Amazon Managed Blockchain
Read: https://aws.amazon.com/blogs/database/introducing-hyperledger-fabric-2-2-lts-support-on-amazon-managed-blockchain/
Read: https://aws.amazon.com/blogs/database/introducing-hyperledger-fabric-2-2-lts-support-on-amazon-managed-blockchain/
Deploy Amazon RDS databases for applications in Kubernetes
Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-databases-for-applications-in-kubernetes/
Read: https://aws.amazon.com/blogs/database/deploy-amazon-rds-databases-for-applications-in-kubernetes/
Authentication Plugin ‘***’ Cannot Be Loaded: How MySQL Searches Client-Side Plugins
Read: https://www.percona.com/blog/?p=80411
Read: https://www.percona.com/blog/?p=80411