In the following we show how InnoDB cluster can be deployed in a container context. In the official documentation (Introducing InnoDB Cluster), InnoDB is described as: MySQL InnoDB cluster provides a complete high availability solution for MySQL. MySQL Shell includes AdminAPI which enables you to easily configure and administer a group of at least three […]
Mar
22
2018
Mar
21
2018
In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node.
SST will happen for one or more reasons listed below.
- Initial sync to join a node to cluster.
- Node is out of cluster and lost its ability to join back due to data corruption or inconsistencies and also when the node went far behind the node, …
Jan
25
2018
Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- Here are the steps for how to do that. I assumes that you already have working 3 nodes galera cluster if not, then for the testing purpose you can create it from my previous post. setup-three-nodes-mariadb-galera-cluster-on-single-server-with-mysql-sandbox ———- Btw, there is no matter how many nodes you have. Now, create one test1 table and add 3 records in galera cluster.
MariaDB [nil]> select * from test1; +------+-----------+ | id | name | +------+-----------+ | 1 | nilnandan | | 2 | joshi | | 3 | niljoshi | +------+-----------+ …[Read more]
Jan
24
2018
As Mydbops we are implementing Load Balancer using Maxscale or ProxySQL ( Our presentation ) for lot our client, but these load balancers will become a SPOF (Single Point of failure) . We have tried to explore services like HAProxy, Nginx, and Keepalived etc. Except Keepalived, all the services need to run on the standalone instance and did not satisfy our exact need.
Keepalived does not requires any standalone instance, it can be deployed and configured with a minimal effort and provide the HA Solutions to the DB Infra. This approach not only fits for our DB setup, we can implement same …
[Read more]
Jan
22
2018
Once upon a time CPU utilization was quite a useful metric. Following are the output of several tools that provide CPU utilization metrics:
top
top reports a load of 1.66.
Is this correct? No. The correct load number is probably closer to 2.4.
# top -b -n 1| head -20 top - 11:27:45 up 151 days, 1:55, 7 users, load average: 1.66, 1.84, 1.88 Tasks: 389 total, 3 running, 386 sleeping, 0 stopped, 0 zombie Cpu(s): 0.7%us, 20.6%sy, 1.2%ni, 77.3%id, 0.1%wa, 0.0%hi, 0.1%si, 0.0%st Mem: 32639636k total, 32206476k used, 433160k free, 235732k buffers Swap: 16359420k total, 10285664k used, 6073756k free, 2354840k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 16702 root 20 0 8274m 5.0g 5.0g S 85.1 16.1 59164:55 VirtualBox 4657 root 20 0 9.8g 5.2g 5.1g S 45.5 16.6 26518:13 VirtualBox 6239 root 20 0 9.8g 5.1g 5.1g S 39.6 16.5 31200:52 VirtualBox 27070 root …[Read more]
Jan
18
2018
Donkey system is a fully automatic MySQL database change
system.
It gives a great help both to the release of the business and the
company’s automated operation and maintenance.
Dec
21
2017
We started our series on MySQL Docker deploments by showing how to deploy and use MySQL locally with docker-compose in Docker Compose and App Deployment with MySQL. Docker-compose itself is limited to one machine and it does not solve cross-node networking or span multiple datacenters. This is a job for so called cluster schedulers, i.e. […]
Dec
13
2017
Working in an operations environment means that you get a lot of questions. There’s the inevitable troubleshooting tasks that go along with being a DBA. This is designed to be a quick reference post, much like my more in depth post in 2016 about timeouts. These typical error messages can create confusion and unneeded activities to diagnose. To aid my own process of elimination and those of others, here are three error messages every DBA should know by heart.
SQLSTATE[HY000] [2002] Connection timed out
Plain and simple: this error means the client cannot connect to the server.
- The calling program is trying to connect to the wrong database server (one that it cannot reach).
- The database server is completely down (you’d get another error if the server and client actually made a connection). …
Dec
07
2017
This post is a hands-on look at ZFS with MySQL.
In my previous post, I highlighted the similarities between MySQL and ZFS. Before going any further, I’d like you to be able to play and experiment with ZFS. This post shows you how to configure ZFS with MySQL in a minimalistic way on either Ubuntu 16.04 or Centos 7.
Installation
In order to be able to use ZFS, you need some available storage space. For storage – since the goal here is just to have a hands-on experience – we’ll use a simple file as a storage device. Although simplistic, I have now been using a similar setup on my laptop for nearly three years (just can’t get rid of it, it is too useful). For simplicity, I suggest you use a small Centos7 or Ubuntu 16.04 VM with one core, 8GB of disk and 1GB of RAM.
First, you need to install …
[Read more]
Nov
23
2017
In this post we show how to use the mysql-server Docker image for local development. We first introduce a simple example app that starts up and tries to connect to a given db until successful. We then show how to start containers for multiple MySQL versions and use our example app to connect to them. […]