Questions tagged [multi-database]
120 questions
1
vote
2 answers
Large WordPress database
My database size is more than 10GB and it slow down the website. I want to split it and separate these DBs to dedicated servers. I'm using MariaDB.
How can I split the WordPress database?
Feriman
- 503
- 8
- 17
1
vote
1 answer
Django multi-database, one model
In my Django project, I would like two databases but only one model.
For example, an expert database and an exploit database. The router allows me to write in the exploit database or the expert database according to the users groups and…
djangoliv
- 1,698
- 14
- 26
1
vote
1 answer
Orchestral/tenanti multi database
I build an application for many tenants and each tenant has it's own database. The name of the database is the same as the tenants id.(the id exists out of five numbers). After authentication the user should be connected with his own database and…
Novy
- 334
- 2
- 4
- 11
1
vote
2 answers
Database connection too much with ActiveRecord::Base.establish_connection
I use multible databases with ActiveRecord. I must put establish_connection db in all models. But i want to call the connection of libraries file. While put establish_connection db in for all models Database connection count is too much . How can I…
sozgur
- 21
- 4
1
vote
1 answer
How to always use a specific DB connection for certain django model?
I will add a procedure to a django app where I need to store data but only for a few hours, also I don't wat to add another table to my db schema (which is kind of big), I'm thinking to use redis for the task, in the end what I want to achieve is to…
zzantares
- 341
- 3
- 12
1
vote
2 answers
Can LINQ To SQL used for other database (MySQl, Oracle, etc)
I have project creating with WPF and for database O/RM using LINQ to SQL, when i finish my project some people want to use MySQL as database, so can I change my Linq to MySQL without change any source code (maybe just change the connection…
Gus Leo
- 67
- 3
1
vote
0 answers
Model.add() in multiple database configuration
The related manager has a method called add that, "Adds the specified model objects to the related object set."
For example, you can do:
b = Blog.objects.get(id=1)
e = Entry.objects.get(id=234)
b.entry_set.add(e) # Associates Entry e with Blog…
mlissner
- 17,359
- 18
- 106
- 169
1
vote
1 answer
Entity Framework with mutliple database servers
Today we're developing a solution for Windows environments with SQL Server CE and Entity Framework 6.13 as ORM (Code First). However we're studying the availability to port it to Linux environments and, of course, as Linux doesn't support SQL Server…
tgmoura
- 70
- 10
1
vote
1 answer
django multi db change db of intern models
With multidb routers, how to move all django_* tables (models) to another db than default (moving also the django_migrations table) ?
By "move", I accept to simply put them in another db initially
EDIT : Ok, it seems that django_migration can't be…
hl037_
- 3,520
- 1
- 27
- 58
1
vote
0 answers
Django Multi-Database support
NB: I have already gone through the Django official documentation here docs.djangoproject.com/en/dev/topics/db/multi-db, but nothing on the page answers my questions.
I have led a team to develop two Django web applications and we have reached a…
AJNinja
- 140
- 1
- 15
1
vote
0 answers
Spring Boot equivalent to XML multi-database configuration
I would like to port two projects to Spring Boot 1.1.6. The are each part of a larger project. They both need to make SQL connections to 1 of 7 production databases per web request based region. One of them persists configuration setting to a Mongo…
jamesbehrens
- 11
- 3
1
vote
0 answers
SAAS Multitenant app + connect different database issue
I'm developing a SAAS application using Laravel. I have one master database and multiple tenant databases. As I am a admin, i want to check tenants performance and tenant details. For Ex. Basecamp. I want to check how many accounts created in tenant…
Kalaivanan Muthusamy
- 129
- 1
- 12
1
vote
2 answers
Django - synchronising data between multiple databases
On a multi-database environment, how to move all data from a database to another?
Settings looks like this:
DATABASES = {
'default': {},
'users': {
'NAME': 'user_data',
'ENGINE': 'django.db.backends.sqlite3',
'USER':…
kdani
- 847
- 7
- 20
1
vote
2 answers
Linq to Sql: Select only items from DB1-table1 that don't exist on DB2-table2
I'have been working around on how to properly implement the bellow task in a c# project.
It is pretendended to ...
Get all data that exists in a particular database's table(db1) but that does NOT EXISTS on another particular database's table…
Lothre1
- 3,523
- 7
- 43
- 64
0
votes
0 answers
How do I switch from 1 database to 1 database per subdomain rails
I have a multi-tenancy app where everything is stored in 1 Postgres database. All models have a account_id, so the data a customer can see is based on his account_id. This works perfect, but due to security and privacy concerns, customers demand…
suhel rana
- 1
- 1