(Dave Stokes) MySQL’s new NoSQL database is quite a big change for all used to using a SQL speaking relational database. The Document Store makes use of the new MySQL Shell, the new X Protocol, and the new X Devapi to provide a NoSQL document storage service.
Tag: Open Source
MySQL Triggers and Updatable Views
(Agustín) In this post we’ll review how MySQL triggers can affect queries.
Debugging Character Set Issues by Example
(Bernt Marius Johnsen) In a world moving towards Unicode and UTF-8, a lot of applications still use some one-byte character set. And since one-byte characters usually accepts any byte in the range 0x00-0xFF it often works well to store and retrieve any data in such character strings, e.g. UTF-8 enco
From MySQL 8.0.0 to MySQL 8.0.1 – or any other dev milestone
( Gabriela D’Ávila Ferrara) If you want to keep up with the newest MySQL developer milestones I have news for you: there is no upgrade available for milestone versions. The way to go is to remove old version and install new one, according to their website:
Q & A: MySQL In the Cloud – Migration, Best Practices, High Availability, Scaling
(Peter Zaitsev) In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar.
MySQL on Docker: Running Galera Cluster on Kubernetes
(Ashraf Sharif) In the last couple of blogs, we covered how to run a Galera Cluster on Docker, whether on standalone Docker or on multi-host Docker Swarm with overlay network. In this blog post, we’ll look into running Galera Cluster on Kubernetes, an orchestration tool to run containers at scale.
A Quick Look at Parallel Rsync and How it Can Save a System Hours
(Alex Slotnick) In this post, we’ll take a quick look at rsync (“remote sync”) and parallel rysnc—a way to increase the efficiency and speed of traditional rsync. At VividCortex, we’ve found each to be effective and handy at various times.
MySQL Encryption at Rest – Part 1 (LUKS)
(Manjot Singh and Matthew Boehm) In this first of a series of blog posts, we’ll look at MySQL encryption at rest.
Create a new MySQL user and Grant Permissions to MySQL Database
In this tutorial, we will explain how to create a new user and grant permissions to that user in MySQL. MySQL is an open source relational database managed system(RDBMS) that enables users and applications to store, organize, and retrieve their data.
MySQL 8.0: New mysql-test-run option to minimize skipped tests in regression test runs
(Mohit Joshi) Anybody who has run the MySQL MTR test suite must have seen a statement like “x tests were skipped, y by the test itself. ” at the end of test runs. Why are some tests being skipped? Are the skipped tests affecting test coverage?