Tag: PostgreSQL

Feed: Planet MySQL; Author: Severalnines; Graphs are important, as they are your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, these are built on top of the metric sampling done by the controller. Those are designed to give you, at first glance, as much information as possible about the state of your database cluster. You might have your own set of metrics you’d like to monitor though. Therefore ClusterControl allows you to customize the graphs available in the cluster overview section and in the Nodes -> DB Performance tab. Multiple metrics ... Read More

Feed: Planet PostgreSQL. Graphs are important, as they are your window onto your monitored systems. ClusterControl comes with a predefined set of graphs for you to analyze, these are built on top of the metric sampling done by the controller. Those are designed to give you, at first glance, as much information as possible about the state of your database cluster. You might have your own set of metrics you’d like to monitor though. Therefore ClusterControl allows you to customize the graphs available in the cluster overview section and in the Nodes -> DB Performance tab. Multiple metrics can be ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous two blog posts we covered both deploying the four types of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL) and managing/monitoring your existing databases and clusters. So, after reading these two first blog posts you were able to add your 20 existing replication setups to ClusterControl, expand them and additionally deployed two new Galera clusters while doing a ton of other things. Or maybe you deployed MongoDB and/or PostgreSQL systems. So now, how do you keep them healthy? That’s exactly what this blog post is about: how to leverage ClusterControl performance monitoring and ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | September 14, 2018 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This week wraps up the London MySQL meetup, where there were four presentations, for the intimate yet diverse crowd. We saw representation from Oracle MySQL, MariaDB Corporation, Pythian, and Percona. Long-time organizer Ivan Zoratti has also handed off the baton to Maria Luisa Raviol, and going forward she will ensure meetups are at least once per quarter. It was a ... Read More

Feed: What's New. With this update, the ip4r extension has been updated to version 2.1.1, the pgaudit extension has been updated to version 1.1.1, the pg_repack has been updated to version 1.4.3, and the plv8 extension has been updated to version 2.1.2. See the documentation for more information. To use the new versions, you can create a new Amazon Aurora database instance with just a few clicks in the Amazon RDS Management Console, or upgrade an existing instance using a point-and-click upgrade. An upgrade operation involves a short period of unavailability for your database instance. Learn more about upgrading your ... Read More

Feed: Planet PostgreSQL. Introduction Nowadays, high availability is a requirement for many systems, no matter what technology we use. This is especially important for databases, as they store data that applications rely upon. There are different ways to replicate data across multiple servers, and failover traffic when e.g. a primary server stops responding. Architecture There are several architectures for PostgreSQL high availability, but the basic ones would be master-slave and master-master architectures. Master-Slave This may be the most basic HA architecture we can setup, and often times, the more easy to set and maintain. It is based on one master ... Read More

Feed: Planet PostgreSQL. Database security is an increasingly critical topic for any business handling personal data. Data breach can have serious ramifications for an organization, especially if the proper security protocols are not in place. There are many ways to harden your database. As an example PostgreSQL addresses security using firewalls, encryption and authentication levels among other ways. 2ndQuadrant hosted a webinar on Database Security in PostgreSQL to highlight security concepts, features and architecture. The webinar was presented by Kirk Roybal, Principal Consultant at 2ndQuadrant – the recording is now available here. Some of the questions that Kirk responded to are listed ... Read More

Feed: Planet PostgreSQL. September 11, 2018PostgreSQL pgsocket is an extension for PostgreSQL server to send bytes to remote TCP/IP socket server. For the first version only single function provided for one way data send in bytearray. This extension is compiled in Linux against PostgreSQL version 10. Download source code from https://github.com/AbdulYadi/pgsocket. Build in Linux as usual: $ make clean $ make $ make install On successful compilation, install this extension in PostgreSQL environment $ create extension pgsocket Let us send bytes to –for example– host with IP address nnn.nnn.nnn.nnn, port 9090, send time out 30 seconds, messages “Hello” $ select ... Read More

Feed: R-bloggers. Author: Tony Hirst. Over the last couple of days, I’ve been fettling the build scripts for the TM351 VM, which typically uses vagrant to build a VirtualBox VM from a set of shell scripts, so they can be used to build a single Docker container that runs all the TM351 services, specifically Jupyter notebooks, OpenRefine, PostgreSQL and MongoDB. Docker containers are typically constructed to a run a single service, with compositions of containers wired together using Docker Compose to create applications that deliver, or rely on, more than one running service. For example, in a previous post (Setting up ... Read More

Feed: Planet PostgreSQL. Avinash Vallarapu | September 7, 2018 |  Posted In: High-availability, PostgreSQL, Replication PREVIOUS POST Configuring replication between two databases is considered to be a best strategy towards achieving high availability during disasters and provides fault tolerance against unexpected failures. PostgreSQL satisfies this requirement through streaming replication. We shall talk about another option called logical replication and logical decoding in our future blog post. Streaming replication works on log shipping. Every transaction in postgres is written to a transaction log called WAL (write-ahead log) to achieve durability. A slave uses these WAL segments to continuously replicate changes from its master. There ... Read More