Tue, 27 Feb 2024 18:49:46 +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/choosing-mysql-high-availability-solutions/ https://www.percona.com/blog/choosing-mysql-high-availability-solutions/#comments Thu, 01 Feb 2024 09:00:15 +0000 https://www.percona.com/blog/?p=35895 This blog was originally published in June 2016 but was updated in February 2024.In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed decision-making regarding your database infrastructure. HA is crucial for maintaining uninterrupted access to essential data; […]]]> https://www.percona.com/blog/choosing-mysql-high-availability-solutions/feed/ 2 35895 https://www.percona.com/blog/some-things-to-consider-before-moving-your-database-to-the-cloud/ https://www.percona.com/blog/some-things-to-consider-before-moving-your-database-to-the-cloud/#respond Thu, 21 Apr 2022 12:30:58 +0000 https://www.percona.com/blog/?p=77105 Before you transition your database environment to the cloud, there are a few considerations you should consider first.  Some of the touted benefits of the cloud also carry with them some risks or negative impacts.  Let’s take a look at just a few of these.First, consider whether or not you will face vendor lock-in.  Many […]]]> https://www.percona.com/blog/some-things-to-consider-before-moving-your-database-to-the-cloud/feed/ 0 77105 https://www.percona.com/blog/finding-differences-between-mysql-servers/ https://www.percona.com/blog/finding-differences-between-mysql-servers/#respond Wed, 20 Apr 2022 11:25:01 +0000 https://www.percona.com/blog/?p=77103 When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through Production, it is often useful to ensure that configurations in test environments are comparable to the final production environment.  This is especially true with systems where a team of DBAs manage the servers.Obviously, the difference […]]]> https://www.percona.com/blog/finding-differences-between-mysql-servers/feed/ 0 77103 https://www.percona.com/blog/deploying-a-mongodb-proof-of-concept-on-google-cloud-platform/ Fri, 09 Apr 2021 14:19:55 +0000 https://www.percona.com/blog/?p=75166 Recently, I needed to set up a Proof of Concept (POC) and wanted to do it on Google Cloud Platform (GCP).  After documenting the process, it seemed it might be helpful for others looking for the most basic guide possible to get a Mongo server up and running on GCP.  The process below will set […]]]> 75166 https://www.percona.com/blog/mysql-101-basic-mysql-server-triage/ Wed, 07 Apr 2021 17:53:31 +0000 https://www.percona.com/blog/?p=75178 So your MySQL server has crashed.  What do you do now?  When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause analysis (RCA). Get the server back up and running. Too many […]]]> 75178 https://www.percona.com/blog/updated-mysql-osmetrics-plugins/ https://www.percona.com/blog/updated-mysql-osmetrics-plugins/#comments Fri, 08 Jan 2021 16:52:43 +0000 https://www.percona.com/blog/?p=73557 It has been some time since I have posted updates to my plugins.  After the initial version, I decided to split the plugins into categories of metrics.  This will allow users to choose whether they want to install all of the plugins or only select ones they care about.Since the installation process is unfamiliar to […]]]> https://www.percona.com/blog/updated-mysql-osmetrics-plugins/feed/ 2 73557 https://www.percona.com/blog/a-simple-mysql-plugin-to-retrieve-system-metrics/ Wed, 08 Jul 2020 13:45:36 +0000 https://www.percona.com/blog/?p=69528 Ever wanted to extend MySQL and add some feature you think it is missing?  With MySQL plugins, you can do exactly that.  One thing that has bothered me for several years is that you cannot easily retrieve system metrics from within MySQL.  Whether I am connecting via a remote connection or looking to add features […]]]> 69528 https://www.percona.com/blog/mysql-101-linux-tuning-for-mysql/ https://www.percona.com/blog/mysql-101-linux-tuning-for-mysql/#comments Mon, 06 Jul 2020 18:30:38 +0000 https://www.percona.com/blog/?p=69532 When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.  Below are some of the most important of these settings to help you get started.SwappinessThe first thing to look at is what swappiness is set to.  This will determine the tendency of the […]]]> https://www.percona.com/blog/mysql-101-linux-tuning-for-mysql/feed/ 2 69532 https://www.percona.com/blog/the-evolution-of-the-dba-role/ https://www.percona.com/blog/the-evolution-of-the-dba-role/#comments Wed, 08 Apr 2020 16:56:07 +0000 https://www.percona.com/blog/?p=66470 As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role.  With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning, configuring backups, and so on.  Instead, DBAs are moving […]]]> https://www.percona.com/blog/the-evolution-of-the-dba-role/feed/ 5 66470 https://www.percona.com/blog/why-enterprises-are-moving-to-containerization/ Thu, 02 Apr 2020 19:44:07 +0000 https://www.percona.com/blog/?p=66468 As a Technical Account Manager, or TAM for short, I am fortunate to work with some large clients.  Most all of them are in some state of increasing their usage of containerization.  There are a number of reasons for this, but let’s explore a few of the biggest reasons.Why Containers?Almost everyone has deployed Virtual Machines […]]]> 66468 https://www.percona.com/blog/a-day-in-the-life-of-a-technical-account-manager/ https://www.percona.com/blog/a-day-in-the-life-of-a-technical-account-manager/#comments Mon, 06 Jan 2020 18:02:43 +0000 https://www.percona.com/blog/?p=64361 So, what do you do when you love technology but are ready for a change in the day-to-day activities of a DBA?  One consideration is to become a Technical Account Manager, or TAM for short.  At Percona, a TAM is an account manager who is also technical (the big “T” in TAM).  While everyone’s path […]]]> https://www.percona.com/blog/a-day-in-the-life-of-a-technical-account-manager/feed/ 1 64361 https://www.percona.com/blog/implementing-a-database-center-of-excellence/ Thu, 02 Jan 2020 16:11:18 +0000 https://www.percona.com/blog/?p=64353 In your organization, who decides what database platform will be utilized for that new application being built?  For many groups, that decision is made by the Development Team while for others, it is the Database Team.  But, which is best equipped to make that decision?  As is usually the case, the answer lies in joint […]]]> 64353 https://www.percona.com/blog/achieving-disaster-recovery-with-percona-xtradb-cluster/ Mon, 07 Oct 2019 16:00:46 +0000 https://www.percona.com/blog/?p=62510 One thing that comes up often from working with a variety of clients at Percona is “How can I achieve a Disaster Recovery (DR) solution with Percona XtraDB Cluster (PXC)?”  Unfortunately, decisions are sometimes made with far-reaching consequences by individuals who often do not well understand the architecture and its limitations.  As a Technical Account […]]]> 62510 https://www.percona.com/blog/centralization-vs-decentralization-of-dba-teams/ Mon, 07 Oct 2019 13:30:39 +0000 https://www.percona.com/blog/?p=62512 As a Technical Account Manager (TAM), I have seen many of our clients adopt a decentralized DBA Team.  In many cases, this is an effort to better align the DBA Team with the Development Teams.  This is an admirable and logical goal.  As often happens, you often trade one set of challenges for another.Centralized DBA […]]]> 62512