Tag: backup

Feed: What's New. AWS Storage Gateway enables hybrid cloud storage. It connects on-premises applications to AWS storage services, and provides low-latency data access through local caching. You can use the service for backup, archiving and disaster recovery, tiering data to the cloud, application file storage, and data processing workflows. AWS Storage Gateway uses standard storage protocols (NFS, SMB, iSCSI, and iSCSI-VTL), so your applications can store files, block volumes, snapshots, and virtual tape backups in AWS ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jericho Rivera | September 17, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security PREVIOUS POST This is the first of a two-part series on using the keyring_vault plugin with Percona Server for MySQL 5.7. The second part will walk you through on how to use Percona Xtrabackup to backup from this instance and restore to another server and set it up as a slave with keyring_vault plugin. What is the keyring_vault plugin? The keyring_vault is a plugin that allows the database to interface with a Hashicorp Vault server to store and secure encryption keys ... 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: 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: What's New. Currently, AWS CloudHSM automatically takes daily backups of active clusters. A backup is also automatically taken when you add an HSM to a cluster. So, you must delete all existing backups of your CloudHSM cluster if you want to intentionally and permanently delete cryptographic material such as an expired key or deleted HSM user. Otherwise, deleted information can be resurrected by initializing a new cluster using an old backup. Backup deletion and restoration will be reflected in your CloudTrail. There is no charge for deleting backups. A backup must be in Ready state to be eligible for ... Read More

Feed: Cloudwards. Author: Branko Vlajin; If you live in North America, chances are you’d like to store your files somewhere U.S. agencies can’t get to them. Canada is a prime candidate for that, as it doesn’t have laws, such as the USA Patriot Act, CLOUD or PRISM, that allow the government to look at your data. In this article, we’ve selected the best cloud storage for Canada, with Sync.com taking the top spot. Canada’s government is scrambling to update its laws to match EU’s General Data Protection Regulation and keep the right to free data transfer. That’s great news for ... Read More

Feed: Microsoft Azure Blog. Author: Omar Khan. There’s a lot you can do with Azure. But whether you’re modernizing your IT environment, building next-generation apps, harnessing the power of artificial intelligence, or deploying any of a million other solutions, there are foundational habits that can help you succeed. On the Azure team, we spend a lot of time listening to our customers and understanding what makes them successful. We’ve started to compile a handful of routine activities that can help you get the most out of Azure. Stay on top of proven practice recommendations Highly effective Azure users understand that ... Read More

Feed: Planet MySQL; Author: Severalnines; Deploying a database cluster is not rocket science - there are many how-to’s on how to do that. But how do you know what you just deployed is production-ready? Manual deployments can also be tedious and repetitive. Depending on the number of nodes in the cluster, the deployment steps may be time-consuming and error-prone. Configuration management tools like Puppet, Chef and Ansible are popular in deploying infrastructure, but for stateful database clusters, you need to perform significant scripting to handle deployment of the whole database HA stack. Moreover, the chosen template/module/cookbook/role has to be meticulously ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; David Bennett | September 12, 2018 |  Posted In: Backups, InnoDB, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraBackup PREVIOUS POST Experimental Build of Percona XtraBackup 8.0 released An experimental alpha version of Percona XtraBackup 8.0.1 is now available in the Percona experimental software repositories. A few things to note about this release: We removed the deprecated innobackupex in this release Due to the new MySQL redo log and data dictionary formats the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and the upcoming Percona Server for MySQL 8.0.x For experimental migrations from ... Read More

Feed: Planet MySQL; Author: Mikael Ronström; Non-blocking 2PC protocolMany of the new DBMSs developed in the last 10 years have abandoned the two-phase commit protocol and instead relied on replication protocols.One of the main reasons for this has been the notion that two-phase commit protocol is a blocking protocol. This is true for the classic version of the two-phase commit protocol.When NDB Cluster was developed in the 1990s we had requirements that the replication protocol could not be blocking. A competitor at the time, ClustRa, solved this by using a backup transaction coordinator. Given that NDB Cluster had requirements to ... Read More