Tag: replication

Feed: Planet PostgreSQL. One of the most important things to using PostgreSQL successfully in your development and production environments is simply getting started! One of the most popular ways to install PostgreSQL is by using RPM packages. The PostgreSQL RPM packages work across many Linux distributions, including, RedHat Enterprise Linux (RHEL), CentOS, Fedora, Scientific Linux, and more, and the PostgreSQL community provides installers for these distributions.This guide will help you get started with installing and configuring PostgreSQL for a CentOS / RHEL 7 based system, which will also work for Fedora 29. We will be installing PostgreSQL 11, which is the latest major release ... Read More

Feed: Planet PostgreSQL. Choosing a database isn’t something you do every day. You generally choose it once for a project, then don’t look back. If you experience years of success with your application you one day have to migrate to a new database, but that occurs years down the line. In choosing a database there are a few key things to consider. Here is your checklist, and spoiler alert, Postgres checks out strongly in each of these categories. Does your database solve your problem? There are a lot of new databases that rise up every year, each of these looks ... Read More

Feed: Planet MySQL; Author: Severalnines; ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse. Recently, ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. It is relatively easy to run ProxySQL as Docker container. We have previously written about how to run ProxySQL on Kubernetes as a helper container or as a Kubernetes service, which is based on ProxySQL 1.x. In this blog post, we are going to use the new version ProxySQL 2.x which uses a different ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; I remember wanting to create MySQL Cluster sandboxes several years ago. By then, however, MySQL-Sandbox technology was not flexible enough to allow an easy inclusion, and the cluster software itself was not as easy to install as it is today. Thus, I kept postponing the implementation, until I started working with dbdeployer.I included the skeleton of support for MySQL Cluster since the beginning (by keeping a range of ports dedicated for this technology, but I didn’t do anything until June 2018, when I made public my intentions to add support for NDB in dbdeployer ... Read More

Feed: Planet PostgreSQL. Business Continuity for Databases Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even during the disasters, otherwise, could end-up being an expensive deal. DBAs, Architects would need to ensure that database environments can sustain disasters and are disaster recovery SLA compliant. To ensure disasters does not affect database availability, databases must be configured for business continuity. Configuring databases for business continuity involves a lot of architecting, planning, designing and testing. A lot of factors like ... Read More

Feed: Microsoft Azure Blog. Author: Rob Caron. Now in preview AzCopy support in Azure Storage Explorer now available in public preview AzCopy in Azure Storage Explorer is now in public preview. AzCopy is a popular command-line utility that provides performant data transfer into and out of a storage account. AzCopy enhances the performance and reliability through a scalable design, where concurrency is scaled up according to the number of machine’s logical cores. Azure Storage Explorer provides the UI interface for various storage tasks, and now it supports using AzCopy as a transfer engine to provide the highest throughput for transferring ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Mariabackup creates the following files: backup-my.cnf During the backup, any server options relevant to Mariabackup are written to this file, so that they can be re-read later during the --prepare stage. ib_logfile0 In the non-prepared backup, ib_logfile0 contains all of the InnoDB redo log copied during the backup. During the --prepare stage, ib_logfile0 is initialized as an empty InnoDB redo log file. See Mariabackup Overview: Redo Log Files for more information. xtrabackup_binlog_info This file stores the binary log coordinates and the gtid_current_pos value that correspond to the backup. The positions in this ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 8.0.15-5 on March 15, 2019 (downloads are available here and from the Percona Software Repositories). This release includes fixes to bugs found in previous releases of Percona Server for MySQL 8.0. Incompatible changes In previous releases, the audit log used to produce time stamps inconsistent with the ISO 8601 standard. Release 8.0.15-5 of Percona Server for MySQL solves this problem. This change, however, may break programs that rely on the old time stamp format. Starting from release 8.0.15-5, Percona Server for MySQL uses the upstream implementation of binary log encryption. The variable encrypt_binlog is removed and the ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; PREVIOUS POST Just about a month ago, Pavel Ivanov released Ripple under the Apache-2.0 license. Ripple is a MySQL binlog server: software which receives binary logs from MySQL or MariaDB servers and delivers them to another MySQL or MariaDB server. Practically ,this is an intermediary master which does not store any data, except the binary logs themselves, and does not apply events. This solution allows saving of a lot of resources on the server, which acts only as a middle-man between the master and its actual slave(s). The intermediary server, keeping binary logs only ... Read More

Feed: Planet PostgreSQL. In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics and other critical business operations needs. DBAs also need to ensure that the data is replicated continuously to the remote sites to meet various requirements. These requirements, though, may not always be to replicate the whole database; there can also be a need to replicate only a subset of the data (like a Table or set of Tables or data from multiple ... Read More