{"id":9670,"date":"2019-09-23T08:29:47","date_gmt":"2019-09-23T06:29:47","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/"},"modified":"2019-09-23T08:29:47","modified_gmt":"2019-09-23T06:29:47","slug":"rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/","title":{"rendered":"Rolling Upgrade of a Galera Cluster with ClusterControl"},"content":{"rendered":"

Rolling Upgrade is easy<\/h1>\n

In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster “Rolling Upgrade” without any loss of service.
\nLet\u2019s say we want to upgrade from Percona XtraDB Cluster version 5.6 to 5.7.
\nThe same procedure can be used to upgrade MariaDB (from 10.1 to 10.2 or 10.3)
\n\"\"<\/a><\/p>\n

Prerequisites<\/h2>\n

First of all, make sure that on your Galera cluster all nodes are synchronized.
\nFrom the Dashboard, on the tab Overview, then the Galera Nodes window, in the Last \u201cCommitted\u201d column , all 3 figures must be identical.
\n\"\"<\/a>
\nThen disable from the GUI the “cluster & node auto-recovery”either by clicking on both until it gets red or by setting temporarely on the clustercontrol server in the
\n\/etc\/cmon.d\/cmon_N.cnf file (N stands for Cluster ID) the 2 following parameters:
\n– enable_cluster_autorecovery=0
\n– enable_node_autorecovery=0
\ndon’t forget to restart the cmon service.
\nsystemctl restart cmon<\/code>
\nIt is very important & even crucial otherwise Clustercontrol will try everytime to restart the Galera node when you will stop it during the upgrade process.
\n\"\"<\/a>
\nNow we have to put the first Galera node in maintenance mode for one hour.
\n\"\"<\/a>
\n\"\"<\/a>
\nThe Cluster status bar should be now as following.<\/p>\n

\"\"<\/a><\/p>\n

Cluster Upgrade<\/h2>\n

Log on the first master node using your favorite terminal emulator \u201cputty\u201d or “MobaXterm”, open 2 sessions and stop the Percona service on the first node.
\n# service mysql status
\nSUCCESS! MySQL (Percona XtraDB Cluster) running (19698)
\n# service mysql stop
\nShutting down MySQL (Percona XtraDB Cluster).. SUCCESS!
\n# service mysql status
\nERROR! MySQL (Percona XtraDB Cluster) is not running<\/code>
\nRemove now existing Percona XtraDB Cluster and Percona XtraBackup packages
\n#[root@node1 yum.repos.d]# yum remove percona-xtrabackup* Percona-XtraDB-Cluster*
\nLoaded plugins: fastestmirror, ovl
\nSetting up Remove Process
\nResolving Dependencies
\n--> Running transaction check
\n---> Package Percona-XtraDB-Cluster-56.x86_64 1:5.6.44-28.34.1.el6 will be erased
\n---> Package Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.44-28.34.1.el6 will be erased
\n---> Package Percona-XtraDB-Cluster-galera-3.x86_64 0:3.34-1.el6 will be erased
\n---> Package Percona-XtraDB-Cluster-server-56.x86_64 1:5.6.44-28.34.1.el6 will be erased
\n---> Package Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.44-28.34.1.el6 will be erased
\n---> Package percona-xtrabackup.x86_64 0:2.3.10-1.el6 will be erased
\n--> Finished Dependency Resolution
\nRemoved:
\nPercona-XtraDB-Cluster-56.x86_64 1:5.6.44-28.34.1.el6 Percona-XtraDB-Cluster-client-56.x86_64 1:5.6.44-28.34.1.el6 Percona-XtraDB-Cluster-galera-3.x86_64 0:3.34-1.el6
\nPercona-XtraDB-Cluster-server-56.x86_64 1:5.6.44-28.34.1.el6 Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.44-28.34.1.el6 percona-xtrabackup.x86_64 0:2.3.10-1.el6
\nComplete!<\/code>
\nInstall the new packages
\n#[root@node1 yum.repos.d]# yum install Percona-XtraDB-Cluster-57
\nResolving Dependencies
\n--> Running transaction check
\n---> Package Percona-XtraDB-Cluster-57.x86_64 0:5.7.26-31.37.1.el6 will be installed
\n--> Processing Dependency: Percona-XtraDB-Cluster-client-57 = 5.7.26-31.37.1.el6 for package: Percona-XtraDB-Cluster-57-5.7.26-31.37.1.el6.x86_64
\n--> Processing Dependency: Percona-XtraDB-Cluster-server-57 = 5.7.26-31.37.1.el6 for package: Percona-XtraDB-Cluster-57-5.7.26-31.37.1.el6.x86_64
\n--> Running transaction check
\n---> Package Percona-XtraDB-Cluster-client-57.x86_64 0:5.7.26-31.37.1.el6 will be installed
\n---> Package Percona-XtraDB-Cluster-server-57.x86_64 0:5.7.26-31.37.1.el6 will be installed
\n--> Processing Dependency: Percona-XtraDB-Cluster-shared-57 = 5.7.26-31.37.1.el6 for package: Percona-XtraDB-Cluster-server-57-5.7.26-31.37.1.el6.x86_64
\n--> Processing Dependency: percona-xtrabackup-24 >= 2.4.12 for package: Percona-XtraDB-Cluster-server-57-5.7.26-31.37.1.el6.x86_64
\n--> Processing Dependency: qpress for package: Percona-XtraDB-Cluster-server-57-5.7.26-31.37.1.el6.x86_64
\n--> Running transaction check
\n---> Package Percona-XtraDB-Cluster-shared-57.x86_64 0:5.7.26-31.37.1.el6 will be installed
\n---> Package percona-xtrabackup-24.x86_64 0:2.4.15-1.el6 will be installed
\n---> Package qpress.x86_64 0:11-1.el6 will be installed
\n--> Finished Dependency Resolution
\nDependencies Resolved
\nInstalled:
\nPercona-XtraDB-Cluster-57.x86_64 0:5.7.26-31.37.1.el6
\nDependency Installed:
\nPercona-XtraDB-Cluster-client-57.x86_64 0:5.7.26-31.37.1.el6 Percona-XtraDB-Cluster-server-57.x86_64 0:5.7.26-31.37.1.el6
\nPercona-XtraDB-Cluster-shared-57.x86_64 0:5.7.26-31.37.1.el6 percona-xtrabackup-24.x86_64 0:2.4.15-1.el6
\nqpress.x86_64 0:11-1.el6
\nComplete!<\/code>
\nStart the node outside the cluster (in standalone mode) by setting the wsrep_provider variable to none.
\n$ ps -edf|grep -i mysql
\n$ mysqld --user=mysql --wsrep-provider='none'<\/code>
\nRun now mysql_upgrade in the second session
\n[root@node1 \/]# mysql_upgrade -u root -p
\nEnter password:
\nChecking if update is needed.
\nChecking server version.
\nRunning queries to upgrade MySQL server.
\nChecking system database.
\nmysql.columns_priv OK
\nmysql.db OK
\nmysql.engine_cost OK
\nmysql.user OK
\nUpgrading the sys schema.
\nChecking databases.
\nsys.sys_config OK
\nUpgrade process completed successfully.
\nChecking if update is needed<\/code>
\nWhen the upgrade is over, stop the mysqld process.
\nYou can either kill the mysqld process ID or use mysqladmin shutdown with the MySQL root user credentials.
\n$ mysqladmin shutdown -uroot -p<\/code>
\nNow you can restart the upgraded node to join the Galera cluster in the first session.
\n$ service mysql start
\nStarting Percona-Xtradb-server.190612 13:04:33 mysqld_safe Logging to '\/var\/log\/mysql\/mysqld.log'.
\n190612 13:04:33 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql
\n.. SUCCESS!<\/code><\/p>\n

Post-exec tasks<\/h2>\n

From the GUI, disable the maintenance mode and check for the new version by logging in the instance.
\n[root@node1 \/]# mysql -u root -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 64
\nServer version: 5.7.27-30-57 Percona XtraDB Cluster (GPL), Release rel30, Revision 64987d4, WSREP version 31.39, wsrep_31.39
\nOnce the first node is upgraded, you can repeat exactly the same procedure for all the other nodes in the cluster.<\/code><\/p>\n

Now you can repeat exactly the same procedure for the other nodes of the cluster. At the end, Clustercontrol should display the same version for all nodes.
\n\"\"<\/a><\/p>\n

Conclusion<\/h2>\n

Rolling upgrade of a Galera cluster with Clustercontrol is really easy and fast with no or very few impact on the service.<\/p>\n","protected":false},"excerpt":{"rendered":"

Rolling Upgrade is easy In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster “Rolling Upgrade” without any loss of service. Let\u2019s say we want to upgrade from Percona XtraDB Cluster version 5.6 to 5.7. The same procedure can be used to upgrade MariaDB (from 10.1 to […]<\/p>\n","protected":false},"author":28,"featured_media":9678,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-9670","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"\nRolling Upgrade of a Galera Cluster with ClusterControl - dbi Blog<\/title>\n<meta name=\"description\" content=\"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster "Rolling Upgrade" without any loss of service.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Rolling Upgrade of a Galera Cluster with ClusterControl\" \/>\n<meta property=\"og:description\" content=\"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster "Rolling Upgrade" without any loss of service.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-23T06:29:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1234\" \/>\n\t<meta property=\"og:image:height\" content=\"93\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\"},\"author\":{\"name\":\"Open source Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"headline\":\"Rolling Upgrade of a Galera Cluster with ClusterControl\",\"datePublished\":\"2019-09-23T06:29:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\"},\"wordCount\":388,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg\",\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\",\"name\":\"Rolling Upgrade of a Galera Cluster with ClusterControl - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg\",\"datePublished\":\"2019-09-23T06:29:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\"},\"description\":\"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster \\\"Rolling Upgrade\\\" without any loss of service.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg\",\"width\":1234,\"height\":93},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rolling Upgrade of a Galera Cluster with ClusterControl\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g\",\"caption\":\"Open source Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Rolling Upgrade of a Galera Cluster with ClusterControl - dbi Blog","description":"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster \"Rolling Upgrade\" without any loss of service.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/","og_locale":"en_US","og_type":"article","og_title":"Rolling Upgrade of a Galera Cluster with ClusterControl","og_description":"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster \"Rolling Upgrade\" without any loss of service.","og_url":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/","og_site_name":"dbi Blog","article_published_time":"2019-09-23T06:29:47+00:00","og_image":[{"width":1234,"height":93,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg","type":"image\/jpeg"}],"author":"Open source Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Open source Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/"},"author":{"name":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"headline":"Rolling Upgrade of a Galera Cluster with ClusterControl","datePublished":"2019-09-23T06:29:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/"},"wordCount":388,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg","articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/","url":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/","name":"Rolling Upgrade of a Galera Cluster with ClusterControl - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg","datePublished":"2019-09-23T06:29:47+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b"},"description":"In this blog, I will show you how easy it is with Clustercontrol to perform a Galera cluster \"Rolling Upgrade\" without any loss of service.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/MariaDB-Version.jpg","width":1234,"height":93},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/rolling-upgrade-of-a-percona-xtradb-cluster-in-clustercontrol-1-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Rolling Upgrade of a Galera Cluster with ClusterControl"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/59554f0d99383431eb6ed427e338952b","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eb4fb12e386e8c41fdef0733e8114594cf2653e4f55e9fa2161442b8eaf3f657?s=96&d=mm&r=g","caption":"Open source Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9670"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9678"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9670"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}