Tag: Client

Feed: Planet PostgreSQL. 1. Introduction This is part 3 of the blog “Understanding Security Features in PostgreSQL”, in which I will be discussing how to apply TLS in both PostgreSQL server and client using the principles we have learned in part 2 of the blog. In the end, I will also briefly talk about Transparent Data Encryption (TDE) and security vulnerability. Here is the overview of the security topics that will be covered in all parts of the blog: Part 1: PostgreSQL Server Listen AddressHost-Based AuthenticationAuthentication with LDAP ServerAuthentication with PAMRole-Based Access Control Assign Table and Column Level Privileges to ... Read More

Feed: Planet PostgreSQL. 1. Introduction This is part 2 of the blog “Understanding Security Features in PostgreSQL”, in which I will be discussing TLS in greater details. I will begin by going over some of the most important security concepts around TLS before jumping into enabling TLS on PostgreSQL server. I believe it is crucial to have sufficient background information on TLS before tweaking the TLS settings in both client and server sides. In part 1 of this blog, we mostly discussed about authentication and authorization (AA), which is important to identify which client is permitted to connect and which ... Read More

Feed: Planet PostgreSQL. 1. Introduction PostgreSQL is packed with several security features for a database administrator to utilize according to his or her organizational security needs. The word Security is a very broad concept and could refer to completely different procedures and methodology to achieve in different PostgreSQL components. This blog is divided into part 1, 2 and 3 and I will explain the word Security with regards to PostgreSQL version 12.1 and how it is practiced in different areas within the system. In Part 1 of the blog, I will be discussing the basic security features that exist in ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; In part 1, we took a brief, high-level look at the various protocols and mechanisms used to keep the Data Dictionary (DD) of MySQL servers connected to a MySQL Cluster in synchronization with each other and with the NDB Dictionary. More specifically, we explored the problems with the implementation of user-triggered synchronization in the NDB Cluster 7.x versions. These concerns are addressed in NDB Cluster 8.0 through a new feature: Automatic Schema Synchronization (or auto schema sync for short). A new component called Metadata Change Monitor has been introduced to detect any NDB ... Read More

Feed: Planet MySQL; Author: MyDBOPS; As a part of Mydbops Consulting we have a below problem statement from one of our client. “We have a high powered server for reporting which in turn powers our internal dashboard for viewing the logistics status.Even with a high end hardware, we had a heavy CPU usage and which in turn triggers spikes in replication lag and slowness. Below is the hardware configuration.“ OS : Debian 9 (Stretch) CPU : 40 RAM : 220G (Usable) Disk : 3T SSD with 80K sustained IOPS. MySQL : 5.6.43-84.3-log Percona Server (GPL) Datasize : 2.2TB Below is ... Read More

Feed: Planet MySQL; Author: Severalnines; April 2018 is not just a date for the MySQL world. MySQL 8.0 was released there, and more than 1 year after, it’s probably time to consider migrating to this new version. MySQL 8.0 has important performance and security improvements, and, as in all migration to a new database version, there are several things to take into account before going into production to avoid hard issues like data loss, excessive downtime, or even a rollback during the migration task. In this blog, we’ll mention some of the new MySQL 8.0 features, some deprecated stuff, and ... Read More

Feed: Puppet.com Blog RSS Feed. Author: ; *Editor's note: We invite you to join us at Puppetize PDX this 9-10 October 2019. It's a beginner-friendly event, complete with training opportunities.*So you’re ready to get started with Puppet and you don’t know where to begin. That’s alright, because this blog post is meant to point you in the right direction. My most common recommendation for complete newbies is to check out learn.puppet.com and run through a few of the self-paced learning videos that explain what Puppet is and how it works. Once you’ve gotten the hang of that, the Learning VM ... Read More

Feed: Planet PostgreSQL. One of the great things about PostgreSQL is its reliability: it is very stable and typically “just works.” However, there are certain things that can happen in the environment that PostgreSQL is deployed in that can affect its uptime, such as:The database storage disk fails or some other hardware failure occurs The network on which the database resides becomes unreachable The host operating system becomes unstable and crashes A key database file becomes corrupted A data center is lost There may also be downtime events that are due to the normal case of operations, such as performing ... Read More

Feed: R-bloggers. Author: R Views. [This article was first published on R Views, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. One hundred fifty-two packages made it to CRAN in December. Here are my “Top 40” picks in ten categories: Data, Genomics, Machine Learning, Mathematics, Medicine, Science, Statistics, Time Series, Utilities, and Visualization. Data climate v0.3.0: Provides access to meteorological and hydrological data from OGIMET, University of Wyoming – atmospheric vertical profiling data, ... Read More

Feed: The Connector by Workato. Author: Katharine Marais; Novel fintech like cryptocurrency and blockchain have disrupted and fundamentally reimagined such previously eminent and staid realities such as the government monopoly on currency-creation. As fintech has risen to prominence, an unlikely mascot has emerged to represent the convenience enabled by novel financial technologies; mobile banking ads have portrayed ballerinas paying for goods while performing- logging into Visa or Chase apps from the wings, or hilariously, paying for goods while doing a “grand jete between two grand pianos,” in one tongue-in-cheek commercial by Chase. They portray a shared sentiment: that we are ... Read More