Tag: Database

Feed: R-bloggers. Author: Sean Lopp. [This article was first published on RStudio Blog, 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. RStudio Connect helps data science teams quickly make an impact by enabling themto publicize reports, models, dashboards, and applications created in R andPython with business stakeholders. The 1.8.0 release makes it even easier forteams to start sharing. For Data Scientists, highlights include: Python Support: Improvements that make it easier to share Jupyter ... Read More

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: Chandan Kumar; Introduction Before I talk about installation of MySQL inside docker, it's more important to knowwhat is Docker?- Docker is a tool designed to create , deploy ,and run an application any where. -It allow us to package up application with all requirements such as libraries and other dependencies and ship it all as a PACKAGE.who uses Docker?Developer : Docker enables developer to develop application without spending much time on IT infrastructure.Sysadmin :-Docker enables sysadmin to streamline the software delivery, such as develop and deploy bug fixes and new features without any roadblock. Enterprise :-Docker works in ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune it correctly. This post is a bit long and complex as it goes very deep into some InnoDB internals.InnoDB internally handles flush operations in the background to remove dirty pages from the buffer pool. A dirty page is a page ... 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 PostgreSQL. It’s been exactly half a year since the last major release of the pgwatch2 Open Source PostgreSQL monitoring tool, and I’m glad to announce that another huge set of useful features and improvements have found their way into the pgwatch2 code repository! The new version is incremented to v1.7 and, continuing the naming tradition, I’m also calling it “Feature Pack 6” as it’s mostly about new features mixed with some bugfixes, although it’s been surprisingly error-free for the last year. Note that listed below are only the most significant changes since last major version, v1.6, so please ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Derek Belt. The AWS Partner Network (APN) is the global partner program for Amazon Web Services (AWS). We enable APN Partners to build, market, and sell their AWS-based offerings, and we help customers identify top APN Partners that can deliver on core business objectives.To receive APN program designations such as AWS Competency, AWS Managed Services Provider (MSP), and AWS Service Delivery, organizations must undergo rigorous technical validation and assessment of their AWS solutions and practices. These designations help customers team up with specialized APN Partners that can provide value-added services and solutions. Guidance from these ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so difficult that the pain far outweighs any technical advantage you might get. In the vast ... Read More