Tag: backup

Feed: What's New. Amazon EFS provides a simple, scalable, elastic file system for Linux-based workloads for use with AWS Cloud services and on-premises resources. Customers can now use EFS IA to more cost-effectively store larger amounts of data in their file systems, expanding their ability to use Amazon EFS to an even wider set of applications. EFS IA reduces storage costs for files not accessed every day, with savings up to 85% compared to the EFS Standard storage class. With EFS IA, customers can now easily and cost-effectively store and access all their files in a file system, eliminating the ... Read More

Feed: Planet MySQL; Author: Severalnines; Since the concept of cloud was born, there has been strong growth in the number of migrations to this environment. However, not everything that shines is gold. As the demand grows, so does the costs. We can find ourselves in a situation where our monthly cloud expenses are very high and, in this case, it may make sense to migrate back to an on-prem environment. The costs may not be the only reason. There might be security or compliance requirements, or we may need to have more control of our systems. Knowing what happens at ... Read More

Feed: Planet MySQL; Author: Severalnines; How to Monitor MySQL Databases? Operational visibility is a must in any production environment. It is crucial to be able to identify any issues as soon as possible, otherwise you may end up in serious troubles as an undetected issue can cause serious service disruption or downtime. MySQL Enterprise Monitor is one of the oldest monitoring products for MySQL on the market, and is available as part of an commercial enterprise subscription agreement from Oracle.In this blog post we will take a look at MySQL Enterprise Monitor and the kind of insight it provides into ... Read More

Feed: Planet MySQL; Author: Ankit Kumar; In my previous post I have explain how we are running maxwell as service in Ubuntu. Now in this post I will be explaining how we achieved HA for Backend Instances (MySQL Hosts), Maxwell was using to read binlog. So the stack we have introduced to achieve high availability contains HAProxy (http://www.haproxy.org/) and GTID enabled slaves. HAProxy is a free, very fast and reliable solution offering high availability, load balancing, and proxying for TCP and HTTP-based applications. We have installed HAProxy on the local machine where we are running Maxwell and configured maxwell to ... Read More

Feed: Planet MySQL; Author: Severalnines; The introduction of DevOps in organizations has changed the development process and also introduced some new challenges. In addition, developers and DevOps teams, along with their own chosen programming languages, also have their favorite database systems. The product life cycle is getting shorter each year so developers want to be able to develop fast, using technologies they know best. Having multiple RDBMS database backends means your organization will become more agile on the development side, but it also imposes additional knowledge on the operation teams. Extending your infrastructure from one to many databases implies you ... Read More

Feed: SAS Blogs. Author: Scott McCauley. Multi-tenancy is one of the exciting new capabilities of SAS Viya. Because it is so new, there is quite a lot of misinformation going around about it. I would like to offer you five key things to know about multi-tenancy before implementing a project using this new paradigm. All tenants share one SAS Viya deployment Just as apartment units exist within a larger, common building, all tenants, including the provider, exist within one, single SAS Viya deployment. Tenants share some SAS Viya resources such as the physical machines, most microservices, and possibly the SAS ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Recently, I had to work on an emergency for a customer who was having a problem restarting a MariaDB Galera Cluster. After a failure in the cluster they decided to restart the cluster entirely following the right path: bootstrapping the first node, and then adding the rest of the members, one by one. Everything went fine until one of the nodes rejected the request to join the cluster. Given this problem, the customer decided to ask us to help with the problematic node because none of the tests they did worked, ... Read More

Feed: Microsoft Azure Blog. Author: Rob Caron. Now in preview Account failover now in public preview for Azure Storage If you want to control storage account failover so that you can determine when storage account write access is required and the secondary replication state is understood, account failover for geo-redundant storage (GRS) enabled storage accounts is now available in preview. If the primary region for your geo-redundant storage account becomes unavailable for an extended period of time, you can force an account failover. As is the case with most previews, account failover should not be used with production workloads. There ... Read More

Feed: Planet PostgreSQL. 15:44 11 February 2019A feature of PostgreSQL that most people don’t even know exists is the ability to export and import transaction snapshots. The documentation is accurate, but it doesn’t really describe why one might want to do such a thing. First, what is a “snapshot”? You can think of a snapshot as the current set of committed tuples in the database, a consistent view of the database. When you start a transaction and set it to REPEATABLE READ mode, the snapshot remains consistent throughout the transaction, even if other sessions commit transactions. (In the default transaction ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; PREVIOUS POST In one of my previous posts, I started a series on data compression options with MySQL. The first post focused on the more traditional compression options like InnoDB Barracuda page compression and MyISAM packing. With this second part, I’ll discuss a newer compression option, InnoDB transparent page compression with punch holes available since 5.7. First, I’ll describe the transparent page compression method and how it works. Then I’ll present similar results as in the first post. InnoDB transparent page compression Before we can discuss transparent page compression, we must understand how InnoDB ... Read More