Questions tagged [Database administration] (247)

1
answer

99%, automatic replication PostgreSQL/MySQL?

Saw that there are 2 types of replication: Master-Master and Master-Slave. Here and there I had a permanent human presence. For example. In Master-Slave went to the Master and Slave becomes Master, but he himself does not realize that it's time to become Master? And when the old Master will arise, he will not realize that h...
consuelo.Prohaska asked April 19th 20 at 11:53
2
answers

How to assign unique IDs to existing strings?

There is a table my_table and the column id. It is already filled with rows and all row id=0. I unikalizirovat all id by assigning a value of 1, 2, 3... and so on?
piper.Legros asked April 18th 20 at 12:59
1
answer

Which replication in Postgres is better?

Friends gave the idea that Postgres there is automatic switching masters (a La the cluster mode) in contrast to mysql (where you have to put either the Orchestrator, or the galley) The question is-what type of replication is necessary in Postgres for automatic switching of the masters? Or in a "cluster" mode, if in Genera...
jane.Keeling asked April 18th 20 at 12:31
1
answer

How to make the merger of the three sqlite tables?

There are 3 tables that have same columns. How to combine these tables into one? But it is worth considering that there is a primary key - id. They need to be drained and, as I understand it, reassign all records new id. Also interested in the possibility of validating the data. For example: Each table has a column name. I...
Brandt_Pollich82 asked April 16th 20 at 10:02
1
answer

Why may fall the connection of MySQL with large number of concurrent connections?

Hello. There are two VPS servers, VPS conventionally-1 (Central) and VPS-N (worker). The worker has 120+ php-worker s continuously connected with the MySQL Database on the Central server. To interact with the database used by Doctrine ORM (Symfony). From time to time the process is falling with error: PHP Fatal error: Un...
eugene.Collier asked April 7th 20 at 10:09
1
answer

What tools are there in postgres to divide resources between users?

Good day, there are common installations (one installation and many different database with projects) c HA postgres (master-slave-slave repmgr) I would like to know is it possible to create limits on the use of cluster resources for a separate database/user. Now for control: 1) drive: each database is a separate lvm with it...
salm asked April 4th 20 at 14:12
2
answers

How to make a verification of the content of 2 MySQL databases?

MySQL database is in state A. I did something on the site, and any of the added/changed/retired, ie, the base was in a state B. Tell me, are there any tools that can compare these 2 States, and show their differences?
norval12 asked April 4th 20 at 13:31
2
answers

How to determine in early stages in PostgreSQL something beginning to fail?

Good day! Tell me, please, are there any methods of checking the database and the Postgres errors? Something like a self-test of the DB server? In particular, are faced with a situation when the problems started with the service table and I noticed it only when I get an error on the next backup. The problem was that started...
frederique_Kiehn asked April 4th 20 at 13:29
0
answer

How to organize backup mongodb?

Hi all. Mongodb has a 3.6 you need times a day bekapit and upload to remote server. Previously with mongodump, but after growth and constant increase of load this option is not acceptable because almost tightly locks the database. How can we have a quick backup which minimally inhibits the database? Preferably the implemen...
Ewell62 asked April 4th 20 at 13:14
2
answers

How to migrate postgres DB to another server?

Actually, a subject. There is a dump made using pg_dump. There are two questions: 1) In off the dock it is written:psql dbname < infile The database dbname will not be created by this command, so you must create it yourself from template0 before executing psql (e.g., with createdb -T template0 dbname). I.e., the databas...
zander asked April 4th 20 at 13:07