Partitioning transaction table in AWS RDS Database (Managed Service) MYSQL table without downtime
1 Like
Hello @seebhoopi,
Do you have a specific question to ask? Can you tell us what you have tried so far? Have you looked at pt-online-schema-change?
1 Like
We are using RDS DB (Managed Service). We don’t have EC2 Instance, how to install Percona and use your tool? I read a couple of articles that Percona provides a UI which has to be configured in the AWS Console. Since our DB is used for payment, we can’t expose any public endpoint for connectivity. In our use case how i can use Percona?
1 Like
Hello @seebhoopi,
You can create a temporary EC2 instance and run pt-online-schema-change there. Point the tool to your RDS instance.
Where did you see this? The only UI we have is PMM which is used for monitoring, not for doing schema changes.
1 Like
Please let me know your input on this issue?
bhoopathi@it-Latitude-3510:~$ sudo apt --fix-broken install
Reading package lists… Done
Building dependency tree
Reading state information… Done
Correcting dependencies… Done
The following additional packages will be installed:
mysql-server-core-8.0
The following NEW packages will be installed:
mysql-server-core-8.0
0 upgraded, 1 newly installed, 0 to remove and 11 not upgraded.
2 not fully installed or removed.
Need to get 0 B/18.4 MB of archives.
After this operation, 136 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
(Reading database … 196956 files and directories currently installed.)
Preparing to unpack …/mysql-server-core-8.0_8.0.27-0ubuntu0.20.04.1_amd64.deb …
Unpacking mysql-server-core-8.0 (8.0.27-0ubuntu0.20.04.1) …
dpkg: error processing archive /var/cache/apt/archives/mysql-server-core-8.0_8.0.27-0ubuntu0.20.04.1_amd64.deb (–unpack):
trying to overwrite ‘/usr/share/mysql/bulgarian/errmsg.sys’, which is also in package percona-server-common 8.0.26-16-1.focal
dpkg-deb: error: paste subprocess was killed by signal (Broken pipe)
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-core-8.0_8.0.27-0ubuntu0.20.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
1 Like
Looks like you are trying to install mysql-server-core-8.0 package but you already have percona-server-common installed.
1 Like