Mon, 20 May 2024 13:08:17 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/ https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/#respond Mon, 20 May 2024 13:06:30 +0000 https://www.percona.com/blog/?p=96350 If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]]]> https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/feed/ 0 96350 https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/ https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/#comments Fri, 12 Jan 2024 14:39:28 +0000 https://www.percona.com/blog/?p=93471 One of our customers wants to create a table having a column of data type TEXT with the default value, but they encountered an error: [crayon-664c6d5c9d16b698138080-i/]. It seems reasonable at first glimpse, as we know that each BLOB, TEXT, GEOMETRY, or JSON value is represented internally by a separately allocated object. This is in contrast […]]]> https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/feed/ 1 93471 https://www.percona.com/blog/chatgpt-wont-replace-mysql-dba/ https://www.percona.com/blog/chatgpt-wont-replace-mysql-dba/#comments Thu, 16 Feb 2023 14:06:29 +0000 https://www.percona.com/blog/?p=85438 ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview.  I wondered, does that mean ChatGPT is ready to replace MySQL DBAs, too? No. Let me show you why.Recently, one of our clients was considering encrypting their data at rest using […]]]> https://www.percona.com/blog/chatgpt-wont-replace-mysql-dba/feed/ 2 85438 https://www.percona.com/blog/how-mysql-uses-character_set-configurations/ https://www.percona.com/blog/how-mysql-uses-character_set-configurations/#comments Tue, 27 Dec 2022 13:17:16 +0000 https://www.percona.com/blog/?p=84304 There are eight configuration options related to the character_set in MySQL, as shown below. Without reading the MySQL Character Set documentation carefully, it could be hard to know what these configuration options are used for. In addition, for some of the options, unless there is further testing, it could be hard to know how MySQL […]]]> https://www.percona.com/blog/how-mysql-uses-character_set-configurations/feed/ 2 84304 https://www.percona.com/blog/mysql-replicate-from-unsigned-int-to-unsigned-bigint/ https://www.percona.com/blog/mysql-replicate-from-unsigned-int-to-unsigned-bigint/#comments Tue, 06 Sep 2022 12:21:41 +0000 https://www.percona.com/blog/?p=82410 We often see an int column of a table that needs to be changed to unsigned-int and then unsigned-bigint due to the value being out of range. Sometimes, there may even be blockers that prevent us from directly altering the table or applying pt-online-schema-change on the primary, which requires the rotation solution: apply the change […]]]> https://www.percona.com/blog/mysql-replicate-from-unsigned-int-to-unsigned-bigint/feed/ 1 82410 https://www.percona.com/blog/correcting-mysql-inaccurate-table-statistics-for-better-execution-plan/ https://www.percona.com/blog/correcting-mysql-inaccurate-table-statistics-for-better-execution-plan/#comments Fri, 15 Apr 2022 11:48:19 +0000 https://www.percona.com/blog/?p=80706 Abstract:By diving into the details of our case study, we will explain how incorrect table statistics may lead the optimizer to choose a suboptimal execution plan. We will also go into how MySQL calculates the table statistics and the ways to correct the table statistics to prevent it from happening again.Case study: Incorrect table statistics lead […]]]> https://www.percona.com/blog/correcting-mysql-inaccurate-table-statistics-for-better-execution-plan/feed/ 7 80706