Explore Percona on Experts Exchange

Expert Solutions for Your Tech Problems

Percona

Percona is the only company that delivers enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB...

Read more
  • 79 Content
  • 26 Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Leading Experts In
Percona
<
Monthly
>
Research Question

How to upgrade Mariadb 10.0.x

26

hi,


I am now check how to upgrade a MariaDB version by 2 case:

1) on a local MariadB

2) on a newly

Research Question

latest MySQL, mariaDB and percona PXC trend and configuration.

12

Hi,


I haven't use MySQL for almost 5 years and I'd like to catch up with the latest version and I

Research Question

use xtrabackup to backup data from Percona xtraDB cluster  5.7.23 to 8.0.19

3
hi,

is it say that  xtrabackup can't backup data from Percona xtraDB cluster  5.7.23 to 8.0.19?

Research Question
Research Question

optimizing ProxySQL for MySQL and HA and DR of ProxySQL

6
hi,

Any easy to understand guide on how to optimize the throughput of ProxySQL between MySQL client …
Research Question

how to use percona xtrabackup to backup DB

14
hi,

I am reading this:
Troubleshooting Question

how to backup ProxySQL username and password from an old version to latest edition

4
hi,

we are setting now up proxysQL for percona xtraDB cluster 8.0.19, how to backup ProxySQL v 1.xx …
Research Question

pre migration check from Percona XtraDB cluster 5.7.x to Percona XtraDB cluster 8.0.19

2
hi,
I have done the first phrase of Percona XtraDB cluster 5.7.x to Percona XtraDB cluster 8.0.19 …
Troubleshooting Question

when restoring/script out a function from percona xtraDB cluster 5.7.x to 8.0.19 it shows error

hi

when restoring/script out a function from percona xtraDB cluster 5.7.x to 8.0.19, the function is


Research Question

the Percona XtradB Cluster migration plan.

3
hi,

right now how I plan the percona XtraDB migration from 5.7. x to 8.0.19 is :

1) backup table …
Research Question

use rsync to migrate data from percona xtraDB cluster 5.7.x to percona xtraDB cluster 8.0.19

5
hi,

right now I have only 2 x big big MySQL tables to import from myql dump file and it is the …
Troubleshooting Question

for mysql data dump too large to import

9
hi,

right now I have only 2 x big big MySQL tables to import from myql dump file and it is the …
Research Question

how to change from MyISAM database to InnoDB cluster DB

6
Hi,

What is the way to convert the a MyISM mysql database to InnoDB without losing data ?

 can we …
Troubleshooting Question

MySQL collatoin

1
hi,

we are migrating Percona xtraDB cluster 5.7.x to Percona xtraDB cluster  8.0.19, and we want to …
Troubleshooting Question

mysqldump to another mount drive

27
hi,

I am not a linux guy and when I do df -h I see this:

Filesystem            Size  Used Avail Use% …
Research Question

how to create a linux account which can start and stop mysql so that to secure percona mysql

5
hi,

I am having a task on securing linux and mysql so that, and

1) we have to create an account call …
Troubleshooting Question

Percona xtraDB cluster 5.7 and 8.0.19  collation

hi,

as we are doing percona xtraDB cluster 5.7x to 8.0.19 migration, and we use mysqldump to export …
Troubleshooting Question

extend the timeout of putty when doing mysql restore

51
hi,

I keep finding my putty session keep timing out and drop off, and I can't see the error message …
Troubleshooting Question

exporting MySQL username and password using mysqldump in percona xtradB 8.0.19

4
hi,

I am told to use

mysqldump  -u root -p mysql user >user_table_dump.sql

to export all users in …
Research Question

global variable to use in percona XtraDB cluster 8.0.19

4
hi,

we are using percona xtraDB cluster 5.7 and will migrate to 8.0.19, the following is using in …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more