I posted a few days ago some initial thoughts on the the MySQL native cloning functionality. Overall this looks good and I need to spend time to test further. I’m here in San Francisco ahead of Oracle Open World which starts today. As is usual with trips like this jet lag wakes you up rather […]
10 Older Entries »
If you use replication with MySQL, if you need a backup, if you need a spare copy of a system for testing and for many other reasons you need a way to make a copy of your MySQL system. In the past you could make a copy in various ways: using a cold file system […]
Fairly recently, we’ve upgraded to MySQL 8; it’s been a relatively smooth transition, however, some minor differences needed to be handled. One of them is the behavior of trailing spaces.
Trailing spaces are a (not in a good way) surprising, but also widely covered argument. This article gives a short overview, and relates it to how this affects people upgrading to MySQL 8.0.
Ran into an interesting situation trying to configure a MySQL JDBC driver to connect over TLS (though the driver may call it SSL, TLS is the name for more recent versions of the protocol).
The error I was getting was pretty generic:
Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
With the relevant parts of the stacktrace, also being non helpful:
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) at …[Read more]
I am doing something this weekend that is way out of my
comfort zone and I want to encourage you to do something
similar. On Saturday I will be teaching a pop up workshop
Tech Austin titled An Introduction to Databases
Why is this out of my comfort zone? I regularly speak to computer professional on databases and programming and have done so for years. But this Saturday the class is made up of young women between the ages of fourteen and eighteen.For us oldsters, the class is made up of people half the age of MySQL, Python, and Java. Their parents are probably younger than Structured Query Language! But these young folks are going to be inheriting our code bases based on technologies used today and integrated with future innovations.
Another point of reference is that the …
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.
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) […]
[ 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. […]
We will show you how to list all databases in MySQL. MySQL is an open-source relational database management system commonly used with web based applications like WordPress, Magento etc. In this tutorial we will show you how to list all databases in MySQL on a Linux VPS. Before you start listing all tables in MySQL, […]
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
10 Older Entries »