Tag: replication

Feed: IBM Big Data & Analytics Hub - All Content; Author: jessica-lee; Data application resiliency is high on the agenda for CIOs. Gary Brunell from IBM looks at the in-house solution developed by Hotels.com, and how the IBM Big Replicate offering compares. Gary Brunell is a Certified Thought Leader, and a Distinguished IT Specialist at IBM. Gary works with a wide range of clients in the financial services sector, from startups to Fortune 50 companies. Jessica Lee: Hotels.com has developed an intrepid approach to data consistency data management challenges. What’s the story behind its data strategy? Gary Brunell: Hotels.com, an ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | September 18, 2018 |  Posted In: Events and Announcements, High-availability, MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL PREVIOUS POST Percona announces the release of Percona XtraDB Cluster 5.6.41-28.28 (PXC) on September 18, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.41-28.28 is now the current release, based on the following: Fixed Bugs PXC-1017: Memcached API is now disabled if node is acting as a cluster node, because InnoDB Memcached access is not replicated by Galera. PXC-2164: SST script compatibility with SELinux was improved by forcing it ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; In this blog post, we review some of the important aspects of configuring and managing SSL in MySQL hosting. These would include the default configuration, disabling SSL, and enabling and enforcing SSL on a MySQL server. Our observations are based on the community version of MySQL 5.7.21. Default SSL Configuration in MySQL By default, MySQL server always installs and enables SSL configuration. However, it is not enforced that clients connect using SSL. Clients can choose to connect with or without SSL as the server allows both types of connections. Let’s see how to verify this ... 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: Microsoft Azure Blog. Author: Rob Caron. Welcome to Azure DevOps The big news last week was the introduction of Azure DevOps, which represents the evolution of Visual Studio Team Services (VSTS). Azure DevOps is a set of five new services that can be used together as a unified product, independently as stand-alone services or in any combination: Azure Pipelines, Azure Boards, Azure Repos, Azure Test Plans, and Azure Artifacts. Azure Pipelines is a fully-managed CI/CD service that enables developers to continuously build, test, and deploy any type of app, to any platform or cloud, which is available with free, ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Recently our team was tasked to implement MySQL 8.0 in production for a client. While MySQL 8.0 is looking very promising and has a lot of cool new features and revamped old features, it’s still pretty young. The MySQL development team is working very hard on stabilizing the product but, reading the latest release notes for version 8.0.12, it is still very much a bugfix release and not something you will want to put in production immediately. Also, given the fact that a lot of tools such as Percona Xtrabackup do not support ... Read More

Feed: R-bloggers. Author: Achim Zeileis. Boosted binary generalized additive models (GAMs) with stability selection and corresponding MCMC-based credibility intervals are discussed in a new MWR paper as a probabilistic forecasting method for the occurrence of thunderstorms. Citation Thorsten Simon, Peter Fabsic, Georg J. Mayr, Nikolaus Umlauf, Achim Zeileis (2018). “Probabilistic Forecasting of Thunderstorms in the Eastern Alps.” Monthly Weather Review. 146(9), 2999-3009. doi:10.1175/MWR-D-17-0366.1 Abstract A probabilistic forecasting method to predict thunderstorms in the European eastern Alps is developed. A statistical model links lightning occurrence from the ground-based Austrian Lightning Detection and Information System (ALDIS) detection network to a large set ... 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: Blog. Author: Ja2242; Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and application can have a considerable performance impact and take a long time. Consequently, initializing a subscription from a snapshot can be prohibitive.The next logical step in the evolution of replication was to make better use of the backups that were already being applied to the subscribers. Initialization from backup was designed to alleviate some of the problems faced by administrators of VLDBs. However, there are perceived limitations and restrictions regarding initialization from backup for transactional replication, but ... Read More

Feed: Microsoft Azure Blog. Author: Tad Brockway. Media and entertainment industry conferences are by far some of my favorites. Creativity, disruption, opportunity, and technology – particularly cloud, edge, and AI – are everywhere. It’s been exciting to see those things come together at NAB 2018, SIGGRAPH, and now IBC Show 2018. Together with teams from across Microsoft, I’m looking forward to IBC Show and the chance to learn, collaborate, and advance the state of this dynamic industry. At this year’s IBC we’re excited to announce the general availability of Video Indexer, our advanced metadata extraction service. Announced as public preview ... Read More