Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Grant Connect
Operational Considerations for Managing Stateful Workloads
When managing stateful workloads, whether in Kubernetes or traditional infrastructure, operational concerns like isolation, lifecycle management, security, disaster recovery, scalability, and observability take center stage. While the examples focus on AWS, PostgreSQL, and Kubernetes, the principles and best practices discussed here are broadly applicable to any environment.
低成本高可用方案！Linux系统下SQL Server数据库镜像配置全流程详解
最近遇到一个客户需求，客户的生产环境有大量的SQL Server数据库（大概180套），客户的诉求是需要把生产环境的Windows系统转为Linux系统，转为Linux系统之后需要沿用原来的数据库高可用方案。把数据库转到Linux系统比较容易，因为从SQL Server 2017开始就支持Linux系统，但是要沿用原来的数据库高可用方案就有点难度。了解到客户之前的生产环境所用的数据库高可用方案是数据库镜像，因为客户的生产环境高可用性要求不算太高，数据库镜像技术已经可以完全满足要求。 于是本人建议客户把SQL Server迁移到Linux系统之后，依然使用之前的数据库镜像这种数据库高可用方案。数据库镜像这种技术本身搭建非常简单，不需要借助任何第三方组件，搭建步骤跟Windows系统上的一模一样，而且从SQL Server 2005版本开始就已经引入数据库镜像，历经9个大版本迭代，稳定性久经考验。 在SQL Server 2016版本引入了多线程并行redo，它可以 （1）显著减少镜像集群和AlwaysOn可用性组集群的数据同步延迟。...
Oracle Database 23AI for GenAI RAG Implementation, Part 1
At the recent CloudWorld event, Oracle introduced Oracle Database 23c, its next-generation database, which incorporates AI capabilities through the addition of AI vector search to its converged database. This vector search feature allows businesses to run multimodal queries that integrate various data types, enhancing the usefulness of GenAI in business applications. With Oracle Database 23c, there’s no need for a separate database to store and query AI-driven data.
Setting Up Logical Replication with pglogical in PostgreSQL on AWS
In today's data-driven world, the ability to replicate databases efficiently and seamlessly across different environments is crucial. One powerful tool for achieving this in PostgreSQL is pglogical, an extension that provides logical replication capabilities. In this article, we'll walk through the steps to set up logical replication between two PostgreSQL databases hosted on AWS using pglogical.
How to create a read-only user in PostgreSQL
Steps Overview Connect to PostgreSQL: Start by connecting to the PostgreSQL database with superuser privileges. Create a Role for Read-Only Access: We will create a group role that has only read privileges on all tables in the target database, ensuring future tables will also inherit these permissions. Grant Necessary Privileges: We'll grant the SELECT privilege on all existing tables, views, and sequences in the schema. Additionally, default privileges will be set for any future tables.
The Home Server Journey - 5: Rebuilding Burned Bridges
Hello again. It's been a while (in relative terms) Having our own Matrix rooms feels amazing indeed, but left us too isolated, at least until we manage to bring people in. I know that in the beginning I've warned about making sacrifices, but it doesn't have to be that hard. In life some metaphorical burned bridges are better left unrepaired, but here let's try reconnecting to our old Internet life in an interesting way, right?
Installing and setting up Postgres in Ubuntu
At work, we handle a lot of short-term projects, typically lasting 3-8 weeks. These projects don't require a complex deployment setup. Instead, we deploy each project on a single VPS instance, with all the stacks bundled together on the same system. Sure, it's a single point of failure and not the ideal setup, it however matches our clients’ budget and allows us to deliver quickly. Luckily, we've never faced a catastrophic failure with this approach (yet).
Azure PostgreSQL Flexible Server and Entra Groups – SQLServerCentral
My company is moving from an Azure PostgreSQL single server to a flexible server. We want to set up managed identity/Entra access instead of having roles with passwords for every person/app. In particular, we want to use Entra groups. It is “a fully managed database service designed to provide more granular control and flexibility over database management functions and configuration settings.” You can learn more about how to set it up here and more about its features here.
AWS DMS homogenous migration from PostgreSQL to Amazon Aurora PostgreSQL | Amazon Web Services
AWS announced AWS Database Migration Service (AWS DMS) homogeneous migration for several . With AWS DMS homogenous migration, you can migrate data from your source database to an equivalent engine on AWS using native database tools. Homogeneous data migrations are serverless, which means that AWS DMS automatically provision the resources that are required for your migration.
How to Create a Read-Only User in PostgreSQL
Sometimes, we will need read-only access to our database, right? So, we can add a read-only access user using the below commands But, make sure that you can connect to the database as the admin user.
踩坑指南：入门OpenTenBase之监控篇 - 努力的小雨 - 博客园
本次监控将采用Prometheus、Grafana可视化工具以及postgres_exporter对OpenTenBase进行全面监控和优化。 Docker安装 1、Docker要求 CentOs 系统的内核版本高于 3.10 通过 uname-r命令查看你当前的内核版本 uname -r 2、使用 root 权限登录 Centos。确保 yum 包更新到最新。 yum -y update 3、卸载旧版本(如果安装过旧版本的话) sudo yum remove -y docker* 4、安装需要的软件包，yum-utl 提供yum-config-manager功能，另外两个是devicemapper驱动依赖的 yum install -y yum-utils 5、设置yum源，并更新yum 的包索引 yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo yum makecache 6、安装docker yum install -y...
Migrate Oracle collections to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL | Amazon Web Services
Migrating from Oracle to PostgreSQL can involve several steps to ensure a smooth transition. A notable example is an , which is a feature that Oracle database developers commonly use. PostgreSQL does not directly support Oracle collections, and there currently isn’t an extension that adds this capability. There are several decisions you have to make when migrating Oracle collections to PostgreSQL to successfully make the transition.
prometheus|云原生|prometheus项目安装postgres-exporter监视组件的部署简介-阿里云开发者社区
2023-12-21 5 本文涉及的产品 云原生数据库 PolarDB MySQL 版，通用型 2核4GB 50GB EMR Serverless StarRocks，5000CU*H 48000GB*H 云原生数据库 PolarDB MySQL 版，Serverless 5000PCU 100GB 简介： prometheus|云原生|prometheus项目安装postgres-exporter监视组件的部署简介 最近刚好得空再琢磨prometheus，那肯定要玩玩postgrs-expoter这个数据库监控了，要不没办法体现prometheus的强大。 OK，postgres-exporter和其它的监视组件例如node-exporter基本是一样的，都是由go语言编写的，但是有一点雪微不同，它是监控数据库的，因此要和数据库打一点交道。所以呢，数据库需要有安装pg_stat插件，否则postgres-exporter可能会工作的不太好，很多数据收集不到吧。...
OceanBase 数据库入门知识
🙈作者简介：练习时长两年半的Java up主 🙉个人主页：程序员老茶 🙊 ps:点赞👍是免费的，却可以让写博客的作者开兴好久好久😎 📚系列专栏：Java全栈，计算机系列（火速更新中） 💭 格言：种一棵树最好的时间是十年前，其次是现在 🏡动动小手，点个关注不迷路，感谢宝子们一键三连 课程名：OceanBase OceanBase 是一款阿里巴巴集团开发的高性能、高可用、高扩展性的分布式关系型数据库。它采用了分布式架构，支持大规模数据存储和高并发访问，能够满足企业级应用的需求。本文将介绍如何下载、安装和使用 OceanBase 数据库，并提供详细的解释和代码示例。 2.1 高性能 OceanBase 数据库采用了多种优化技术，如读写分离、分布式事务、内存表等，能够大幅提高数据库的读写性能。同时，它还支持多种存储引擎，包括关系型引擎、非关系型引擎等，能够根据不同的业务需求选择最合适的存储引擎。 2.2 高可用性 OceanBase...
SQL注入之Oracle注入_程序员小勇的博客-CSDN博客
SQL注入之Oracle注入 前言 Oracle Database，又名Oracle RDBMS，或简称Oracle。是甲骨文公司的一款关系数据库管理系统。它是在数据库领域一直处于领先地位的产品。可以说Oracle数据库系统是世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能强，适用于各类大、中、小微机环境。它是一种高效率的、可靠性好的、适应高吞吐量的数据库方案。 特点： 1）完整的数据管理功能 2）数据的大量性 3）数据保存的持久性 4）数据的共享性 5）数据的可靠性 1.下载Oracle Database 11g Release 2 安装包 Windows环境（Win10）下安装、配置桌面类Oracle Database 11g Release 2 PS1：安装包分为了两个压缩包，需要都下载下来才能进行安装 132位&64位百度云分享链接及提取码： 链接: https://pan.baidu.com/s/1mh7s1nU 密码: 8neh 2.将下载好的两个压缩包解压到database同一个路径下（即进行合并）...
flink cdc多种数据源安装、配置与验证（超详细总结）
本文目录结构： |___ 1. 前言 |___ 2. 数据源安装与配置 |______ 2.1 MySQL |_________ 2.1.1 安装 |_________ 2.1.2 CDC 配置 |______ 2.2 Postgresql |_________ 2.2.1 安装 |_________ 2.2.2 CDC 配置 |______ 2.3 Oracle |_________2.3.1 安装 |_________2.3.2 CDC 配置 |_______2.4 SQLServer |_________2.4.1 安装 |_________2.4.2 CDC 配置 |___ 3.
flink postgresql cdc实时同步（含pg安装配置等）
类型版本/描述 docker 20.10.9 Postgresql 10.6 初始化账号密码：postgres/postgres 普通用户：test1/test123 数据库：test_db flink 1.13.6 step1： 拉取 PostgreSQL 10.6 版本的镜像： docker pull postgres:10.6 step2：创建并启动 PostgreSQL 容器，在这里，我们将把容器的端口 5432 映射到主机的端口 30028，账号密码设置为postgres，并将 pgoutput 插件加载到 PostgreSQL 实例中： docker run -d -p 30028:5432 --name postgres-10.6 -e POSTGRES_PASSWORD=postgres postgres:10.6 -c 'shared_preload_libraries=pgoutput' step3： 查看容器是否创建成功： docker ps | grep postgres-10.6 step1：docker进去Postgresql数据的容器： docker...
Migrate on-premises SQL Server workloads to Amazon RDS Custom for SQL Server using distributed availability groups | Amazon Web Services
In this post, we provide a SQL Server Always On cluster database migration pattern solution to Amazon Relational Database Service (Amazon RDS) Custom for SQL Server using distributed availability groups. This solution helps reduce the migration downtime through continuous data synchronization combined with a failover process. This post is not a high availability and disaster recovery solution; it is for migration purposes only.
Mac m1 通过docker安装oracle
前置条件依赖 docker colima Docker安装 官网直接下载安装 Colima安装 使用homebrew安装： brew install colima 查看是否安装成功： colima --version 启用Colima：架构为x86_64 内存为4G colima start --arch x86_64 --memory 4 第一次启动行需要下载虚拟机镜像创建虚拟机，需要慢慢等，最终结果： 使用limact工具查看虚拟机的情况 limactl list Oracle安装 拉取镜像： docker pull deepdiver/docker-oracle-xe-11g 查看镜像 docker images 启动镜像 docker run -d -p 1526:1521 --name oracle11g deepdiver/docker-oracle-xe-11g 查看镜像 docker ps 进入容器 docker exec -it {CONTAINER ID} /bin/bash 登录Oracle，用户名：system，密码：oracle sqlplus...
Migrate Oracle bulk binds to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL | Amazon Web Services
To migrate an Oracle database to Amazon Aurora PostgreSQL-Compatible Edition, you usually need to perform both automated and manual tasks. The automated tasks include schema conversion and data migration, which can be handled with the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS), respectively. The manual tasks involve post-schema AWS SCT migration touch-ups for certain database objects that can’t be migrated automatically.
Oracle基本介绍与基本使用_我要出家当道士的博客-CSDN博客
目录 1、整体逻辑架构 （1）、数据文件（dbf）是数据库的物理存储单位，表空间是数据库的逻辑组成部分。表空间可以包含多个数据文件，但数据文件只能属于一个表空间。数据文件一旦加入表空间后就无法改变，也无法删除，只能通过删除其所属表空间进行删除。 （2）、表空间是Oracle对物理数据库上相关文件的逻辑映射，一个数据库在逻辑上分为一到多个表空间。 （3）、用户是在数据库实例下创建的，实例之间相互隔离（不同实例可以创建相同名称的用户）。 （4）、表是由用户维护的，表数据存放在表空间中，表空间会随机把这些数据存放到一个或多个数据文件中。用户之间数据相互隔离（即使一个表空间下，不同用户也可以创建同名表）。 2、数据库与实例 Oracle 数据库服务器由一个数据库和至少一个数据库实例组成。 数据库是一组存储数据的文件，而数据库实例则是管理数据库文件的内存结构。简单的说，Oracle数据库服务器包含两部分：文件（数据库）+ 内存（实例）。 数据库和实例是紧密相连的，所以我们一般说的 Oracle 数据库，通常指的就是实例和数据库。 2.1 数据库（文件） Oracle...
Continuous Query Notification (CQN) feature does not work with ADB - Ask TOM
We are trying to perform a simple POC to make use of the CQN feature with ADW and ATP. We are following the walkthrough example available at : https://docs.oracle.com/en/ database/oracle/oracle-database/19/jjdbc/continuos-query-notification.html#GUID-17D0D7C5-77C9-420D-9D13-F668C1056792 When we run the following JAVA code, Database change registrations are getting created properly. We can see them getting created in USER_CHANGE_NOTIFICATION_REGS table .
Australian Government grants $52 million to aged care facilities which will incentivise them to record the elderly dying as COVID to boost their funding
Australian National Review’s community of readers and following is stronger than ever. However, advertising revenues across the media are diminishing, especially without a paywall. Will you help us remain a force for good and expose corruption in media, government and industry? We want to continue on our mission to enforce a free press, especially in this day and age where mainstream media and big corporations are going all out to suppress us.
Evolutionary Database Design
Over the last decade we've developed and refined a number of techniques that allow a database design to evolve as an application develops. This is a very important capability for agile methodologies. The techniques rely on applying continuous integration and automated refactoring to database development, together with a close collaboration between DBAs and application developers. The techniques work in both pre-production and released systems, in green field projects as well as legacy systems.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Grant
Contact Grant, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack