# Polyglot Projects **URL:** https://forums.percona.com/c/polyglot-projects/26.md?page=5 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 6 --- ## [Percona Toolkit with Percona XtraDB Cluster on Kubernetes](https://forums.percona.com/t/percona-toolkit-with-percona-xtradb-cluster-on-kubernetes/22178)
**Author:** [@Philipp\_Malkmus](https://forums.percona.com/u/Philipp_Malkmus)\ **Replies:** 1\ **Last updated:** [May 19, 2023, 4:29pm UTC](https://forums.percona.com/t/percona-toolkit-with-percona-xtradb-cluster-on-kubernetes/22178 "2023-05-19T16:29:35Z")
I am running the Percona XtraDB Cluster with the Percona Operator For MySQL on Kubernetes. Since for altering tables I need to use pt-online-schema-change I need to use the toolkit. How do I use or install the toolkit … --- ## [Skip-check-slave-lag is not working for pt-online-schema-change](https://forums.percona.com/t/skip-check-slave-lag-is-not-working-for-pt-online-schema-change/22060)
**Author:** [@izavadinskiy](https://forums.percona.com/u/izavadinskiy)\ **Replies:** 2\ **Last updated:** [May 15, 2023, 11:08am UTC](https://forums.percona.com/t/skip-check-slave-lag-is-not-working-for-pt-online-schema-change/22060 "2023-05-15T11:08:46Z")
Hi. Guys, I am trying to use pt-online-schema-change for changing table structure to utf8mb4. Faced with the issue when pt-online-schema-change showing the exception about “Cannot connect to h=10.3.15.0,p=…,u=” (slave … --- ## [Pt-osc running on standby breaks replication](https://forums.percona.com/t/pt-osc-running-on-standby-breaks-replication/21665)
**Author:** [@Sukan\_M1](https://forums.percona.com/u/Sukan_M1)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 4:02am UTC](https://forums.percona.com/t/pt-osc-running-on-standby-breaks-replication/21665 "2023-04-27T04:02:37Z")
There is a dedicated standby where we are doing schema changes like index addition, defragmentation before switching that as a master. Q1 : When running pt-osc with replication, it fails with 1032 upon completion. If we… --- ## [How to translate SQL to pt-online-schema-change CLI format?](https://forums.percona.com/t/how-to-translate-sql-to-pt-online-schema-change-cli-format/21524)
**Author:** [@Victor\_Munoz](https://forums.percona.com/u/Victor_Munoz)\ **Replies:** 2\ **Last updated:** [April 27, 2023, 8:38am UTC](https://forums.percona.com/t/how-to-translate-sql-to-pt-online-schema-change-cli-format/21524 "2023-04-27T08:38:31Z")
Hi all, I’m looking for an automate way to run pt-online-schema-change tool, and I don’t know if there is any tool, plugin, … that provides translation/conversion from SQL statements to pt-online-schema-change CLI forma… --- ## [Percona-tookit Supported distributions?](https://forums.percona.com/t/percona-tookit-supported-distributions/21539)
**Author:** [@dkang](https://forums.percona.com/u/dkang)\ **Replies:** 2\ **Last updated:** [April 21, 2023, 9:59pm UTC](https://forums.percona.com/t/percona-tookit-supported-distributions/21539 "2023-04-21T21:59:12Z")
Hi, which mysql distributions percona-toolkit support? I am specifically interested in if xtrabackup pt-online-schema-change pt-query supports oracle mysql percona myrocks facebook myrocks Is there a doc page for … --- ## [Contributing to proxysql admin tool](https://forums.percona.com/t/contributing-to-proxysql-admin-tool/21559)
**Author:** [@Anand\_Siva](https://forums.percona.com/u/Anand_Siva)\ **Replies:** 0\ **Last updated:** [April 21, 2023, 2:22pm UTC](https://forums.percona.com/t/contributing-to-proxysql-admin-tool/21559 "2023-04-21T14:22:48Z")
Hey! I am a big fan of what you are doing here with the proxysql and supporting the PXC cluster. I was looking for the contribute.md file for the following repo: I have some thoughts on how to incorporate async repli… --- ## [Proxysql 2.4.8 failure on RHEL 8.6](https://forums.percona.com/t/proxysql-2-4-8-failure-on-rhel-8-6/21409)
**Author:** [@Chanakya](https://forums.percona.com/u/Chanakya)\ **Replies:** 7\ **Last updated:** [April 18, 2023, 8:54am UTC](https://forums.percona.com/t/proxysql-2-4-8-failure-on-rhel-8-6/21409 "2023-04-18T08:54:43Z")
Hi, We are trying to run Proxysql on RHEL 8.6 using generic packages from percona.(proxysql-2.4.8-Linux-x86\_64.glibc2.27.tar). We are getting following error when trying to start: libgnutls.so.30.14.10: undefined symb… --- ## [ProxySQL hostgroup 10 and 11 - favouring 10 for reads/writes (XtraDB Cluster Operator)](https://forums.percona.com/t/proxysql-hostgroup-10-and-11-favouring-10-for-reads-writes-xtradb-cluster-operator/20529)
**Author:** [@voarsh](https://forums.percona.com/u/voarsh)\ **Replies:** 7\ **Last updated:** [April 17, 2023, 2:49pm UTC](https://forums.percona.com/t/proxysql-hostgroup-10-and-11-favouring-10-for-reads-writes-xtradb-cluster-operator/20529 "2023-04-17T14:49:13Z")
Using the Percona XtraDB Cluster Operator and looking at PMM, hostgroup 10 (writer) seems to be getting pretty much all questions/queries, with minimal/almost none going to 11 (reader). Hostgroup 11: Hostgroup 10 … --- ## [ProxySQL 2.5.1 and ProxySQL Admin Tools Released](https://forums.percona.com/t/proxysql-2-5-1-and-proxysql-admin-tools-released/21440)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [April 17, 2023, 12:10pm UTC](https://forums.percona.com/t/proxysql-2-5-1-and-proxysql-admin-tools-released/21440 "2023-04-17T12:10:44Z")
April 17, 2023 - Find release notes at ProxySQL 2.5.1 and ProxySQL admin tools (2023-04-17) - Percona ProxySQL admin tools --- ## [Encrypt Proxysql Admin password in config file](https://forums.percona.com/t/encrypt-proxysql-admin-password-in-config-file/21422)
**Author:** [@Chanakya](https://forums.percona.com/u/Chanakya)\ **Replies:** 3\ **Last updated:** [April 17, 2023, 9:45am UTC](https://forums.percona.com/t/encrypt-proxysql-admin-password-in-config-file/21422 "2023-04-17T09:45:21Z")
Hi, I would like to know if there are any workaround ways to encrypt admin and cluster plain text password in the proxysql config file. Thank you Chanakya --- ## [ProxySQL and replication threads error](https://forums.percona.com/t/proxysql-and-replication-threads-error/21166)
**Author:** [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Replies:** 1\ **Last updated:** [April 4, 2023, 3:16pm UTC](https://forums.percona.com/t/proxysql-and-replication-threads-error/21166 "2023-04-04T15:16:44Z")
Hello. I use proxysql 2.4.4 2 backend servers one of backend with max\_replication\_lag option It works ok , but if we have replication error - proxysql think that backend is ok and no replication lag and send queries t… --- ## [Running pt-table-checksum before pt-table-sync?](https://forums.percona.com/t/running-pt-table-checksum-before-pt-table-sync/21035)
**Author:** [@Ron](https://forums.percona.com/u/Ron)\ **Replies:** 1\ **Last updated:** [March 30, 2023, 11:13am UTC](https://forums.percona.com/t/running-pt-table-checksum-before-pt-table-sync/21035 "2023-03-30T11:13:08Z")
I’m sure there are many reasons to run pt-table-checksum before pt-table-sync but I don’t know all the reasons. If I know there are inconsistencies between two databases, is it good enough to just run pt-table-sync --pri… --- ## [ProxySQL 2.4.8 and ProxySQL Admin Tools Released](https://forums.percona.com/t/proxysql-2-4-8-and-proxysql-admin-tools-released/20586)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [March 15, 2023, 5:24pm UTC](https://forums.percona.com/t/proxysql-2-4-8-and-proxysql-admin-tools-released/20586 "2023-03-15T17:24:50Z")
March 15, 2023 - Find release notes at ProxySQL 2.4.8 and ProxySQL admin tools (2023-03-15) - Percona ProxySQL admin tools --- ## [ProxySQL and Strict Mode](https://forums.percona.com/t/proxysql-and-strict-mode/20548)
**Author:** [@daa](https://forums.percona.com/u/daa)\ **Replies:** 1\ **Last updated:** [March 14, 2023, 1:40pm UTC](https://forums.percona.com/t/proxysql-and-strict-mode/20548 "2023-03-14T13:40:48Z")
We have a 3-node cluster setup running MySQL 5.7.34-37. We are using ProxySQL 2.4.4-44 to route traffic for the cluster. We recently turned strict mode and innodb strict mode off on all nodes, but we are still seeing s… --- ## [Cannot remove lock file for percona proxy sql scheduler admin](https://forums.percona.com/t/cannot-remove-lock-file-for-percona-proxy-sql-scheduler-admin/20447)
**Author:** [@Anand\_Siva](https://forums.percona.com/u/Anand_Siva)\ **Replies:** 1\ **Last updated:** [March 7, 2023, 3:54pm UTC](https://forums.percona.com/t/cannot-remove-lock-file-for-percona-proxy-sql-scheduler-admin/20447 "2023-03-07T15:54:35Z")
I have followed the directions here to setup percona proxysql-admin-tool with Percona Scheduler Admin. Looks like the cluster and everything got setup properly, but the below message is constantly in my log files for pro… --- ## [Can pt-online-schema-change be run separately to just handle the table swap?](https://forums.percona.com/t/can-pt-online-schema-change-be-run-separately-to-just-handle-the-table-swap/20145)
**Author:** [@cthompson](https://forums.percona.com/u/cthompson)\ **Replies:** 2\ **Last updated:** [February 17, 2023, 1:48am UTC](https://forums.percona.com/t/can-pt-online-schema-change-be-run-separately-to-just-handle-the-table-swap/20145 "2023-02-17T01:48:25Z")
Hi All, Question: Would I be able to run pt-online-schema-change (or another percona tool) that does everything but the table creation and data sync? I’m a beginner with percona and pt-online-schema-change and just wan… --- ## [ProxySQL 2.4.7 and ProxySQL admin tools Released](https://forums.percona.com/t/proxysql-2-4-7-and-proxysql-admin-tools-released/20117)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [February 15, 2023, 10:07am UTC](https://forums.percona.com/t/proxysql-2-4-7-and-proxysql-admin-tools-released/20117 "2023-02-15T10:07:28Z")
February 14, 2023 - See release notes at https://docs.percona.com/proxysql/2.4.7.html --- ## [Running pt-osc on RDS instance to alter a table with 1.9 billion records](https://forums.percona.com/t/running-pt-osc-on-rds-instance-to-alter-a-table-with-1-9-billion-records/7317)
**Author:** [@ryan.griffith](https://forums.percona.com/u/ryan.griffith)\ **Replies:** 1\ **Last updated:** [February 6, 2023, 9:56am UTC](https://forums.percona.com/t/running-pt-osc-on-rds-instance-to-alter-a-table-with-1-9-billion-records/7317 "2023-02-06T09:56:04Z")
I have an RDS instance running MySQL 5.5.46 which has a table with a primary key of int that it is currently at 1.9 billion records and approaching the 2.1 billion limit and ~425GB in size. I’m attempting to use pt-onlin… --- ## [How to connect to FTP/SSL from CloverETL](https://forums.percona.com/t/how-to-connect-to-ftp-ssl-from-cloveretl/8327)
**Author:** [@pramod](https://forums.percona.com/u/pramod)\ **Replies:** 0\ **Last updated:** [December 1, 2020, 7:57am UTC](https://forums.percona.com/t/how-to-connect-to-ftp-ssl-from-cloveretl/8327 "2020-12-01T07:57:33Z")
I am trying to connect to the FTP/SSL from CloverETL but I am getting error - Failed to read file metadata, Connection refused. Blow is what I am used to list down files from the location but job failed. ftp://user:pass… --- ## [Percona Toolkit v3.5.1 Released](https://forums.percona.com/t/percona-toolkit-v3-5-1-released/19749)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [January 24, 2023, 8:56am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-1-released/19749 "2023-01-24T08:56:15Z")
January 23, 2023 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Collation support for utf8mb4\_0900\_as\_ci](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863)
**Author:** [@Gustavo\_du\_Mortier](https://forums.percona.com/u/Gustavo_du_Mortier)\ **Replies:** 10\ **Last updated:** [December 7, 2022, 9:23pm UTC](https://forums.percona.com/t/collation-support-for-utf8mb4-0900-as-ci/18863 "2022-12-07T21:23:36Z")
Does anybody know if ProxySQL supports utf8mb4\_0900\_as\_ci collation? It supports utf8mb4\_0900\_ai\_ci, but I specifically need utf8mb4\_0900\_as\_ci. It is not in the mysql\_collations table. I inserted it in that table wit… --- ## [Pt-archiver does not archive tables with binary data columns and --bulk-insert \[PT-2127\]](https://forums.percona.com/t/pt-archiver-does-not-archive-tables-with-binary-data-columns-and-bulk-insert-pt-2127/18835)
**Author:** [@Tin\_Cvitkovic](https://forums.percona.com/u/Tin_Cvitkovic)\ **Replies:** 1\ **Last updated:** [November 30, 2022, 6:32pm UTC](https://forums.percona.com/t/pt-archiver-does-not-archive-tables-with-binary-data-columns-and-bulk-insert-pt-2127/18835 "2022-11-30T18:32:49Z")
https://jira.percona.com/browse/PT-2127 Archiving changes some values so that the checksum of the source and destination tables does not give the same values. By archiving without the --bulk-insert option, the data in … --- ## [Percona Toolkit v3.5.0 Released](https://forums.percona.com/t/percona-toolkit-v3-5-0-released/18829)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [November 30, 2022, 7:03am UTC](https://forums.percona.com/t/percona-toolkit-v3-5-0-released/18829 "2022-11-30T07:03:40Z")
November 28, 2022 - Find release notes at Percona Toolkit — Percona Toolkit Documentation --- ## [Pt-find - Can I return --exec select result?](https://forums.percona.com/t/pt-find-can-i-return-exec-select-result/18783)
**Author:** [@David\_Gleba](https://forums.percona.com/u/David_Gleba)\ **Replies:** 1\ **Last updated:** [November 28, 2022, 4:41am UTC](https://forums.percona.com/t/pt-find-can-i-return-exec-select-result/18783 "2022-11-28T04:41:06Z")
I would like to return the max(id) from a table using pt-find. pt-find -h 10.4.1.245 -P 3306 -u admindb -p $admindbpw -D prodrptdb \\ --exec "select max(id) from GFxPRoduction " This is all I see when running it… --- ## [Percona Toolkit "Not dropping triggers because the tool was interrupted"](https://forums.percona.com/t/percona-toolkit-not-dropping-triggers-because-the-tool-was-interrupted/18567)
**Author:** [@Mark\_Rehberger](https://forums.percona.com/u/Mark_Rehberger)\ **Replies:** 3\ **Last updated:** [November 17, 2022, 3:59pm UTC](https://forums.percona.com/t/percona-toolkit-not-dropping-triggers-because-the-tool-was-interrupted/18567 "2022-11-17T15:59:13Z")
I am trying to run this command below, but the process gets interrupted as evident by the screenshot. Is the table too big or could the problem be that the host is a replica database in AWS? pt-online-schema-change --ex… --- ## [Does Percona Toolkit store its logs and where?](https://forums.percona.com/t/does-percona-toolkit-store-its-logs-and-where/18537)
**Author:** [@Mark\_Rehberger](https://forums.percona.com/u/Mark_Rehberger)\ **Replies:** 1\ **Last updated:** [November 14, 2022, 5:00pm UTC](https://forums.percona.com/t/does-percona-toolkit-store-its-logs-and-where/18537 "2022-11-14T17:00:23Z")
Hi, does Percona Toolkit store its logs somewhere when a tool is executed? Thanks! --- ## [ProxySQL 2.4.4-1.2 and ProxySQL Admin Tools Released](https://forums.percona.com/t/proxysql-2-4-4-1-2-and-proxysql-admin-tools-released/18465)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [November 9, 2022, 6:09pm UTC](https://forums.percona.com/t/proxysql-2-4-4-1-2-and-proxysql-admin-tools-released/18465 "2022-11-09T18:09:28Z")
November 08, 2022 - Find release notes at ProxySQL 2.4.4-1.2 and ProxySQL admin tools (2022-11-08) - Percona ProxySQL Admin tool --- ## [ProxySQL removed all servers from it's database](https://forums.percona.com/t/proxysql-removed-all-servers-from-its-database/18032)
**Author:** [@bdriton13](https://forums.percona.com/u/bdriton13)\ **Replies:** 1\ **Last updated:** [October 24, 2022, 2:51pm UTC](https://forums.percona.com/t/proxysql-removed-all-servers-from-its-database/18032 "2022-10-24T14:51:29Z")
Hello, ProxySQL removed all servers from it’s database and added them again 2 days later automatically. The environment is a Kubenetes Cluster with one Control Plane and three Worker Nodes (v1.24.2) and pxc-operator (… --- ## [Which is Faster? Alter table with algorithm=copy or pt-osc?](https://forums.percona.com/t/which-is-faster-alter-table-with-algorithm-copy-or-pt-osc/18024)
**Author:** [@brianestrada658](https://forums.percona.com/u/brianestrada658)\ **Replies:** 4\ **Last updated:** [October 17, 2022, 5:13pm UTC](https://forums.percona.com/t/which-is-faster-alter-table-with-algorithm-copy-or-pt-osc/18024 "2022-10-17T17:13:29Z")
On a MySQL 5.7 test instance (non-production), assume I have 10 billion rows and the schema has 5 columns, 1 primary key, 1 unique key, and 1 foreign key. Which would be faster to execute to add a new column? Running a… --- ## [Altering table in mysql using pt-online-schema-change with triggers](https://forums.percona.com/t/altering-table-in-mysql-using-pt-online-schema-change-with-triggers/17906)
**Author:** [@Dba1](https://forums.percona.com/u/Dba1)\ **Replies:** 1\ **Last updated:** [October 7, 2022, 3:40pm UTC](https://forums.percona.com/t/altering-table-in-mysql-using-pt-online-schema-change-with-triggers/17906 "2022-10-07T15:40:07Z")
I am using a pt-online-schema change to alter a table and its column from smallint to mediumint. There is a trigger on the table I have read the documentation. During my dry -run I encountered “there is a trigger on the … [Previous page](https://forums.percona.com/c/polyglot-projects/26.md?page=4) [Next page](https://forums.percona.com/c/polyglot-projects/26.md?page=6)