Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 56 10 Older Entries

Displaying posts with tag: Percona XtraBackup (reset)

Percona XtraBackup 2.4.0-rc1 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories.

  [Read more...]
Percona XtraBackup 2.3.3 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.3.3 on December 17th, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user …

  [Read more...]
Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)
+0 Vote Up -0Vote Down

Recently, I was working on a MySQL support ticket where a customer was facing an issue while transporting tablespace from MySQL 5.6 to MySQL 5.7.
After closely reviewing the situation, I saw that while importing tablespace they were getting errors such as:

ERROR 1808 (HY000): Schema mismatch (Table flags don't match, server table has 0x10 and the meta-data file has …

  [Read more...]
Percona XtraBackup 2.3.2 GA is now available
+1 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.3.2 GA on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking …

  [Read more...]
Percona XtraBackup 2.2.13 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.2.13 on October 22nd, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups …

  [Read more...]
Percona XtraBackup 2.2.12 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.2.12 on August 3, 2015. Downloads are available from our download site or Percona Software 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 …

  [Read more...]
Percona XtraBackup 2.2.11 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.2.11 on May 28, 2015. Downloads are available from our download site or Percona Software Repositories.

Percona XtraBackup enables MySQL backups without blocking user queries, …

  [Read more...]
Percona XtraBackup 2.3.1-beta1 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona XtraBackup 2.3.1-beta1 on May 20th 2015. Downloads are available from our download site here. This BETA release, will be available in Debian

  [Read more...]
The cost of not properly managing your databases
+0 Vote Up -2Vote Down

Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist. Let’s look at some.

The setup:

Let us start by using a small example. We will start by looking at a small database setup. This setup will have a single master-slave, with a database size of lets say 500GB. Traffic is steady and let’s say this translates into 500 IOPS on the master. You have chosen …

  [Read more...]
Illustrating Primary Key models in InnoDB and their impact on disk usage
+0 Vote Up -0Vote Down

On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows.

The table is INSERT-only (no UPDATEs or DELETEs), and the bulk of their retrieval are PK lookups. Lookups by PK were performing acceptably, but they were concerned with the space usage by the table as we were approaching 1TB (running with innodb_file_per_table=1 and Percona Server 5.5).

This schema model presents an increasing burden for backups since they use …

  [Read more...]
Showing entries 1 to 10 of 56 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.