We’re in the process of upgrading our MySQL databases from v5.7
to v8.0; since one of the differences in v8.0 is that the default
encoding changed from utf8 to utf8mb4,
and we had the conversion in plan anyway, we anticipated it and
performed it as preliminary step for the upgrade.
This post describes in depth the overall experience, including tooling and pitfalls, and related subjects.
Contents:
[Read more]We recently had to drop a column in production, from a relatively large (order of 10⁷ records) table.
On modern MySQL setups, dropping a column doesn’t lock the table (it does, actually, but for a relatively short time), however, we wanted to improve a very typical Rails migration scenario in a few ways:
I’ll give the Gh-ost tool a brief introduction, and show how to fulfill the above requirements in a simple way, by using this tool and an ActiveRecord flag.
This workflow can be applied to almost any table alteration scenario.
Contents:
This is a quick reminder that on Thursday (tomorrow) there there is a Madrid MySQL Users Group Meeting where Giuseppe Maxia will be presenting dbdeployer to us. More information can be found here. Do not forget to sign up if you are interested. We look forward to seeing you there.
The post Reminder: Madrid MySQL User Group Meetup presenting dbdeployer on Thursday in Madrid first appeared on Simon J Mudd's Blog.
This is a quick reminder that this week there are 2 MySQL User Group Meetings (Amsterdam and Madrid) where we will be talking about Scaling MySQL. Guest speaker will be Morgan Tocker from PingCap who will talk about TiDB. More information: MySQL User Group NL meetup taking place on Monday (presenting: Morgan, Daniël and Simon) … Continue reading Reminder: MySQL User Group NL and Madrid MySQL User Group Meetups presenting Scaling MySQL this week (Monday/Thursday)
[Read more][ English ] – texto en español abajo We’re pleased to announce the next Madrid MySQL Users Group meetup which will take place on the 15th of November at 19:00. Sign up details can be found here. There’ll also be a similar meetup in Amsterdam on the 12th November hosted by a colleague. Details here. … Continue reading 2018-11-15: Announcing: Scaling MySQL with TiDB, Vitess and MySQL Cluster at Madrid MySQL Users Group
The post 2018-11-15: Announcing: Scaling MySQL with TiDB, Vitess and MySQL Cluster at Madrid MySQL Users Group first appeared on Simon J Mudd's …
[Read more]Securing your data is only as good as your weakest link. A clear-text password in a file or history file, shared privileges between test and production or open sudo access when you can connect as an unprivileged user all are security flaws. This talk discusses how to navigate the poor defaults MySQL has in place, how to strengthen processes and how to audit your environment. It also covers the complexity of deploying changes in an always available production environment.
Presented at the Data.Ops Conference in Barcelona, Spain.
Download slides
We will show you how to list all databases in MySQL, i.e how to have a list of all MySQL ...
The post How To Show A List Of All DataBases In MySQL appeared first on RoseHosting.
This Wednesday, 6th June 2018, I will be presenting at OpenExpo Europe in Madrid: Experiences with testing dev MySQL versions and why it’s good for you. It’s always good to test new releases of MySQL and this presentation talks about why. If you are at the conference then please come along and say hello. Update 2018-06-07. … Continue reading I will be presenting at OpenExpoEurope in Madrid on Wednesday
Let us show you how to install MySQL on your CentOS 7 server. MySQL is a relational database management system ...
The post How to Install MySQL on CentOS 7 appeared first on RoseHosting.
Nicolas Tobias has written an awesome guide to setting up replication from MariaDB to Hadoop/HDFS using Tungsten Replicator, in Spanish! He’s planning more of these so if you like what you see, please let him know!
Semana santa y yo con nuevas batallas que contar.
Me hayaba yo en el trabajo, pensando en que iba a invertir la
calma que acompa;a a los dias de vacaciones que libremente
podemos elegir trabajar y pense: No seria bueno terminar esa
sincronizacion entre los servidores de mariaDB y HIVE?
Ya habia buscado algo de info al respecto en Enero hasta tenia una PoC montada con unas VM que volvi a encender, pero estaba todo podrido: no arrancaba, no funcionba ni siquiera me acordaba como lo habia hecho y el history de la shell er un galimatias. Decidi que si lo rehacia todo desde cero iba a poder dejarlo escrito en un playbook y ademas, aprenderlo y automatizarlo hasta el limite de poder desplegar de forma automatica on …
[Read more]