Author: MySQL Planet

Feed: Planet MySQL; Author: MySQL Performance Blog; In the last blog post of this series, we discussed in detail how Master Key encryption works. In this post, based on what we already know about Master Key encryption, we look into how Master Key rotation works.The idea behind Master Key rotation is that we want to generate a new Master Key and use this new Master Key to re-encrypt the tablespace key (stored in tablespace’s header).Let’s remind ourselves what a Master Key encryption header looks like (it is located in tablespace’s header):From the previous blog post, we know that when a ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This talk covers some of the challenges we sought to address by creating a Kubernetes Operator for Percona XtraDB Cluster, as well as a look into the current state of the Operator, a brief demonstration of its capabilities, and a preview of the roadmap for the remainder of the year. Find out how you can deploy a 3-node PXC cluster in under five minutes and handle providing self-service databases on the cloud in a cloud-vendor agnostic way. You’ll have the opportunity to ask the Product Manager questions and provide feedback on what challenges ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; This post serves as a pointer to my previous announcement about The state of Orchestrator, 2020. Thank you to Tom Krouper who applied his operational engineer expertise to content publishing problems ... Read More

Feed: Planet MySQL; Author: Sri Sakthivel Durai Pandian; We are well aware that ProxySQL is one of the powerful SQL aware proxy for MySQL. The ProxySQL configuration is flexible and the maximum part of configurations can be done with the ProxySQL client itself. The latest ProxySQL release ( 2.0.9 ) has few impressive features like “SQL injection engine, Firewall whitelist, Config file generate” . In this blog I am going to explain, how to generate the ProxySQL config file using the proxySQL client . Why configuration file ? Backup solutionHelpful for Ansible deployments in multipul environments There are two important commands involved ... Read More

Feed: Planet MySQL; Author: Chandan Kumar; How to Deploy MySQL InnoDB Replica Set in Production? Before i talk about Deployment process of MySQL InnoDB Replica Set , it is more important to know below details:- What is MySQL InnoDB Replica Set? What is prerequisite and limitation of using MySQL Replica Set?  In what kind of scenarios MySQL Replica Set is not recommended.  How to configure and deploy MySQL Replica Set- (step by step guide ) How to use InnoDB Replica Set? What if Primary goes down? Does select query re-routed to another server? What if Secondary goes down while executing ... Read More

Feed: Planet MySQL; Author: Ivan Ma; This article is written to share how to setup SSL Replication between MySQL InnoDB Cluster and Slave single node via MySQL Router.It is for Demo Purpose ONLY.The video below shows the Replication working between Primary Node failover in the MySQL InnoDB Cluster.   The Replication switches to another Primary Node via the MySQL Router.The General Steps as follows : Setup as follows (Demo only) Virtual Machine 1 1. A working MySQL InnoDB ClusterVirutal Machine 2 2. A working MySQL Node as Slave 3. A working MySQL Router setup on Slave Node to point to the ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy. The monitoring program or script must alert the high availability framework in case any of the health checks fails, enabling the high availability framework to take corrective actions in order to ensure service availability. MySQL Master Server ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In this post, I am going to show you how to run Orchestrator on FreeBSD. The instructions have been tested in FreeBSD 11.3 but the general steps should apply to other versions as well.At the time of this writing, Orchestrator doesn’t provide FreeBSD binaries, so we will need to compile it.Preparing the EnvironmentThe first step is to install the prerequisites. Let’s start by installing git: [vagrant@freebsd ~]$ sudo pkg update Updating FreeBSD repository catalogue... Fetching meta.txz: 100% 944 B 0.9kB/s 00:01 Fetching packagesite.txz: 100% 6 MiB 492.3kB/s 00:13 Processing entries: 100% FreeBSD repository ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; February 17, 2020 Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020. Agenda InnoDB ReplicaSet SQL Improvements Table Value ConstructorsLIMIT in recursive CTEALTER TABLE… DROP/ALTER CONSTRAINTMore information to Duplicate Key Error Account Management Enhancements Time zone offset for Timestamp & Datetime Information Schema views for SQL Roles MySQL Document Store Enhancements MySQL Shell Enhancements MySQL Router Enhancements MySQL InnoDB Cluster Enhancements MySQL Replication Enhancements MySQL NDB Cluster Enhancements MySQL Enterprise New Features Thanks to the Contributors Download this presentation and others on my SlideShare account. Thanks for using MySQL! ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; Creating a MySQL NDB Cluster is really easy when using MySQL Cluster Manager aka "MCM". In this blog post we will look at how to install and configure MCM and then create a new cluster using MCM commands.Steps to install and and setup MCM as a service is explained here.Once you have completed the setup of MCM next step is to install MySQL NDB Cluster. First step is to download latest Cluster 7.6 binaries from: https://dev.mysql.com/downloads/cluster/ (7.6.13 as of today)cd /tmp wget https://dev.mysql.com/get/Downloads/MySQL-Cluster-7.6/mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64.tar.gz cd /opt tar xzf /tmp/mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64.tar.gz mv mysql-cluster-gpl-7.6.13-linux-glibc2.12-x86_64 mysql-cluster-7.6.13 Now it's time ... Read More