Blog

I’m facing an issue with SQL Server Replication and INSTEAD OF UPDATE trigger. I have a table and a trigger that looks like this : CREATE TABLE [dbo].[TableA] ( [Identifier] BIGINT IDENTITY(1,1) NOT NULL, [Name] NVARCHAR(50) NOT NULL, [Description] NVARCHAR(4000) NULL, CONSTRAINT [PK_TableA] PRIMARY KEY CLUSTERED ([Identifier] ASC) ) GO CREATE TRIGGER [dbo].[TableAInsteadOfUpdate] ON [dbo].[TableA]Read more

i have remote PostgreSQL Database in cloud, and local PostgreSQL Database, i did install bucardo to make ASynchronization between the two Databases, and then added the local and remote database information to bucardo successfully: bucardo add db localDB dbhost=$ PGHOST dbport=$ PGPORT dbname=$ PGDATABASE dbuser=$ PGSUPERUSER dbpass=$ PGSUPERPASS bucardo add db remoteDB dbhost=$ PGHOST dbport=$Read more

Can anyone explain the differences from a replication db vs a mirroring db server? I have huge reports to run. I want to use a secondary database server to run my report so I can off load resources from the primary server. Should I setup a replication server or a mirrored server and why?Read more

Is anyone familiar with this error? Firstly, I am trying to set up a Pull Subscription Transactional replication where in server is outside of the firewall while the distributor and subscriber (both are on the same instance) is on our company. I tried to create a test in my local PC wherein there are 2Read more

I am running a ROW-BASE Replication. When I checked the current value for Seconds_Behind_Master, it came out to about 2 days. Is it normal to have that much lag time in RBR? If not, what is a normal average lag time between a slave and the master?Read more

We have a micro-service that has a Domain Model and have an analytical service for the domain which has its own Query Model. The domain model and the query model are stored in separate persistencies. Currently our Query Model uses a sub-set of the attributes from the Domain model. However going forward we have requirementRead more

I am configuring MySQL Group Replication in multi-primary mode to replicate all databases between two members and allowing writes on either. I have my two members IP addresses configured in the whitelist and seed list: loose-group_replication_ip_whitelist = “x.x.x.x,y.y.y.y.” loose-group_replication_group_seeds = “x.x.x.x:33061,y.y.y.y:33061” My understanding is that if in a month or two I want add aRead more

I have read couple of articles on google but not sure how DB client for example java application connect to clustered DB. All the articles I read says client will write at master node but will use slave for read. My question is how client will know which one is master(and its location) and whichRead more

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters replications in MySQL.Read more

After initializing the slave with the initial pg_basebackup I don’t see the wal sender process streaming from the master. After base backup completes here is what I see – WARNING: skipping special file “./pg_log” transaction log start point: 115/91000020 WARNING: skipping special file “./pg_log”s (/data/catalog/db/backup_) 53641942/53641942 kB (100%), 3/3 tablespaces transaction log end point: 115/92364940Read more