Reserved Words and UTF8MB4 Issues The upgrade checker utility in
the new MySQL Sell will warn you about potential problems.
The two most common problems I have seen are finding out one of
your column names is a reserved word and character sets.
Reserved Words
You will spot reserved word issues on the second step of the
upgrade check: 2) Usage of db objects with names conflicting with
reserved keywords in 8.0 Warning: The following objects
have names that conflict with reserved keywords
that are new to 8.0. Ensure queries sent by your applications use
`quotes` when referring to them or they will result
in errors. More information:
https://dev.mysql.com/doc/refman/en/keywords.html
davetest.reserved_word.over - Column name
In the above we are being told that in the schema 'davetest' in
the table 'reserved_word' that there is a column named 'over'
that …
My first talk is a tutorial Testing like a boss: Deploy and Test Complex Topologies With a Single Command, scheduled at Percona Live Europe in Amsterdam on September 30th at 13:30.
My second talk is Amazing sandboxes with dbdeployer scheduled on October 1st at 11:00. It is the same topic as the tutorial, but covers a narrow set of features, all in the *amazing* category.
The tutorial introduces a challenging topic, because when people hear testing, they imagine a troop of monkeys fiddling with a keyboard and a mouse, endlessly repeating a boring task. What I want to show is that testing is a creative activity and, with the right tools and mindset, it could be exciting and rewarding. During my work as a quality assurance engineer, I have always seen a boring task as an opportunity to automate. …
[Read more]This tutorial explains how to create a user with a password in MySQL. We’ll use the MySQL Create User command and describe it with the help of examples. MySQL Create User with Password This command creates a new MySQL user and grants privileges. Usually, you might be using the root user to access a database. […]
This tutorial explains how to create a user with a password in MySQL. We’ll use the MySQL Create User command and describe it with the help of examples. By using this command, you can create a new MySQL user and grant privileges. Usually, you might be using the root user to access a database. The […]
The post Create a New User in MySQL with Password appeared first on TechBeamers.
This week you can find our MySQL & MySQL Community experts at following shows:
-
db tech showcase, Tokyo, Japan, September 25-27, 2019
- MySQL team as Silver sponsor will have a booth in the
expo area and in total 5 speaking slots related to MySQL as
follows:
- Two User Case Studies of MySQL
- Two Technical Sessions by MySQL User Community members (MyNA)
- MySQL Server, MySQL Workbench and MySQL Shell by MySQL GBU
- Please watch organizers' website for more details.
- MySQL team as Silver sponsor will have a booth in the
expo area and in total 5 speaking slots related to MySQL as
follows:
- …
MySQL 8.0 has been the fastest in uptake of any version of
MySQL. But there are still a few of your still running
5.7. To help you get from 5.7 to 8.0 you can use the new
MySQL Shell or mysql. The mysqlsh program has a built in
upgrade checker to make sure you have an easy upgrade and to warn
you of any potential problems before your smack into them.
The first step is to install mysqlsh and it can be as simple as
using the MySQL apt repo and then running sudo apt-get install
mysql-shell. See A Quick Guide to Using the MySQL Apt Repo.
Second is connecting with the new shell. Now something to note is
that you have to specify the port for the standard protocol as
the new shell wants to default to using the new protocol's port
at 33060. Simply specify the root account, the host, and
that 3306 port.
…
You as a MySQL administrator/developer are really excited about cloning in MySQL 8.0.17. You are reading all the recent blogs. You know that quickly getting a replica up and running is quite important to your dev team.
Besides, ‘cloning’ reminds you of the old classic film ‘Sleeper’ where the actors clone a new leader from the dead leader’s nose.
Thinking of all this puts you in great spirits. Moving from MySQL 5.7 to MySQL 8.0 is high on your agenda.
Suddenly, the CEO walks up to your desk. “We lost millions in sales last quarter,” he yells. “It’s your fault. We sold all of our items at the discounted price rather than the actual price. You need to fix this today if not sooner.”
With that, the CEO reminds you of another reason to move to MySQL 8.0 : check constraints, which came out in 8.0.16.
You know that ensuring that data is …
[Read more]We’re happy to announce that our white paper ‘Tungsten Clustering – Benefits & Configurations’ for MySQL, MariaDB and Percona Server is available to read on our website.
Tungsten Clustering is a one-of-a-kind software solution that provides clustering, disaster recovery and high availability for MySQL, MariaDB & Percona Server databases.
It allows enterprises running business-critical database applications to cost-effectively achieve continuous operations on a global scale with:
- Commercial-grade high availability (HA)
- Geographically redundant disaster recovery (DR)
- Global operations with geographically distributed multi-master
…
[Read more]If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks. A few years back at Percona Live 2016, I gave an introductory talk on schema review and optimization. Here’s the video:
I was thinking about that talk in the context of some of my current clients. Though I had worked on extremely large database deployments during my earlier tenure at Percona, it was often more of an outlier. Now, working as a Technical Account Manager with our largest clients, it is much more common.
The Fundamental Problem
I’d like to expand my thoughts on the “choosing the smallest data type you can” principle from my 2016 slides through the lens of a few of my 2019 …
[Read more]Percona Live is always a great opportunity to learn from the best and brightest in the open-source database community. This time, Percona Live Europe is being held at the Hilton Amsterdam Airport Schiphol, The Netherlands from September 30 to October 2, 2019.
Pythian will be present, as has been the case for the past few years, with some of our technical experts speaking on a variety of subjects and technologies.
Feel free to ping any of us during the conference breaks or community events, as we’ll be happy to answer any questions you have about anything open source, cloud, or data-related.
Here are some sessions you won’t want to miss:
Wednesday, October 2
9:00 AM – …
[Read more]