Tag: backup

Feed: Planet MySQL; Author: Michael "Monty" Widenus; Last week, Oracle announced the general availability of MySQL 8.0. This is good news for database users, as it means Oracle is still developing MySQL.I decide to celebrate the event by doing a quick test of MySQL 8.0. Here follows a step-by-step description of my first experience with MySQL 8.0. Note that I did the following without reading the release notes, as is what I have done with every MySQL / MariaDB release up to date; In this case it was not the right thing to do.I pulled MySQL 8.0 from ghit@github.com:mysql/mysql-server.git I ... Read More

Feed: Planet MySQL; Author: João Gramacho; MySQL 8.0.11 introduced a new performance schema table named log_status, which provides consistent information about MySQL server instance log positions from replication and transactional storage engines. Used in conjunction with other MySQL 8.0 feature (the backup lock), this new feature will allow backup tools to take backup with minimal impact in DML throughput, but ensuring consistent snapshot with respect to GTIDs, replication, binary logs and transactional storage engine logs. Backup with minimal impact in DML throughput MySQL 8.0.3 introduced a new type of backup lock that permits DML during an on-line backup while preventing ... Read More

Feed: Planet MySQL; Author: Serge Frezefond; Oracle MySQL 8.0 has been declared GA but a critical piece is missing …MySQL 8 is a fantastic release embedding the work of brilliant Oracle engineering.I will not detail all the great features of MySQL 8 as there are a lot of great presentations around it. https://mysqlserverteam.com/whats-new-in-mysql-8-0-generally-available/ One of my main concern regarding MySQL 8 is that it comes without an online backup solution. You only have access to online backup through MySQL Enterprise Backup that you get with a MySQL Enterprise Edition subscription. This is 5000 USD per server per year.So if you ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. The SQL Server team is excited to bring you the second service pack release for SQL Server 2016. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2016 deployments. SQL Server 2016 Service Pack 2 (“SP2”) contains a roll-up of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability ... Read More

Feed: Planet MySQL; Author: João Gramacho; MySQL 8.0.2 introduced a small yet powerful per transaction metadata information containing the transaction length in binary logs. MySQL binary logs are being used for many other things than MySQL replication or backup/recovery: replicate to Hadoop; replicate to other databases, such as Oracle; capture data change (CDC) and extract-transform-load (ETL); record change notification for cache invalidation; change tracking for differential backups; etc. A quick search about “binlog” into Github listed entries about projects parsing MySQL binary log event streams in many programming languages: Ruby, PHP, Python, NodeJS, Java, Golang, etc. Identifying that the stream ... Read More

Feed: SQL Server Release Services. Author: Pedro Lopes (PL). The SQL Server team is excited to bring you the second service pack release for SQL Server 2016! The SQL Server 2016 Service Pack 2 (SP2) contains a rollup of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on feedback from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics. It also showcases the SQL Server product team’s commitment to provide continued value into in-market releases. SQL Server 2016 Service Pack 2 includes: Performance ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk  | April 24, 2018 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona XtraBackup PREVIOUS POST Percona announces the GA release of Percona XtraBackup 2.4.11 on April 24, 2018. This release is based on MySQL 5.7.19. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it drives down backup costs while providing unique features ... Read More

Feed: Neo4j Graph Database Platform. Author: Bryce Merkl Sasaki. By Amy Hodler, Analytics Program Manager | April 23, 2018  Graph analytics have value only if you have the skills to use them and if they can quickly provide the insights you need. Therefore, the best graph algorithms are easy to use, fast to execute and produce powerful results.Neo4j includes a growing, open library of high-performance graph algorithms that reveal the hidden patterns and structures in your connected data.In this series on graph algorithms, we’ll discuss the value of graph algorithms and what they can do for you. Last week, we ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Introduction In this post we will explore one approach to MySQL high availability with HAProxy, Consul and Orchestrator.Let’s briefly go over each piece of the puzzle first:– HAProxy is usually installed on the application servers or an intermediate connection layer, and is in charge of connecting the application to the appropriate backend (reader or writer). The most common deployment I’ve seen is to have separate ports for writes (which are routed to the master) and reads (which are load balanced over a pool of slaves).– Orchestrator’s role is to monitor the topology and ... Read More

Feed: Microsoft Azure Blog. Author: Rob Caron. Azure Security News at RSA Conference 2018 Last week, we made several Azure Security announcements in conjunction with RSA Conference 2018 in San Francisco: Introducing Microsoft Azure Sphere: Secure and power the intelligent edge - Microsoft Azure Sphere is a new solution for creating highly-secured, Internet-connected microcontroller (MCU) devices. Azure Sphere includes three components that work together to protect and power devices at the intelligent edge: Azure Sphere certified microcontrollers (MCUs), Azure Sphere OS, and Azure Sphere Security Service. Microsoft Azure Sphere Leadership Vision - Microsoft product and business leaders introduce Azure Sphere, ... Read More