Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: distributed-databases

Multi master mysql with automerge data if node disconnected

By adminPosted on January 30, 2023

Question : I have final project for my course about distributed system, so here the case : A company need […]

MySQL Replication after a set period of time

By adminPosted on December 27, 2022

Question : I have a question about MySQL replication: can I set the slave DBs to only poll the master […]

What are alternatives to Replication to distibute data (Microsoft SQL Server)

By adminPosted on December 15, 2022

Question : Is anyone knowledgeable of alternatives to SQL Server replication? I have a scenario where separate databases will share […]

generate unique primary key for all clients from the local database and NOT the server

By adminPosted on November 25, 2022

Question : I’m using MySQL Innodb database to work as a distributed database among many places and also each place […]

Alternatives for Dblink in oracle?

By adminPosted on November 1, 2022

Question : we have an SSIS job that inserts data into a table in server A from data in table […]

Distribute MySQL in different cities?

By adminPosted on October 26, 2022

Question : We have our main MySQL server in city A. We have the bulk of our customer service staff […]

Distributed database implementation in sql server

By adminPosted on September 2, 2022

Question : Currently, We have central Database at Head Office and users from sub offices ,scattered around the country, connect […]

Why can’t we perform joins in a distributed database like Bigtable?

By adminPosted on August 31, 2022

Question : From this answer to “What database does Google use?”: Bigtable is not a relational database. It does not […]

Model for Distributed Database [closed]

By adminPosted on August 19, 2022

Question : It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or […]

Database structure for a customer shopkeeper website

By adminPosted on June 21, 2022

Question : I am working on a project in which there will be two spaces for the customer and the […]

  • 1
  • 2
  • 3

Recent Posts

  • How to pass a parameter into a subquery in a join statement [closed]
  • Replicate a database with a subset of data offered by custom queries [closed]
  • Are there any benefits in certain ordering of columns when defining indexes
  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding