Tag: mysqldump

Feed: Planet MySQL; Author: Severalnines; RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic Compute Cloud (EC2). But RDS is a convenient service, as long as you can live with the instances and configurations that it offers. Amazon RDS currently supports various MySQL and MariaDB versions as well as the, MySQL-compatible Amazon Aurora DB engine. It does support replication, but as you may expect from a predefined web console, there are some limitations. Amazon ... Read More

Feed: Planet MySQL; Author: MinervaDB; MySQL 5.7.8 introduced much improved version of mysqldump, It’s called “mysqlpump”, mysqlpump is much faster than mysqldump with parallel threads capabilities, There are many other compelling reasons for choosing mysqlpump over mysqldump, This blog is about how mysqlpump can be used for good. mysqlpump is relatively a new utility of MySQL and we are confident that Oracle MySQL will invest more to make mysqlpump efficient, we haven’t recommended mysqlpump in production for any of our customers till date, considering several concerns. The following below are mysqlpump features we are really excited about:Supports parallel MySQL logical ... Read More

Feed: Planet MySQL; Author: TwinDB; Simple shell script is bad idea Internet is full of simple shell backup scripts. Every DBA and system administrators (including myself) has written one. Bash is a bad tool for this job and in this post I will explain why. Let’s find out why the need to write anything arises at first place. There is a lot of great backup tools for databases as well as for files. Following Unix paradigm they do one thing and do it well. With tar I can copy files, with mysqldump I can copy MySQL database. But there are other ... Read More

Feed: Planet MySQL; Author: Severalnines; What is ChatOps? Nowadays, we make use of multiple communication channels to manage or receive information from our systems, such as email, chat and applications among others. If we could centralize this in one or just a few different possible applications, and even better, if we could integrate it with tools that we currently use in our organization, we would be able to automate processes, improve our work dynamics and communication, having a clearer picture of the current state of our system. In many companies, Slack or other collaboration tools is becoming the centre and ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; MySQL 8.0 General Availability was announced in April and it comes with a host of new features. The overview about the new features and improvements made in MySQL 8.0 can be found in the following blog. The server can be upgraded by performing either an INPLACE upgrade or LOGICAL upgrade.  The INPLACE upgrade involves shutting down the MySQL 5.7 server, replacing the old binaries with MySQL 8.0 binaries and then starting the MySQL 8.0 server on the old data directory.  The LOGICAL upgrade involves exporting SQL from the MySQL 5.7 version using ... Read More

Feed: Planet MySQL; Author: René Cannaò; Proudly announcing the release of the latest stable release of ProxySQL 1.4.9 as of the 31st of May 2018. ProxySQL is a high performance, high availability, protocol aware proxy for MySQL. Freely usable and accessible according to GPL license and can be downloaded here or using the APT / YUM repos listed in the project's Github WIKI. ProxySQL 1.4.9 includes a number of important improvements and bug fixes including: Added an additional client capability toggle variable for client_multi_statements to configure how proxysql connects to backends (i.e. multi-statement or not) Added feature to load mysql_group_replication_hostgroups ... Read More

Feed: Planet MySQL; Author: The Pythian Group; In a previous post I had mentioned that I was doing a bit of digging into Docker in order to get a better grasp of the technology. Part of that was exploring common administrative tasks. I would venture to say that backups are probably among the most important tasks we take on with database administration, so it’s important to know how to do this for Docker MySQL instances. There is a fair bit of documentation on how to handle this logically (mysqldump / mydumper) as this is a simple task to perform as ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dmitriy Kostiuk | May 18, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.5.60-38.12 on May 18, 2018. Based on MySQL 5.5.60, including all the bug fixes in it, Percona Server for MySQL 5.5.60-38.12 is now the current stable release in the 5.5 series. Percona Server for MySQL is open-source and free. Downloads are available here and from the Percona Software Repositories. Bugs Fixed mysqldump utility with --innodb-optimize-keys option was incorrectly working with foreign keys pointing to the same table, producing ... Read More

Feed: Planet MySQL; Author: Severalnines; In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in the last post, how to make your setup highly available through HAProxy and ProxySQL. So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a ... Read More

Feed: Planet MySQL; Author: Severalnines; How do MySQL tables get corrupted? There are many ways to spoil data files. Often, corruption is due to defects in the underlying platform, which MySQL relies on to store and retrieve data - disk subsystem, controllers, communication channels, drivers, firmware or other hardware faults. Data corruption can also occur if the MySQL server daemon restarts suddenly, or your server reboots due to a crash of other OS components. If the database instance was in the middle of writing data to disk, it could write the data partially which may end up with a page ... Read More