Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,690
questions
16
votes
1
answer
16k
views
mariadb.service start stuck at activating
I just installed the mariadb in my ubuntu 19.10 by sudo apt install mariadb-server mariadb-client after when I am trying to start the server by sudo systemctl start mariadb.service shell get freeze I ...
- 1,733
0
votes
0
answers
27
views
How to handle scaling upto 3k concurrent connections [duplicate]
So here's our use case:
We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database.
Now here's a issue we have 3k ...
0
votes
0
answers
422
views
Undestanding how to connect remotely to a Mysql database
Even if I found many old questions around this topic, I'm still unable to connect to a mysql database remotely.
Beside my own specific issue I'd like to point out what are my doubts, in hope to serve ...
- 1
1
vote
0
answers
92
views
Haproxy 2 domain ssl crt conflit
Haproxy load balancer - I configured 2 different domain SSL certificates and get a conflict. For example I have two domains api.xxx.com and api.yyy.com. If try to get api.xxx.com its showing yyy cert ...
- 390
2
votes
1
answer
2k
views
How do I give a postgres user all privileges to a specific database?
I'm setting up a new database server which I intend to use as a backend for many services. Each of these services generally only care about a single database in the system, so I'd like to isolate the ...
- 121
3
votes
2
answers
3k
views
Use ansible initialize postgresql multiple times
Make this task will work the first time:
- name: Initialize the Database
command: /usr/pgsql-9.6/bin/postgresql96-setup initdb
If run it a second time, will get the error:
fatal: [192.168.0.1]: ...
- 5,638
3
votes
3
answers
18k
views
Proxy for database server/connection?
I am coming from an application development perspective (my day job) and not an infrastructure, or operations, perspective, so if this is a completely inane question, please let me know!
We have ...
0
votes
2
answers
1k
views
Slow initial connection to database (php / mssql)
Our webserver and database server are on a local network and the webserver uses an IP address to connect to the database.
$con = new \PDO('sqlsrv:Server=10.200.2.1\sql2017;Database=dbname, $user, $...
- 1
0
votes
1
answer
46
views
What's a good approach to finding the source application that's attempting to access a database with an incorrect password?
In order to improve our security posture, we changed several dozen internal applications over to using a new username and password to access an AS400 database a few months back.
However, there is some ...
- 111
0
votes
1
answer
2k
views
HAProxy and postgres
My haproxy configuration is as below, in the backend there is pg_autoctl cluster, another VM (bunty4) hosts the monitor and haproxy is installed on it.
global
maxconn 100
defaults
log global
...
- 12.6k
65
votes
6
answers
174k
views
How to rename a MySQL database?
How to rename a MySQL database?
The MySQL online manual has said about the RENAME DATABASE command (this documentation page has been removed by Oracle some time ago):
This statement was added in ...
- 97
0
votes
2
answers
50
views
What database my applications will use if I have a locally installed database beside it's pod running on local Kubernetes?
I have installed mysql on my Ubuntu machine. I also have a locally running Kubernetes and deployed a mysql deployment on Kubernetes and can reach to that using kubectl exec -it mysql-b4769786-5hf4m sh ...
- 31
0
votes
1
answer
434
views
How to upgrade a MariaDB database to utf8mb4_unicode_ci?
I have a Drupal 9.4.8 website a MariaDB database and phpMyAdmin.
My website is already active with data in its 220 MB database.
How to upgrade a MariaDB database to utf8mb4_unicode_ci ?
Here is my ...
- 881
3
votes
2
answers
4k
views
How to find joins performed without indexes?
I run a WordPress website on Mariadb 10.6, and recently I saw an error Joins performed without indexes in Mysqltuner.
Although the number is not very large, Mysqltuner recommends that you keep ...
0
votes
0
answers
489
views
zabbix connection to external database
0
I am trying to setup zabbix with two database , one on localhost and another on diffrent machine.
zabbix server: 192.168.0.100
external database :192.168.0.154
I setup zabbix with localhostdatabaase ...
- 35
0
votes
2
answers
1k
views
How to calculate log per second?
I have a log management system in which the Clickhouse database has been used alongside metrico/qryn, rsyslog on all the servers (Debian 11) send gathered logs from the system and applications to ...
- 21
0
votes
0
answers
162
views
How to expose multiple databases in local network for other applications to connect with them
I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP.
Because I seem to lack conceptual knowledge, I would like to ask a more ...
- 101
3
votes
1
answer
2k
views
mongodb keep looping while trying to sync data
I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server).
My primary mongodb is running 2....
CommunityBot
- 1
0
votes
1
answer
2k
views
.Net SqlClient Data Provider error when comparing keys in powershell DB install
I am trying to install Databases on a new windows 7 machine with powershell code that was meant for windows xp. I have been able to fix most of the problems as I have come across them but I have been ...
CommunityBot
- 1
3
votes
2
answers
5k
views
Transfer database data from xampp on Windows to Ubuntu [closed]
Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
0
votes
1
answer
60
views
does it benefit if split multiple sites into multiple database in shared hosting env?
I have been wondering this for long time
let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query
server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
- 545
0
votes
1
answer
3k
views
AWS RDS Cannot modify database instance due to IAM DB Authentication
I have a MySQL 8.0.13 instance running on AWS RDS. AWS documentation says that MySQL 8.0.* does not support IAM DB Authentication. This seems to be true, however my DB somehow has IAM DB ...
CommunityBot
- 1
3
votes
1
answer
2k
views
Galera cluster - cannot start MariaDB (CentOS7)
I'm trying to install a Galera cluster with 3 mariadb VM's (all of them CentOS 7). I've never done this before, so I was following this guide:
http://tunnelix.com/mariadb-galera-cluster-installation/
...
CommunityBot
- 1
1
vote
2
answers
4k
views
How to "align" a Linux file system with a SSD?
I'm interested in getting a dedicated server with a SSD, probably Corsair Force series CSSD-F120GB2-BRKT.
It'll be an Linux server, most likely running XFS (but I'm open to other alternatives).
...
2
votes
3
answers
1k
views
SQL Server 2008 - Secure remote access
I wish to allow remote access to an SQL Server database from a Microsoft Access database to allow my client to build reports as and when they wish.
I can do this without any issue by opening the ...
- 1,213
0
votes
1
answer
2k
views
Installing MariaDB along with MySQL: Could not find mysqld
I am following the instruction on the MariaDB site here all is fine until I get to the part shown below.
[root@squir scripts]# mysql_install_db --defaults-file=/mariadb/data/my.cnf
FATAL ERROR: ...
CommunityBot
- 1
1
vote
0
answers
626
views
Postgresql - Master\Slave Async Replication - How to quickly fail back and forth?
I have two hosts set up as very simple master\slave. All servers connect to the floating IP 10.1.1.10.
Host A:
Designation: Master
Floating IP - 10.1.1.10
Standard IP - 10.1.1.11
relevant pg_hba....
4
votes
2
answers
774
views
How to upgrade to MySQL 8.0?
I have a Drupal site 8.6.10 on an Ubuntu server 18.04 with MySQL 5.7.25
I want to update MySQL to version 8.0
Here are the steps I followed :
1) I backed up my database.
2) I uninstalled MySQL ...
- 101
2
votes
1
answer
299
views
How to install cbexport and cbimport on a standalone linux vm to connect to remote couchbase server
I need to use cbexport to export buckets in couchbase and place it in S3. Although I have the credentials to access couchbase I cannot login to the vm on which it is running. So I cannot use the ...
- 138
2
votes
1
answer
856
views
Azure SQL Elastic Pool: increase data size max GB with no downtime
We have an Azure SQL elastic pool with a data size max GB setting. We would like to increase this setting to a larger value.
The question is: can you increase the size of the elastic pool max size ...
- 381
4
votes
2
answers
12k
views
Fatal error: mysql.user table is damaged. Please run mysql_upgrade
I resized an Azure VM and now the MySQL DB running in Windows inside the VM is dead. I am seeing the below fatal error on startup. I tried to run mysql_upgrade as it suggests but that just errors ...
- 113
0
votes
2
answers
3k
views
Azure Sql Database stuck "Restoring"
I aborted the restore of an Azure Sql database over 2 weeks ago. While no longer visible in the Azure Portal it continues to appear in the list of database In Sql Server Management Studio. "(...
CommunityBot
- 1
0
votes
0
answers
1k
views
ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (10060)
I've tried to look for a solution and there are many similar questions but somehow none of the solutions are working.
I have a laravel app running on one of my ubuntu servers at 1.2.3.4 IP. I ...
- 1
1
vote
1
answer
2k
views
Postgres stopping on Windows
I have a Postgres 9.2 running on Windows 7 as a service.
Every day the database seems to stop and sometimes it start to run again alone and sometimes I need to restart the service.
There is no much ...
CommunityBot
- 1
2
votes
1
answer
2k
views
How can I restart a server and connect it to an existing cluster?
I have three Nginx servers + php7 + memcache + Cluster Galera + Mariadb + Monit.
Everything works and all three are connected.
But if I now want to edit the my.cnf file to play the utilized RAM or ...
CommunityBot
- 1
-1
votes
1
answer
3k
views
Mysql is not starting in UBUNTU 20.4
Mysql fails to start in UBUNTU 20.4. i have no idea what the issue is. Almost i tried everything. nothing worked.
sudo journalctl -u mysql.service -n 100
------------------------------------------
...
0
votes
1
answer
3k
views
Adminer or mysql error: no connection could be made because the target machine actively refused it
I have been trying to set up wordpress.org using localbyflywheel, but when I open Adminer I keep getting this error: No connection could be made because the target machine actively refused it, what ...
CommunityBot
- 1
0
votes
1
answer
2k
views
MariaDB event scheduler not starting after migrating MySQL to MariaDB. Ignoring config file
I've my upgraded my system from Debian 8 to Debian 9.
MySQL Version on Debian 8 (before upgrade) - 5.5.58-0+deb8u1-log (Debian)
MariaDB version on Debian 9 (after upgrade): 10.1.26-MariaDB-0+deb9u1 ...
CommunityBot
- 1
1
vote
2
answers
452
views
Connect Access 2016 to remote SQL Server - SQL Server Error 17
Good morning,
I am trying to connect to a SQL server from a remote machine, with ACCESS 2016, using the "External data" option. Both are on the same network.
It is important to note that I ...
- 854
40
votes
6
answers
20k
views
Mysql: Working With 192 Trillion Records... (Yes, 192 Trillion)
Here's the question...
Considering 192 trillion records, what should my considerations be?
My main concern is speed.
Here's the table...
CREATE TABLE `ref` (
`id` INTEGER(13) AUTO_INCREMENT ...
- 30.2k
0
votes
1
answer
2k
views
Ubuntu automysqlbackup configure to have separate databases in one folder with gzip
I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine.
I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the ...
CommunityBot
- 1
-1
votes
1
answer
90
views
Unable to get subdomain to connect to MariaDB
So far I can reach the DB from the main domain lets say example.com but connection from the subdomain lets say portal.example.com, don't work. I am currently running Nginx & Varnish & Apache ...
- 1
0
votes
1
answer
427
views
mysql crashes when accessing database after upgrade from 5.5 to 5.7
After upgrading mysql from 5.5 to 5.7, one of innodb databases seems corrupted.
mysqldump -u root -p mydatabase > mydatabase.sql Enter password:
mysqldump: Error: 'Lost connection to MySQL server ...
- 2,001
0
votes
1
answer
424
views
Minimise client side connection to multi-tenant Postgres databases
My employer currently have multiple Postgres instances (one per customer, having a unique site code) which are physically separated on customer premises. Each customer has 1-4 databases running inside ...
- 32.8k
1
vote
0
answers
1k
views
Can I recover a db password?
For our project in GCP, the app has a production Postgres db instance, we don't have the current password, therefore we can't access the db other than through the app. If we change the password, then ...
google-cloud-platform
0
votes
1
answer
132
views
Receving 502 Bad Gateway when trying to access via URL
Unable to access my VM using SSH and receiving 502 Bad Gateway when trying to access via URL.
Get below error :
{"@type":"type.googleapis.com/cloud_integrity.IntegrityEvent", "...
0
votes
1
answer
508
views
Can I use an UNC path on remote MSSQL server in a store procedure to access remote file?
I have a store procedure on a remote MSSQL server. It has bulk insert from a file.That file is on another server. The file is shared on Ubuntu via Samba.
Can that store procedure access my file? What ...
- 3,044
-1
votes
1
answer
178
views
Regarding how Big companies set up their databases [closed]
I am trying to understand how do companies which handle a large database requests set up their infrastructure. I have recently created a few python applications which store data in PostGres and ...
- 686
4
votes
1
answer
19k
views
Not able to backup of postgres DB from DBeaver
Hope you are doing great.
We have postgres install on centos server and accessing it through DBeaver from Ubuntu machine.
Whenever we try to take backup of Database it is giving error as "Native ...
- 3,125
0
votes
1
answer
792
views
Why my simple searching query is too slow?
I don't know why searching in my "cities" table is so slow.
My query looking for a table "cities" located about 25km from the city.
I use this simple query and the database takes ...
- 725