This post is the third post of a series of articles on extending MySQL with the Component Infrastructure:
This post is the second post of a series of articles on extending MySQL with the Component Infrastructure:
This post is the first post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
With modern application design, systems are becoming more diverse, varied and have more components than ever before. Developers are often forced to become master chefs adding the ingredients from dozens of different technologies and blending them together to create something tasty and amazing. But with so many different ingredients, it is often difficult to understand how the individual ingredients interact with each other. The more diverse the application, the more likely it is that some seemingly insignificant combination of technology may cause cascading effects.
Many people I talk to have hundreds if not thousands of different libraries, APIs, components, and services making up the systems they support. In this type of environment, it is very difficult to know what small thing could add up to something much bigger. Look at some of the more recent …
[Read more]Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the potential cost savings using the new AMD family.
The idea behind the analysis is to do a side-by-side comparison of performance considering some factors:
The goal of this analysis is to check if cost reductions by upgrading from N1 to N2D are worth the change to avoid suffering from performance problems and eventually reduce the machine size from the current 64 cores based (N1 n1-highmem-64 – Intel Haswell) to either N2D 64 …
[Read more]Hey everyone, I’m creating a dedicated page of ‘Friend links‘ for all of my Medium first articles and blogs. Continue reading to learn more and how to gain access to them…
Image by David Schwarzenberg from Pixabay
Medium’s Friend Link
If you’re a paying Medium member, not only can you read unlimited blog posts by any author on the platform, but you can also publish your blog posts and articles behind the paywall and earn some money from them. Every article you put behind the paywall also has a ‘Friend …
[Read more]SCaLE 19X – the 19th annual Southern California Linux Expo – will take place March 3-6, 2022 in Pasadena, CA.
SCaLE is the largest community-run open-source and free software conference in North America. It is held annually in the greater Los Angeles area. A year might have been skipped due to Covid-19 but it looks like we will be back in person this year.
The MySQL Track features nine talks on a variety of subjects from some of the best known MySQL experts.
Dave Stokes - MySQL New Features
MySQL now …
[Read more]
Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And how proxySQL can help in minimizing the downtime ? A little sneak peek on the results ProxySQL achieves up to 25x less downtime and the impressive up to ~9800x less errors during unplanned failovers. How proxySQL achieves this:
So what is ProxySQL? ProxySQL is a middle layer between the database and the application. ProxySQL protects databases from high traffic spikes, prevents databases from having high number of connections due to the multiplexing feature and minimizes the impact during planned/unexpected failovers or crashes of DBs.
This blog will continue with measuring the impact of an unexpected …
[Read more]Security will always be a main focal point of a company’s data. A common question I get from clients is, “how do I enable encryption?” Like every good consulting answer, it depends on what you are trying to encrypt. This post is a high-level summary of the different options available for encryption in Percona Server for MySQL.
Different certifications require different levels of encryption. For example, PCI requires both encryptions of data at rest and in transit. Here are the main facets of encryption for MySQL:
Data at Rest
…
[Read more]Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (“butter-FS”, “b-tree FS”) with MySQL. BTRFS is a filesystem with an architecture and a set of features that are similar to ZFS and with a GPL license. It is a copy-on-write (CoW) filesystem supporting snapshots, RAID, and data compression. These are compelling features for a database server so let’s have a look.
Many years ago, in 2012, Vadim wrote a blog post about BTRFS and the results were disappointing. Needless to say that since 2012, a lot of work and effort has been invested in BTRFS. So, this post will examine the BTRFS version that comes with the latest Ubuntu LTS, 20.04. It is not bleeding edge but it is likely the most recent …
[Read more]