Questions tagged [Percona] (59)

2
answers

Whether to move to Percona server with MariaDB/MySQL?

Good day! On the centos7 server turns a couple of small projects on mariadb 5.5.60-1.el7_5. Up for: 109d 21h 37m 7s (1B q [176.802 qps], 36M conn, TX: 7257G, RX: 139G) Reads / Writes: 99% / 1% Physical Memory : 3.7 G Data in MyISAM tables: 343.9 M (Tables: 19) Data in InnoDB tables: 1.6 G (Tables: 620) Everything seems to...
eleonore asked April 8th 20 at 10:36
5
answers

All MariaDB better than MySQL? Or MySQL has some advantages?

Does it make sense today to use MySQL 8.0 ? Is there any unique feature of MySQL, which in some cases it is better to use MySQL and not MariaDB, Percona or MongoDB? PS. MongoDB accidentally hit this list.
aurelio.Gusikows asked April 2nd 20 at 15:22
1
answer

How to set maxscale for multi-master cluster?

Good afternoon. Need help. There is a cluster mysql percona master-master (3 replicas). Need it set a maxscale. Maxscale config:[maxscale] threads=auto [db1] type=server address=172.31.6.70 port=3306 protocol=MariaDBBackend [db2] type=server address=172.31.6.252 port=3306 protocol=MariaDBBackend [db3] type=server addres...
Darryl_Kunde asked March 31st 20 at 21:53
0
answer

How to restore backup for MySQL cluster(Percona Xtradb Cluster)?

There is a PXC cluster composed of 5 nodes. How you can create backups and restore them? Innobackupex is not suitable, because it is not possible to restore individual databases. Accordingly, one gets an algorithm backup: 1) Desychronization (wsrep_desync) one of the node cluster 2) use mysqldump to create a backup on this ...
Darrin_Wisozk15 asked March 29th 20 at 23:46
1
answer

An exception occurred in driver: SQLSTATE[HY000] [2002] Connection refused?

Hello! Strength, no, the second time faced with a similar problem. Earlier it was solved, connecting to the container. Create a new user. But now nothing helps! At the moment I can connect to the container like this: mysql-uroot -ppkRkEzUDdqOEFXL1pmNkcyQ2RL .envDB_DRIVER=pdo_mysql DB_HOST=127.0.0.1 #or localhost DB_PORT=330...
Or asked March 29th 20 at 21:44
1
answer

How to organize a hot-swappable bases for requests for exclusive access?

Good afternoon. Now I need to design a service with a fairly high resiliency, and the question arose how to work with the database. The service has data that must be protected against simultaneous editing (for example the account of virtual money in an online game should not be allowed to be with him at the same time wrote ...
Pearline_Ter asked March 21st 20 at 11:49
1
answer

How to load a database dump in Mysql Percona?

Made a dump Percona. Version 5.7.16-10-log - Percona Server (GPL). Trying to load on a normal Mysql server 5.7.17. The loader hangs, the process does not go further. There are some peculiarities of percona? Tables are normal innoDB. UPD. Did a dump using mysqldump in sql format. Via ssh try to download. Swears on a line (11...
alice29 asked March 17th 20 at 11:14
0
answer

Percona/Galera — 110 error WSREP — in what direction to dig?

The cluster on >10 servers, evenly distributed between DTS loaded system. In the logs often seen: WSREP: Failed to report last committed XXXX, -110 (Connection timed out) Omitting the periodic SST/IST (driven, in service) - which way to dig to come to improve stability? The cluster is running, the systems operate - that...
don asked March 16th 20 at 14:02
1
answer

MySQL (Percona Cluster XtreDB) — how to rotate logs?

Actually, a subject. Debian OS 9 I would like when reaching /var/log/mysqld.log for example, 100mbсоздавать new and the old push in gz and just to keep 10 files. In principle, you should get something like /var/mysql/mysqld.log { compress create 660 mysql mysql size 100M missingok notifempty rotate 10 } But surely som...
Jewel_Powlowski asked March 12th 20 at 15:31
2
answers

Synchronous replication: MySQL NDB Cluster, Percona XtraDB, MariaDB, Galera, mysql group replication (innodb, cluster). What's the difference?

There are 3 identical SSD VPS in different data centers in Moscow, ping between 5ms to Need synchronous replication to have at least 2 copies of data. Need to survive the fall 1 server from 3, if 2 servers crashed - read-only mode. To read and write will be only one server. In order to accelerate the write speed, preferably...
Rosie asked March 11th 20 at 21:24