Tag: CentOS

Feed: Planet PostgreSQL. After introducing the difference between the AES modes, in this document, I will put the results about the AES modes performance.The following tests just use one core CPU. AES-NI:The Advanced Encryption Standard Instruction Set (or Intel Advanced Encryption Standard New Instructions, AES-NI for short) is an extension of the x86 instruction set architecture for Intel and AMD microprocessors, presented by Intel in March 2008. [1] The purpose of this instruction set is to improve the speed at which applications use the Advanced Encryption Standard (AES) to perform encryption and decryption. OpenSSL: OpenSSL is a robust, commercial-grade, and ... Read More

Feed: Planet MySQL; Author: Percona Community; Geoff Winans  | August 14, 2019 |  Posted In: MariaDB, MySQL, ToolsIn my roles as a DBA at various companies, I generally found the tooling to be quite lacking. Everything from metrics collection, alerting, backup management; they were either missing, incomplete or implemented poorly. DBA-Tools was born from a desire to build backup tools that supported my needs in smaller/non-cloud environments. As BASH is easily the most common shell available out there on systems running MySQL® or MariaDB®, it was an easy choice.How DBA-Tools came to beWhile rebuilding my home-lab two years ago, I decided I ... Read More

Feed: Planet MySQL; Author: Severalnines; Deployment and management your database environment can be a tedious task. It's very common nowadays to use tools for automating your deployment to make these tasks easier. Automation solutions such as Chef, Puppet, Ansible, or SaltStack are just some of the ways to achieve these goals. This blog will show you how to use Puppet to deploy a Galera Cluster (specifically Percona XtraDB Cluster or PXC) utilizing ClusterControl Puppet Modules. This module makes the deployment, setup, and configuration easier than coding yourself from scratch. You may also want to check out one of our previous ... Read More

Feed: Planet MySQL; Author: Codership; Through Amazon Web Services (AWS), you can create virtual servers (i.e., instances). You can install database and Galera software on them. In this article, we’ll create three nodes, the minimum recommended for a healthy cluster, and configure them to use Galera Cluster. Incidentally, there is a more detailed version of this article in the Tutorial section of our Library. Assumptions & Preparation We’re assuming you have an AWS account and know the basics of the EC2 (Elastic Compute Cloud) platform. To access the nodes, you’ll need an encryption key. Create a new one specifically for ... Read More

Feed: Microsoft Azure Blog. Author: Evan Burness. Announcing the second-generation HB-series Azure Virtual Machines for high-performance computing (HPC). HBv2 Virtual Machines are designed to deliver leadership-class performance, message passing interface (MPI) scalability, and cost efficiency for a variety of real-world HPC workloads. HBv2 Virtual Machines feature 120 AMD EPYC™ 7002-series CPU cores, 480 GB of RAM, 480 MB of L3 cache, and no simultaneous multithreading (SMT). HBv2 Virtual Machines provide up to 350 GB/sec of memory bandwidth, which is 45-50 percent more than comparable x86 alternatives and three times faster than what most HPC customers have in their datacenters today ... Read More

Feed: Planet PostgreSQL. One of the great features of PostgreSQL is its extendability. My colleague and senior PostgreSQL developer Ibar has blogged about developing an extension with much broader capabilities including callback functionality. But in this blog post, I am trying to address a complete novice user who has never tried but wants to develop a simple function with business logic. Towards the end of the blog post, I want to show how lightweight the function is by doing simple benchmarking which is repeatable and should act as a strong justification for why end-users should do such development.Generally, PostgreSQL and ... Read More

Feed: Planet PostgreSQL. There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using EXPLAIN or EXPLAIN ANALYZE in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how plprofiler can be useful in profiling functions. plprofiler builds call graphs and creates flame graphs which make the report very easy to understand. Similarly, there is another interesting project called plpgsql_check which can be used for a similar purpose as plprofiler, while it ... Read More

Author: pchapman. For those of you who aren’t familiar with it, NuoDB Community Edition (CE) is our free developer version of the NuoDB product. It’s for those looking to do research, deploy a database with a small project, or simply get started developing with our technology.One of the big advantages of using NuoDB is its ability to scale out. However, earlier versions of NuoDB Community Edition didn’t allow you to do this. Deployment was limited to one Transaction Engine (TE) and one Storage Manager (SM) process on a single host.  For those of you who’d like  a refresher, NuoDB has ... Read More

Author: . For those of you who aren’t familiar with it, NuoDB Community Edition (CE) is our free developer version of the NuoDB product. It’s for those looking to do research, deploy a database with a small project, or simply get started developing with our technology.One of the big advantages of using NuoDB is its ability to scale out. However, earlier versions of NuoDB Community Edition didn’t allow you to do this. Deployment was limited to one Transaction Engine (TE) and one Storage Manager (SM) process on a single host.  For those of you who’d like  a refresher, NuoDB has ... Read More

Feed: Planet MySQL; Author: Severalnines; Despite the fact that PHP 5 has reached end-of-life, there are still legacy applications built on top of it that need to run in production or test environments. If you are installing PHP packages via operating system repository, there is still a chance you will end up with PHP 5 packages, e.g. CentOS 7 operating system. Having said that, there is always a way to make your legacy applications run with the newer database versions, and thus take advantage of new features. In this blog post, we’ll walk you through how we can run PHP 5 ... Read More