Tag: mysqldump

Feed: Planet MySQL; Author: Patrick Galbraith; Backing up MySQL on Windows: options? I had a recurring consultation this summer with a client who is running a stand-alone MySQL database with a ton of data and wanted to simply have a backup system for that data. The client is very risk-averse and didn’t want anything too experimental. I knew for a huge database, I didn’t want to run mysqldump on the database on a regular basis if I could avoid it and always prefer using XtraBackup. I haven’t worked on Windows in years, and had assumed there were binaries for XtraBackup, ... Read More

Feed: Planet MySQL; Author: Patrick Galbraith; Backing up MySQL on Windows: options? I had a recurring consultation this summer with a client who is running a stand-alone MySQL database with a ton of data and wanted to simply have a backup system for that data. The client is very risk-averse and didn’t want anything too experimental. I knew for a huge database, I didn’t want to run mysqldump on the database on a regular basis if I could avoid it and always prefer using XtraBackup. I haven’t worked on Windows in years, and had assumed there were binaries for XtraBackup, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB Galera Cluster is MariaDB plus the MySQL-wsrep patch from Codership. It is currently available on Unix platforms only. In MariaDB 5.5 and MariaDB 10.0, MariaDB Galera Server is a separate package installed instead of the standard MariaDB Server package. Since MariaDB 10.1, the MariaDB Server and MariaDB Galera Server packages have been combined and Galera packages and their dependencies get installed automatically when installing MariaDB. The Galera parts remain dormant until configured, like a plugin or storage engine. The most recent release of MariaDB 10.2 is:MariaDB 10.2.8 Stable (GA) Download Now The ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster is a synchronous multi-master replication plugin for InnoDB or XtraDB storage engine. It offers a number of outstanding features that standard MySQL replication doesn’t - read-write to any cluster node, automatic membership control, automatic node joining, parallel replication on row-level, and still keeping the native look and feel of a MySQL server. This plug-in is open-source and developed by Codership as a patch for standard MySQL. Percona and MariaDB leverage the Galera library in Percona XtraDB Cluster (PXC) and MariaDB Server (MariaDB Galera Cluster for pre 10.1) respectively. We often get the question ... Read More

Feed: Planet MySQL; Author: Sveta Smirnova; Sveta Smirnova  | August 23, 2017 |  Posted In: Aurora RDS, Cloud and MySQL, MySQL PREVIOUS POST In this blog post, we’ll discuss migrating data from encrypted Amazon MySQL RDS to encrypted Amazon Aurora. One of my customers wanted to migrate from an encrypted MySQL RDS instance to an encrypted Aurora instance. They have a pretty large database, therefore using mysqldump or a similar tool was not suitable for them. They also wanted to setup replication between old MySQL RDS and new Aurora instances. Spoiler: this is possible without any logical dump. At first, I checked Amazon’s documentation on ... Read More

Feed: Planet MySQL; Author: Sheeri K. Cabral; In the quest to secure MySQL as well as ease the number of complicated passwords to remember, many organizations are looking into external authentication, especially using LDAP. For free and open source, Percona’s PAM authentication plugin is the standard option. tl;dr is I go through how to compile php-cli for use with auth_pam plugin. BackgroundThere are two plugins that can be used. From the documentation, the two plugins are: Full PAM plugin called auth_pam. This plugin uses dialog.so. It fully supports the PAM protocol with arbitrary communication between client and server. Oracle-compatible PAM ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I have to get back to the topic of checking user variables in gdb to clarify few more details. In his commentShane Bester kindly noted that calling functions defined in MySQL code is not going to work when core dump is studied. So, I ended up with a need to check what does the my_hash_element() function I've used really do, to be ready to repeat that step by step manually. Surely I could skip that and use Python and Shane himself did, but structures of HASH type are widely used in MySQL, so I'd ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jervin Real  | August 11, 2017 |  Posted In: MySQL PREVIOUS POST In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7! First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here. I received a number of interesting questions in the webinar that I’ve followed up with below. Would there be a big difference on passing from 5.1 to 5.6 before going to 5.7 or, at this point, would it be roughly the same? The biggest ... Read More

Feed: Planet MySQL; Author: Severalnines; MySQL is easy to install and use, it has always been popular with developers and system administrators. On the other hand, deploying a production-ready MySQL environment for a business-critical enterprise workload is a different story. It can be a bit of a challenge, and requires in-depth knowledge of the database. In this blog post, we’ll discuss some of the steps which have to be taken before we can consider our MySQL deployment production-ready. High Availability If you belong to those lucky ones who can accept hours of downtime, you can stop reading here and skip ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; More than 3 months after 5.7.18 we' ve got MySQL 5.7.19 released recently. This is my quick review of the release notes with interesting fixed bug (reported in public) highlighted in the areas I am usually interested in.Let's start with InnoDB. The following bug fixes attracted my attention:Bug #85043 is still private. You know how much I hate those. At least we can see it was about the fact that "The server allocated memory unnecessarily for an operation that rebuilt the table." Let's hope this is no longer the case. Bug #84038 - "Errors when ... Read More