Questions tagged [multi-database]
120 questions
0
votes
1 answer
Laravel pass big data through a view, load time slow
I need to pass quite a big amount of data through the view in Laravel and it seems to take quite a look, can someone advice about the correct way to improve this code/ pass this amount of data through a view?
from my PC the loading of this page is…
Seba
- 617
- 1
- 8
- 33
0
votes
1 answer
What design pattern should be used to connect to one of multiple database instances with exactly same schema and a parent/master db?
I am designing code for a new project. There would be many client specific databases with EXACTLY same schema. These databases would store employee of the respective client orgnization.And there would be a MASTER database which will store db…
Rajeev
- 1
- 1
0
votes
2 answers
Dynamic database connection using Asp.Net identity
I am working on a multi-tenant application that uses multiple databases. There is one master database that contains user information and then each tenant database also has their own users for that tenant (which are a subset of the users in the…
WebFletch
- 172
- 1
- 16
0
votes
2 answers
Multiple database laravel
How to show the value from other database in a view? i am using multi database.
My Controller :
public function index()
{
$oil = DB::connection('mysql2')->table('oils')->select('oil_price')->get();
$this->oil = [
…
Rezza Pratama
- 7
- 1
- 7
0
votes
1 answer
Add, Delete, Update to multiple database by subclassing django.db.models.Model in django
I want to write to add, update delete to multiple database by using django.db.models.Model
I am able to add to multiple database by setting up multi-db in settings.py
So setting file look like
DATABASES = {
'default': {
'ENGINE':…
Alok
- 7,734
- 8
- 55
- 100
0
votes
1 answer
How to manage schema changes on many identical schema-based databases with mysql?
I'm developping a web platform to manage student registrations in schools of my region. For that I have 17 databases running on MySQL (5.7.19) where there is one which is the main database and the 16 others represent schools. Schools databases…
Harrys Crosswell
- 1
- 1
0
votes
0 answers
springboot mybatis multi datasource
For config tow datasource, I config tow MapperScannerConfigurer in my .xml:
qi lu
- 21
- 1
0
votes
0 answers
Spring Boot pooling database connection with multipledatabase
I'm trying to configure a multi database applications with pool of connections.
I've denifed datasource beans in my application.properties:
# Topology and Configuration…
Pedro Ramírez Pérez
- 113
- 4
- 15
0
votes
1 answer
springboot2.0 integrate hikariCP2.7.9, throws "Default transaction isolation level detection failed (Proxy Warning - near ".": syntax error)."
HikariCP version: 2.7.9
JDK version : 1.8.0_111
Database : MySQL
Exception:
HikariPool-1 - Exception during pool initialization.
2018-06-28 21:09:36.545 WARN 35084 --- [nio-8008-exec-2] c.z.h.p.PoolBase : HikariPool-1 - Default…
michael
- 1
- 1
0
votes
2 answers
Travis: how to run tests against different MySQL backends?
How to run tests against different MySQL backends, using one .travis.yml file?
Something like here, using matrix->include. For instance:
Run tests against MySQL 5.5
Run tests against MySQL 5.6
Run tests against MySQL 5.7
Run tests against MySQL…
k00ni
- 315
- 4
- 17
0
votes
1 answer
Multi database in the same method
My app has 2 databases, Db1 (has table dbo.Student) and Db2 (has table dbo.School). I created 2 AppService to access them
When I tried to get data from both of them, It only uses the connection to Db1 (Could not found table dbo.School in the current…
Hoang Tran
- 886
- 3
- 13
- 32
0
votes
1 answer
Transaction inside transaction support? (multi database) in Spring boot
I have DB1, DB2. I config two DataSource and two PlatformTransactionManager for two database (within the same physical machine).
I have this code:
@Transaction("DB1")
public void A() {
B();
}
@Transaction("DB2")
public void B() {
}
When B() has…
0
votes
0 answers
Better pratice in Entity Framework multi database applications
I am a beginner in C# programimg and I am looking for a way to make some generics to better work with Entity Framework using multiple databases.
My application was built using only Oracle Database, using all the entities inside my application. Now…
Lucas Neves
- 59
- 1
- 5
0
votes
3 answers
Multiple databases in Laravel PHP
We are building a multi-tenant application. Through the admin interface, we will add new tenant as and when required. This application needs to work with 1+n database.
1 Main DB with about 5 tables.
n DBs for each tenant that we create. The tenant…
Simran Kahlon
- 9
- 1
- 3
0
votes
1 answer
Drupal : Single-code, Multi-site, multi-domain, multi-database. HOW?
There are many tutorial on how to setup Drupal in different configuaration, but I can't find how to setup Multi-site, multi-domain, multi-database config with nginx and postgresql.
So far I was able to set :
Nginx virtual hosts (also set…
sten
- 7,028
- 9
- 41
- 63