Fri, 16 Feb 2024 22:21:14 +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/percona-live-advanced-percona-xtradb-cluster-nutshell-la-suite/ Wed, 06 Apr 2016 16:30:33 +0000 https://www.percona.com/blog/?p=34606 This blog post will discuss what is necessary of the Percona Live  Advanced Percona XtraDB Cluster tutorial.Percona Live 2016 is happening in April! If you are attending, and you are registered to the Percona XtraDB Cluster (Galera) tutorial presented by Kenny and myself, please make sure that you: Bring your laptop, this is a hands-on […]]]> 34606 https://www.percona.com/blog/read-write-split-routing-performance-in-maxscale/ https://www.percona.com/blog/read-write-split-routing-performance-in-maxscale/#comments Wed, 30 Mar 2016 00:42:50 +0000 https://www.percona.com/blog/?p=33825 In this blog post, we’ll discuss read-write split routing in MaxScale.The two previous posts have shown how to setup high availability (HA) with Maxscale using asynchronous replication and how we monitor replication.Now let’s focus on the routing module performing read-write splits.This is our current configuration: [crayon-664caefd9e510737507058/] This router module is designed to spread the read queries […]]]> https://www.percona.com/blog/read-write-split-routing-performance-in-maxscale/feed/ 2 33825 https://www.percona.com/blog/json-document-fast-lookup-with-mysql-5-7/ https://www.percona.com/blog/json-document-fast-lookup-with-mysql-5-7/#comments Mon, 07 Mar 2016 23:43:53 +0000 https://www.percona.com/blog/?p=34019 In this blog post, we’ll discuss JSON document fast lookup with MySQL 5.7.Recently I attended Morgan Tocker’s talk on MySQL 5.7 and JSON at FOSDEM, and I found it awesome.I learned some great information from the talk. Let me share one of them here: a very useful trick if you plan to store JSON documents in […]]]> https://www.percona.com/blog/json-document-fast-lookup-with-mysql-5-7/feed/ 4 34019 https://www.percona.com/blog/maxscale-how-are-servers-monitored/ https://www.percona.com/blog/maxscale-how-are-servers-monitored/#comments Wed, 02 Mar 2016 15:56:20 +0000 https://www.percona.com/blog/?p=33785 In this post, we’ll address how MaxScale monitors servers. We saw in theWe saw in the previous post how we could deal with high availability (HA) and read-write split using MaxScale.If you remember from the previous post, we used this section to monitor replication: [crayon-664caefda04cd989346581/] But what are we monitoring? We are monitoring the assignment […]]]> https://www.percona.com/blog/maxscale-how-are-servers-monitored/feed/ 1 33785 https://www.percona.com/blog/high-availability-with-asynchronous-replication-and-transparent-rw-split/ https://www.percona.com/blog/high-availability-with-asynchronous-replication-and-transparent-rw-split/#comments Thu, 25 Feb 2016 18:54:23 +0000 https://www.percona.com/blog/?p=33714 In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ?Description: Three MySQL servers, […]]]> https://www.percona.com/blog/high-availability-with-asynchronous-replication-and-transparent-rw-split/feed/ 4 33714 https://www.percona.com/blog/mysql-connection-using-ssl-or-not/ https://www.percona.com/blog/mysql-connection-using-ssl-or-not/#comments Tue, 23 Feb 2016 23:20:29 +0000 https://www.percona.com/blog/?p=33707 In this blog post, we’ll determine a MySQL connection using SSL… or not.Since MySQL 5.7.5 the server generates SSL certificates (see auto_generate_certs) by default if compiled with SSL, or uses mysql_ssl_rsa_setup if compiled with YaSSL.But how can we check to see if our MySQL client connection uses SSL?When using an interactive client, it’s easy! You have […]]]> https://www.percona.com/blog/mysql-connection-using-ssl-or-not/feed/ 6 33707 https://www.percona.com/blog/proxy-protocol-percona-xtradb-cluster-quick-guide/ https://www.percona.com/blog/proxy-protocol-percona-xtradb-cluster-quick-guide/#comments Thu, 15 Oct 2015 17:23:01 +0000 https://www.percona.com/blog/?p=31912 On September 21st, we released Percona XtraDB Cluster 5.6.25. This is the first PXC release supporting proxy-protocol that has been included in Percona Server since 5.6.25-73.0.With this blog post, I want to promote a new feature that you may have ignored.Let’s start with a description of the use case:Architecture Overview:HAProxy is configured like this: [crayon-664caefda2c60429851627/] So until […]]]> https://www.percona.com/blog/proxy-protocol-percona-xtradb-cluster-quick-guide/feed/ 2 31912 https://www.percona.com/blog/mysql-friends-devroom-fosdem-2015/ https://www.percona.com/blog/mysql-friends-devroom-fosdem-2015/#comments Mon, 27 Oct 2014 13:50:26 +0000 https://www.percona.com/blog/?p=26448 https://www.percona.com/blog/mysql-friends-devroom-fosdem-2015/feed/ 2 26448 https://www.percona.com/blog/mariadb-selective-binary-logs-events/ Thu, 31 Jul 2014 21:29:10 +0000 https://www.percona.com/blog/?p=24715 24715 https://www.percona.com/blog/location-for-innodb-tablespace-in-mysql-5-6-6/ https://www.percona.com/blog/location-for-innodb-tablespace-in-mysql-5-6-6/#comments Wed, 28 May 2014 10:00:16 +0000 https://www.percona.com/blog/?p=23220 https://www.percona.com/blog/location-for-innodb-tablespace-in-mysql-5-6-6/feed/ 7 23220 https://www.percona.com/blog/changing-async-slave-pxc-cluster-new-master-using-5-6-gtid/ https://www.percona.com/blog/changing-async-slave-pxc-cluster-new-master-using-5-6-gtid/#comments Fri, 14 Feb 2014 11:00:24 +0000 https://www.percona.com/blog/?p=20898 https://www.percona.com/blog/changing-async-slave-pxc-cluster-new-master-using-5-6-gtid/feed/ 2 20898 https://www.percona.com/blog/fosdem-2014-mysql-friends-devroom-2/ Thu, 23 Jan 2014 08:00:25 +0000 https://www.percona.com/blog/?p=20461 20461 https://www.percona.com/blog/fosdem-2014-mysql-friends-devroom/ Wed, 06 Nov 2013 15:39:25 +0000 https://www.percona.com/blog/?p=19045 19045 https://www.percona.com/blog/oss4b-presenting-in-italy-on-mysql-and-percona-xtradb-cluster/ Wed, 18 Sep 2013 04:10:39 +0000 https://www.percona.com/blog/?p=18003 18003 https://www.percona.com/blog/why-its-beneficial-to-attend-mysql-conferences/ https://www.percona.com/blog/why-its-beneficial-to-attend-mysql-conferences/#comments Tue, 30 Jul 2013 10:00:36 +0000 https://www.percona.com/blog/?p=17022 https://www.percona.com/blog/why-its-beneficial-to-attend-mysql-conferences/feed/ 1 17022 https://www.percona.com/blog/2-new-features-added-to-percona-xtradb-cluster-pxc-since-5-5-31/ https://www.percona.com/blog/2-new-features-added-to-percona-xtradb-cluster-pxc-since-5-5-31/#comments Fri, 28 Jun 2013 13:32:52 +0000 https://www.percona.com/blog/?p=16407 https://www.percona.com/blog/2-new-features-added-to-percona-xtradb-cluster-pxc-since-5-5-31/feed/ 6 16407 https://www.percona.com/blog/how-to-fix-your-prm-cluster-when-upgrading-to-rhelcentos-6-4/ https://www.percona.com/blog/how-to-fix-your-prm-cluster-when-upgrading-to-rhelcentos-6-4/#comments Wed, 29 May 2013 15:28:50 +0000 https://www.percona.com/blog/?p=15633 https://www.percona.com/blog/how-to-fix-your-prm-cluster-when-upgrading-to-rhelcentos-6-4/feed/ 3 15633 https://www.percona.com/blog/how-to-start-a-percona-xtradb-cluster/ https://www.percona.com/blog/how-to-start-a-percona-xtradb-cluster/#comments Tue, 29 Jan 2013 21:49:51 +0000 https://www.percona.com/blog/?p=12571 https://www.percona.com/blog/how-to-start-a-percona-xtradb-cluster/feed/ 26 12571 https://www.percona.com/blog/percona-xtradb-cluster-selinux-is-not-always-the-culprit/ https://www.percona.com/blog/percona-xtradb-cluster-selinux-is-not-always-the-culprit/#comments Thu, 20 Dec 2012 14:02:30 +0000 https://www.percona.com/blog/?p=11918 https://www.percona.com/blog/percona-xtradb-cluster-selinux-is-not-always-the-culprit/feed/ 6 11918 https://www.percona.com/blog/percona-xtradb-cluster-pxc-what-about-gra_-log-files/ https://www.percona.com/blog/percona-xtradb-cluster-pxc-what-about-gra_-log-files/#comments Wed, 19 Dec 2012 16:55:37 +0000 https://www.percona.com/blog/?p=11897 https://www.percona.com/blog/percona-xtradb-cluster-pxc-what-about-gra_-log-files/feed/ 4 11897