Building a docker image for MySQL is essential if you’d like to customize MySQL to suit your needs. The image can then be used to quickly start running MySQL containers, which can be operated individually. In our previous post, we covered the basics of running MySQL as container.
Tag: Open Source
Troubleshooting configuration issues: Q & A
(Sveta Smirnova) In this blog, I will provide answers to the Q & A for the Troubleshooting configuration issues webinar.
MySQL auto update date_created and date_updated columns
(Satej Sahu) It’s usually a good practice to have two columns called date_created and date_updated in every table. One can always use it in application and it helps in debugging too as to when a record was created and last updated in various circumstances and contexts.
Docker automatic MySQL slave propagation
(Vadim Tkachenko) In this post, we’ll discuss Docker automatic MySQL slave propagation for help with scaling.
MySQL Tuning for Large Datasets
(Rob Gravelle) Did you know that large well-known companies like Google, Yahoo, NASA, and Walmart all use MySQL? Well, it’s true. Moreover, some of these companies’ tables may contain billions of rows.
Why is varchar(255) not varchar(255)?
(Cédric Bruderer) Recently I was working on a clients question and stumbled over an issue with replication and mixed character sets. The client asked, wether it is possible to replicate data to a table on a MySQL slave, where one column had a different character set, than the column in the same tabl
Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host
(Vadim Tkachenko) This post is a continuance of my Docker series, and examines Running Percona XtraDB Cluster nodes with Linux Network namespaces on the same host.
Do you control your database outages?
(Ronald Bradford) Working with a client last week I noted in my analysis, “The mysql server was restarted on Thursday and so the [updated] my.cnf settings seems current”. This occurred between starting my analysis on Wednesday and delivering my findings on Friday.
Solving the non-atomic table swap, Take II
(Shlomi Noach) Following up and improving on Solving the Facebook-OSC non-atomic table swap problem, we present a better, safe solution.
What to test before upgrading to MySQL 5.7
As we saw in a previous post, there are some important changes between MySQL 5.6 and 5.7. Since the behaviour of some existing features been altered, some detailed testing of the upgrade is in order.