Live Migration from Azure Database for MySQL to MySQL Database Service on OCI
Read: https://lefred.be/?p=5395
Read: https://lefred.be/?p=5395
Day 16/100
Scylla Manager Agent
Reads config from scylla API on start
Listens on Scylla
CPU pinning
Agent conf file etc/scylla-manager-agent/scylla-manager-agent.yaml
Scylla Manager Backup Benefits
Data selection - single table or entire keyspace
deduplica...
Read: https://rawdatareaders.hashnode.dev/day-16100
Scylla Manager Agent
Reads config from scylla API on start
Listens on Scylla
CPU pinning
Agent conf file etc/scylla-manager-agent/scylla-manager-agent.yaml
Scylla Manager Backup Benefits
Data selection - single table or entire keyspace
deduplica...
Read: https://rawdatareaders.hashnode.dev/day-16100
Run SQL Server on macOS + Docker
Intro
If you haven't seen Microsoft's latest Docs site update, you really should check them out. There is a getting started article regarding SQL Server (2017) Containers on Linux and other OSs including Azure. The SQL Server 2019 version article is ...
Read: https://itsjoshcampos.codes/run-sql-server-on-macos-docker
Intro
If you haven't seen Microsoft's latest Docs site update, you really should check them out. There is a getting started article regarding SQL Server (2017) Containers on Linux and other OSs including Azure. The SQL Server 2019 version article is ...
Read: https://itsjoshcampos.codes/run-sql-server-on-macos-docker
👎2
Choosing a Database for Serverless Applications
Originally posted at Serverless
When designing and building an application, one of the key considerations is which database to use. A poor decision here can cost you severely, either by requiring costly ongoing maintenance of a database or by forcing...
Read: https://serverlessinc.hashnode.dev/choosing-a-database-for-serverless-applications
Originally posted at Serverless
When designing and building an application, one of the key considerations is which database to use. A poor decision here can cost you severely, either by requiring costly ongoing maintenance of a database or by forcing...
Read: https://serverlessinc.hashnode.dev/choosing-a-database-for-serverless-applications
How to use MongoDB with Node.js
Introduction
When working with a server, we will always have to save and retrieve data using a database. There are many server-side languages and databases. In this article, we will learn how to use MongoDB with Node.js
MongoDB is a non-relational d...
Read: https://backendbro.hashnode.dev/how-to-use-mongodb-with-nodejs
Introduction
When working with a server, we will always have to save and retrieve data using a database. There are many server-side languages and databases. In this article, we will learn how to use MongoDB with Node.js
MongoDB is a non-relational d...
Read: https://backendbro.hashnode.dev/how-to-use-mongodb-with-nodejs
Import sample database into AWS MySQL using Workbench & Shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with 2 variations: Full dataset (~170 MB) including 300024 employee records and Small dataset (~6 MB) including 10000 employee reco...
Read: https://adelafun.hashnode.dev/import-sample-database-into-aws-mysql-using-workbench-and-shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with 2 variations: Full dataset (~170 MB) including 300024 employee records and Small dataset (~6 MB) including 10000 employee reco...
Read: https://adelafun.hashnode.dev/import-sample-database-into-aws-mysql-using-workbench-and-shell
Import sample database into AWS MySQL using Workbench & Shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-mysql-using-workbench-and-shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-mysql-using-workbench-and-shell
Data Insertion and Data Persistence in a Vector Database
Milvus architecture recap
SDK sends data requests to proxy, the portal, via load balancer. Then the proxy interacts with coordinator service to write DDL (data definition language) and DML (data manipulation language) requests into message storage.
...
Read: https://angela.hashnode.dev/data-insertion-and-data-persistence-in-a-vector-database
Milvus architecture recap
SDK sends data requests to proxy, the portal, via load balancer. Then the proxy interacts with coordinator service to write DDL (data definition language) and DML (data manipulation language) requests into message storage.
...
Read: https://angela.hashnode.dev/data-insertion-and-data-persistence-in-a-vector-database
How to create and test a GitHub Action that generates types from Supabase database
Recently I started a side project Billy, a React Native bill tracker app which uses Supabase for user management & database. Initially, I wasn’t too sure of all the fields that the Bill model should have, so as I developed the project, the data model...
Read: https://blog.esteetey.dev/how-to-create-and-test-a-github-action-that-generates-types-from-supabase-database
Recently I started a side project Billy, a React Native bill tracker app which uses Supabase for user management & database. Initially, I wasn’t too sure of all the fields that the Bill model should have, so as I developed the project, the data model...
Read: https://blog.esteetey.dev/how-to-create-and-test-a-github-action-that-generates-types-from-supabase-database
Creating A Hot Standby In PostgreSQL
In today’s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: [crayon-624d7770b7251200400556/] To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and …
Read: Creating A Hot Standby In PostgreSQL.
In today’s post, I will show you Creating A Hot Standby In PostgreSQL. PostgreSQL Community 13 Installation: [crayon-624d7770b7251200400556/] To create Stanby, we need two servers with Postgresql Community 13 installed. If you have not installed, you can install from the link above. There are operations that need to be done on both the master and …
Read: Creating A Hot Standby In PostgreSQL.
Securely connect to an Amazon RDS or Amazon EC2 database instance remotely with your preferred GUI
Read: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/
Read: https://aws.amazon.com/blogs/database/securely-connect-to-an-amazon-rds-or-amazon-ec2-database-instance-remotely-with-your-preferred-gui/
QVentures and MongoDB Partner to Support the Next Generation of B2B SaaS Founders
Read: https://www.mongodb.com/blog/post/qventures-mongodb-partner-support-next-generation-b2b-saas-founders
Read: https://www.mongodb.com/blog/post/qventures-mongodb-partner-support-next-generation-b2b-saas-founders
Introducing Gap Filling for Time Series Data in MongoDB 5.3
Read: https://www.mongodb.com/blog/post/introducing-gap-filling-time-series-data-mongodb-5-3
Read: https://www.mongodb.com/blog/post/introducing-gap-filling-time-series-data-mongodb-5-3
Cut-over logic in vitess schema migrations
Read: https://vitess.io/blog/2022-04-06-online-ddl-vitess-cut-over/
Read: https://vitess.io/blog/2022-04-06-online-ddl-vitess-cut-over/
Migrate self-managed MariaDB to Amazon Aurora MySQL
Read: https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/
Read: https://aws.amazon.com/blogs/database/migrate-self-managed-mariadb-to-amazon-aurora-mysql/
Building a Blog with FastAPI, MySQL, SQLAlchemy, and Alembic
In this tutorial you'll learn how to build an API using FastAPI and MySQL. we'll be interacting with the database using mysqlclient, sqlalchemy, and alembic for migrations.
App Overview
these are the endpoints we are going to be building in this app...
Read: https://pneuma.hashnode.dev/building-a-blog-with-fastapi-mysql-sqlalchemy-and-alembic
In this tutorial you'll learn how to build an API using FastAPI and MySQL. we'll be interacting with the database using mysqlclient, sqlalchemy, and alembic for migrations.
App Overview
these are the endpoints we are going to be building in this app...
Read: https://pneuma.hashnode.dev/building-a-blog-with-fastapi-mysql-sqlalchemy-and-alembic
Readable MultiAZ Cluster with AWS RDS MySQL under the hood.
Read: http://mydbops.wordpress.com/?p=11236
Read: http://mydbops.wordpress.com/?p=11236
Understanding Triggers in SQL Server
A trigger is an object having a collection of code or codes which fires automatically when an event occurs in the database server. The most used database events which cause the database to execute triggers are DDL(DATA DEFINITION LANGUAGE) Event and ...
Read: https://mssqlserver.dev/understanding-triggers-in-sql-server-with-examples
A trigger is an object having a collection of code or codes which fires automatically when an event occurs in the database server. The most used database events which cause the database to execute triggers are DDL(DATA DEFINITION LANGUAGE) Event and ...
Read: https://mssqlserver.dev/understanding-triggers-in-sql-server-with-examples
Import sample database into AWS RDS MySQL using Workbench & Shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-rds-mysql-using-workbench-and-shell
Bytebase open-sourced an Employee sample database for MySQL https://github.com/bytebase/employee-sample-database-mysql with two variations: A Full dataset (~170 MB) including 300024 employee records and a Small dataset (~6 MB) including 10000 employe...
Read: https://devrel.bytebase.com/import-sample-database-into-aws-rds-mysql-using-workbench-and-shell
👍1
Анонс стрима 07.04.22: Сжать данные в SQL Server в десятки раз, а ускорить запросы в сотни
У меня в планах на этот год на Хабре было опубликовать пару статей по колумсторам и XML. Материала за годы накопилось предостаточно и выходило на 30..40 страниц текста - фактически мини-книга. Но когда за окном Градами и прочей дичью херячили месяц... оно как-то не складывалось настроиться на конструктив. Вначале агрессия на виновников этой дичи, потом паника за близких... печаль что все планы порушились и непонятно что ждать. А сейчас прям совсем ровно на все жизненные трудности ибо как-то получается разруливать все и помогать людям.
Так вот... со знакомым решили вернуться к прежней теме и постримить сегодня о колумсторах. Без политики, срача и прочего. Очень много шутеек о том как живеться в условиях спецоперации и немного полезной инфы о колумсторах на SQL Server.
Кто хочет из коллег послушать: https://www.youtube.com/watch?v=wXH3fUN0PsM
You are welcome!
...
Читать: https://habr.com/ru/post/659541/
У меня в планах на этот год на Хабре было опубликовать пару статей по колумсторам и XML. Материала за годы накопилось предостаточно и выходило на 30..40 страниц текста - фактически мини-книга. Но когда за окном Градами и прочей дичью херячили месяц... оно как-то не складывалось настроиться на конструктив. Вначале агрессия на виновников этой дичи, потом паника за близких... печаль что все планы порушились и непонятно что ждать. А сейчас прям совсем ровно на все жизненные трудности ибо как-то получается разруливать все и помогать людям.
Так вот... со знакомым решили вернуться к прежней теме и постримить сегодня о колумсторах. Без политики, срача и прочего. Очень много шутеек о том как живеться в условиях спецоперации и немного полезной инфы о колумсторах на SQL Server.
Кто хочет из коллег послушать: https://www.youtube.com/watch?v=wXH3fUN0PsM
You are welcome!
...
Читать: https://habr.com/ru/post/659541/