Tag: replication

Feed: Planet MySQL; Author: MyDBOPS; Introduction             We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic . If you are looking for other articles on our ProxySQL Series : MySQL replication Read-Write Split up Replication Switchover using Proxysql And MHA HA for proxysql with keepalived Mirroring MySQL Queries Handling Resource expensive Queries Percona Cluster/MariaDB cluster(Galera) Read-Write Split. Amazon Aurora (RDS) ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.44, and including all the bug fixes in it, Percona Server for MySQL 5.6.44-85.0 is the current GA release in the Percona Server for MySQL 5.6 series. Percona Server for MySQL is open-source and free – this is the latest release of our enhanced, drop-in replacement for MySQL. New Features: Bugs ... Read More

Feed: R-bloggers. Author: R Views. Phillip (Armand) Bester is a medical scientist, researcher, and lecturer at the Division of Virology, University of the Free State, and National Health Laboratory Service (NHLS), Bloemfontein, South Africa Andrie de Vries is the author of “R for Dummies” and a Solutions Engineer at RStudio Recap In part 2 of this series, we discussed the PhyloPi pipeline for conducting routine HIV phylogenetics in the drug-resistance testing laboratory as a part of quality control. As mentioned, during HIV replication the error-prone viral reverse transcriptase (RT) converts its RNA genome into DNA before it can be integrated ... Read More

Feed: R-bloggers. Author: Achim Zeileis. Personalized treatment effects can be estimated easily with model-based trees and model-based random forests using the R package model4you. Citation Heidi Seibold, Achim Zeileis, Torsten Hothorn (2019). “model4you: An R Package for Personalised Treatment Effect Estimation.” Journal of Open Research Software, 7(17), 1-6. doi:10.5334/jors.219 Abstract Typical models estimating treatment effects assume that the treatment effect is the same for all individuals. Model-based recursive partitioning allows to relax this assumption and to estimate stratified treatment effects (model-based trees) or even personalised treatment effects (model-based forests). With model-based trees one can compute treatment effects for different strata ... Read More

Feed: Blog Post – Corporate – DataStax. Author: Louise Westoby, Senior Director, Product Marketing. Managing the trade-off between consistency and availability is nothing new in distributed databases. It’s such a well-known issue that there is a theorem to describe it. While modern databases don’t tend to fall neatly into categories, the “CAP” theorem (also known as Brewer’s theorem) is still a useful place to start. The CAP theorem states that a database can’t simultaneously guarantee consistency, availability, and partition tolerance. Partition tolerance refers to the idea that a database can continue to run even if network connections between groups of ... Read More

Feed: Planet MySQL; Author: Jan Kneschke; Key features log-rotation via SIGHUP HTTP server plugin flexible support for single/multi-PRIMARY Group Replication Logrotation via SIGHUP Sending a SIGHUP signal to the router process will now close and reopen the logfile. It allows the integration with the logrotate to rotate and compress the Router’s logfiles. HTTP server plugin Support for running a HTTP server inside the mysqlrouter has been added Motivation The HTTP server plugin builds the foundation for features like: Monitoring Management which will appear in the upcoming releases of MySQL Router. In 8.0.16 it already supports: encrypted connections via TLS (up ... Read More

Feed: Microsoft Azure Blog. Author: Parul Matah. This post is part of a 2-part series about how organizations are using Azure Cosmos DB to meet real-world needs, and the difference it’s making for them. In this first post we explore the challenges that led the Microsoft 365 usage analytics team to take action, the architecture of the new solution, and migration of the production workload. In part 2, we’ll examine additional implementation details and the outcomes resulting from the team’s efforts. The challenge: Understanding the behavior of more than 150 million active users Office 365 is a flagship service within ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; To operate more easily a MySQL Group Replication (InnoDB Cluster), the Group Replication plugins provides some UDFs. If you have read the recent article from Tiago Vale about the Group Replication Communication Protocol, you may have heard about two new UDFs allowing to get or set  the communication protocol. So what are all the UDFs provided with the Group Replication and what’s their purpose ? SELECT UDF_NAME FROM performance_schema.user_defined_functions WHERE UDF_NAME LIKE 'group_repl%'; +-------------------------------------------------+ | UDF_NAME | +-------------------------------------------------+ | group_replication_get_communication_protocol | | group_replication_get_write_concurrency | | group_replication_set_as_primary | | group_replication_set_communication_protocol | | group_replication_set_write_concurrency | | ... Read More

Feed: Blog Post – Corporate – DataStax. Author: Nick Panahi, Sr. Product Manager, Server. Securing your data should be top of mind for any modern application. Security breaches are on the rise and the associated penalties are severe, impacting your brand and, in turn, your customer loyalty and trust. Consider the following security practices to protect your data and the distributed system that manages it. These practices apply to distributed system architectures that could include intercloud, hybrid, and/or multi-cloud. They can also be applied to systems with specialized compliance requirements in regulated environments; financial services; payments; health systems/HIPAA in the ... Read More

Feed: Microsoft Azure Blog. Author: Leon Welicki. This month is packed with updates on the Azure portal, including enhancements to the user experience, resource configuration, management tools and more. Sign in to the Azure portal now and see for yourself everything that’s new. Download the Azure mobile app to stay connected to your Azure resources anytime, anywhere. Here’s the list of May updates to the Azure portal: User experience IaaS Storage Management tools Create your first cloud project with confidence Security Center Site Recovery Intune Let’s look at each of these updates in greater detail. User experience Improvements to the ... Read More