Showing entries 6646 to 6655 of 44041
« 10 Newer Entries | 10 Older Entries »
MySQL InnoDB Cluster – Real-World Cluster Tutorial for Ubuntu and Debian

In this tutorial, we are going to guide you through the whole process of configuring Debian based distributions for InnoDB cluster usage; the most popular being Ubuntu. We will address the steps from the initial configurations, to the cluster creation, and finally the MySQL Router configuration to map the data traffic.…

MySQL InnoDB Cluster – Preparing a Linux VM for a Real-World Cluster

In this tutorial, we are going to guide you through the process of preparing and configuring an Ubuntu mini host for InnoDB cluster usage.

To create a cluster with tolerance to one failure, we need three instances. So we’re going to create and configure a Virtual Machine and clone it two times.…

MySQL InnoDB Cluster – Setting up a Real-World Cluster

Nowadays, it’s very important to have a high availability solution that gives you serenity and security for your data. The task of ensuring your data will always be available is a challenging one, that not everyone wants to do because it demands a lot of knowledge about tools, configuration, and technologies.…

MySQL InnoDB Cluster – What’s New in the Release Candidate

We carefully listened to the feedback we got from the last preview release and incorporated many of the suggested changes. On top of that, we have fixed several bugs and extended existing functionalities.

Here are the highlights of this release!

MySQL Shell / X AdminAPI

We keep aiming at the goal of hiding the complexity associated with configuring and managing H/A setups, but on top of that, we see usability as a great priority.…

MySQL InnoDB Cluster – Release Candidate Discussion

You might already have seen the announcement of the MySQL InnoDB Cluster Release Candidate (RC), available for download from our MySQL APT (Ubuntu, Debian) and YUM (Redhat, OEL, Fedora) repositories and from dev.mysql.com. As usual, this releases contains the following three components.…

Dropping the Foreign Key Constraint Using pt-online-schema-change

In this blog post, we’ll look at how to get rid of the unused Foreign Key (FK) constraint and/or related columns/keys with the help of pt-online-schema-change and the power of its plugins.

Before we proceed, here is a useful blog post written by Peter Zaitsev on Hijacking Innodb Foreign Keys.

If you are trying to get rid of an unused foreign key (FK) constraint and related columns from versions older than MySQL 5.6, or tables that cannot be executed with

ALTER TABLE ... ALGORITHM=INPLACE

 because of limitations mentioned here (specifically, …

[Read more]
An Insider’s View of MySQL Group Replication—Now Available in Oracle MySQL Cloud Service!

MySQL is the #1 open source database. Because of MySQL’s highperformance, scalability, and availability, it has been widely popular for Webapplications and has become the foundation for IT platforms that supporthigh-traffic social media portals, e-commerce applications, and fast-growingorganizations. As business models and technology requirements are beingtransformed in all industries, more and more companies are embracing andleveraging the cloud platform to enjoy the benefits of flexibility, agility andcost-savings. Available in Oracle Cloud, the Oracle MySQL Cloud Serviceprovides an enterprise-grade MySQL database service to rapidly, securely, andcost-effectively deliver modern applications. With the latest MySQL 5.7.17 updaterelease, MySQL Group Replication is now available in Oracle MySQL Cloud Serviceand offers native, built-in high availability for MySQL databases.

To gain deeper insight into the benefits and use cases ofMySQL …

[Read more]
MySQL Replication: All the Severalnines Resources

MySQL Replication has become an instrumental part of scale-out architectures in LAMP environments. MySQL offers plenty of solutions when there is a need to scale out, the most common being to add read replicas.

Building a database HA stack for production can be daunting. It is not just about setting up replication between a master and some slave servers, it’s also about how to restore broken topologies and fail-over, how applications can keep track of the writable master and the read-only slaves, what to do when servers are corrupted, how to perform backups, and more.

We’ve produced a number of resources aimed at helping users to get started with MySQL Replication or to get more out of their existing setups.

The White Papers The MySQL© Replication Blueprint

This is a great resource for anyone wanting to build or optimise a MySQL replication setup. The MySQL Replication Blueprint is about having a complete …

[Read more]
MySQL Connector/C++ 2.0.4 m2 has been released

MySQL Connector/C++ 2.0.4 is the next development milestone of the MySQL

Connector/C++ 2.0 series. Connector/C++ 2.0 can be used to access MySQL
implementing Document Store or in a traditional way, using SQL queries. It
allows writing both C++ applications using X DevAPI or plain C applications
using XAPI.

To learn more about how to write applications using X DevAPI, see X
DevAPI User Guide (http://dev.mysql.com/doc/x-devapi-userguide/en/) and X
DevAPI reference at
https://dev.mysql.com/doc/dev/connector-cpp/devapi_ref.html. For more
information about using plain C XAPI see XAPI reference at

[Read more]
Running Percona XtraBackup on Windows … in Docker

In this blog, we’ll look at running Percona XtraBackup on Windows via a Docker container.

The question whether Percona XtraBackup is available for Windows comes up every so often. While we are not planning to provide regular releases for Windows, I decided to share a way to run Percona XtraBackup in a Docker container (especially since Docker support for Windows has become more and more stable).

For this exercise, I created a playground Docker image: perconalab/percona-xtrabackup.

First, we need to prepare a few things to make it work:

  1. Install Docker on Windows (the current version I am running is 17.03)
  2. Enable the sharing of disk C in Docker settings
  3. Find out the IP address MySQL is running on …
[Read more]
Showing entries 6646 to 6655 of 44041
« 10 Newer Entries | 10 Older Entries »