Tag: high availability

Feed: Planet MySQL; Author: MySQL High Availability; We are happy to share with you that the mysqlbinlog tool has been enhanced. Starting on 8.0.17, the user can instruct the mysqlbinlog tool to negotiate, with the server that it connects to, whether to use protocol compression or not. Since MySQL 5.6, the mysqlbinlog tool can connect to a remote server and act as a slave. This means that the tool can stream the binary log directly from a remote server. Then it can decode and print its content or just save it locally as if they were a raw copies of ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; As announced in the previous blog post, MySQL InnoDB Cluster just got a very much requested feature which makes a complete, out-of-the-box, easy-to-use and versatile HA solution – Automatic Node Provisioning. InnoDB cluster users can now rely on it for every single step of cluster deployment and management. From instance configuration to provisioning, to cluster set up and its monitoring. By using the MySQL Shell and its AdminAPI, every step becomes easily accessible within the same place with a complete set of powerful yet simple commands. The screencast shown previously demonstrates how effortless and ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; With the release of version 8.0.17 of MySQL, we bring to you the brand new Clone plugin. Allowing you to get physical snapshots of data stored in InnoDB, this new plugin is an ideal addition to your Group Replication setup. When joining a new server into a running replication group, a manual offline provisioning procedure was required in most cases as a tool to execute this step in the context of distributed recovery was missing. With this new plugin group replication distributed recovery can now handle that step online and automatically for the ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Shell 8.0.17 is a maintenance release of MySQL Shell 8.0 Series (a component of the MySQL Server). The MySQL Shell is provided under Oracle’s dual-license. MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Shell 8.0.17. MySQL Shell is an interactive JavaScript, Python and SQL console interface, supporting development and administration for the MySQL Server. It provides APIs implemented in JavaScript and Python that enable you to work with MySQL InnoDB cluster and use MySQL as a document store. The AdminAPI enables ... Read More

Feed: Microsoft Azure Blog. Author: David Auslander. Microsoft Azure is rapidly becoming the public cloud of choice for large financial services enterprises. Some of the biggest reasons Global Financial Services Institutions (GFIs) are choosing Azure to augment or replace on-premises application environments are: The high level of security that the Azure cloud provides. The exceptional control enterprises can have over compliance and security within their subscriptions. The many features that Azure has for data governance and protection. The long list of Global Regulatory Standards that the Azure cloud is compliant with. Please see the Microsoft Trust Center for more information ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; The MySQL Development Team is very excited and proud of what was achieved in this 8.0.17 GA release! The spotlight is on… A game-changer feature – Automatic Node provisioning! This has been an extremely desired and important feature, and it has been accomplished, once again, with tight integration and cooperation of MySQL Components: The new MySQL Clone Plugin: To take a physical snapshot of the database and transfer it over the network to provision a server, all integrated into the server, using regular MySQL connections. Group Replication: To integrate the Clone Plugin on the ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; MySQL 8.0.17 is out. In addition to fixing a few bugs here and there, we also have a couple of new replication features that I would like to present. Thence, allow me to give you a quick summary. As usual, there shall be follow-up blog posts providing details, so stay tuned. List of replication features in MySQL 8.0.17: Enhanced Group Replication distributed recovery with automated instance cloning. The bulk of the work was a joint venture between Debarun Banerjee (who has done a great job implementing the core building block – the clone ... Read More

Feed: Planet PostgreSQL. Hi. My name is Konstantin Evteev, I’m a DBA Unit Leader of Avito. Avito is the biggest Russian classified site, and the second largest classified site in the world (after Craigslist of USA). Items offered for sale on Avito can be brand new or used. The website also publishes job vacancies and CVs.Via its web and mobile apps, the platform monthly serves more than 35 million users. They add approximately a million new ads a day and close over 100,000 transactions per day. The back office has accumulated more than a billion ads. According to Yandex, in ... Read More

Feed: Liquid Web. Author: Todd Terwillegar; Cloud computing has been a major leap forward for public applications, but it can also offer the same advantages for private infrastructure. Your business can switch to VMware private cloud and see improved elasticity, scalability, and performance.“The public cloud has a growth rate of 56%. It’s booming.”But the private cloud is also growing strong at 28%. It doesn’t grab the same headlines as consumers moving their music and documents to the cloud, but it can still have a big impact on your bottom line.Liquid Web has a public cloud solution, but we’ve also rolled ... Read More

Feed: Planet PostgreSQL. Nowadays, it’s common to see a large amount of data in a company’s database, but depending on the size, it could be hard to manage and the performance could be affected during high traffic if we don’t configure or implement it in a correct way. In general, if we have a huge database and we want to have a low response time, we’ll want to scale it. PostgreSQL is not the exception to this point. There are many approaches available to scale PostgreSQL, but first, let’s learn what scaling is. Scalability is the property of a system/database ... Read More