Category: MySQL & MariaDB

Feed: Planet MySQL; Author: MyDBOPS; Mydbops continues with its commitment to the open source community comprising of Database Administrators. After the successful conduct of three meet-ups in the past, we are now stepping ahead on to the 4th edition of Mydbops Database meet-up. First time, we are going to the new venue, thanks to the kind people of Zenefits Technologies India Pvt.Ltd., It is a real pleasure to be hosted by the like-minded organisation in the city of Bangalore, scheduled on Saturday, 3rd of August, 2019 at Zenefits Office. In the past three editions, the focus was on the latest ... Read More

Feed: Planet MySQL; Author: Sri Sakthivel Durai Pandian; ... Read More

Feed: Planet MySQL; Author: Calvin Sun; MySQL 8.0.17 is officially released Yesterday. The most talked feature is the clone plugin, which enables the automatic node provisioning from an existing node (a Donor). This also closes the gap between MySQL Group Replication and Galera Cluster on usability.Congrats to MySQL engineering team on the excellent work! Specially expose the visibility of the operations:mysql> SELECT STATE FROM performance_schema.clone_status;+-----------+| STATE     |+-----------+| Completed |+-----------+1 row in set (0.02 sec) mysql> SELECT STAGE, STATE, END_TIME FROM performance_schema.clone_progress;+-----------+-------------+----------------------------+| STAGE     | STATE       | END_TIME                   |+-----------+-------------+----------------------------+| DROP ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; We are happy to share with you that the mysqlbinlog tool has been enhanced. Starting on 8.0.17, the user can instruct the mysqlbinlog tool to negotiate, with the server that it connects to, whether to use protocol compression or not. Since MySQL 5.6, the mysqlbinlog tool can connect to a remote server and act as a slave. This means that the tool can stream the binary log directly from a remote server. Then it can decode and print its content or just save it locally as if they were a raw copies of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; ERROR 1040…againA pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other words, the current number of connections exceeds the value of the max_connections variable.This situation on its own is already a problem for your end-users, but when on top of that you are not able to access the server to diagnose and correct the root cause, then you have a really big problem; most times you ... Read More

Feed: Planet MySQL; Author: Dave Stokes; I would like to point out some 'small' things you may not have noticed in the MySQL 8.0.17 Release Notes.  They are small changes compared to things like MVIs, InnoDB cloning, and the like but these are the types of changes that are subtle that may catch you unaware.1. Host names have grown from 60 to 255 characters.  However your SSL/TLS package may not be able to handle the longer names.2. If you are an old C/C++ programmer, 'C-style &&, ||, and ! operators that are synonyms for the standard SQL AND, OR, and ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Since MySQL 8.0.16, the Router as the possibility to launch an internal webserver (see Jan’s blog post). Even if this webserver could serve static files, it was the first piece of a much more interesting solution that is now available since 8.0.17. It’s possible now to query the MySQL Router via its REST API and get a lot of useful information. Setup Let’s first configure our MySQL Router to take advantages of this new feature. In this example, I will add the following lines to /etc/mysqlrouter/mysqlrouter.conf that I created using the --bootsrapcommand line argument: ... Read More

Feed: Planet MySQL; Author: Percona Community; Timur Solodovnikov  | July 23, 2019 |  Posted In: MySQL, Open Source Databases Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces.It provides some advantages. I will highlight some of them:You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally in the system tablespace data files (ibdata files) which can only be used for new InnoDB data.You can store specific tables on separate storage devices, for I/O optimization, space management, ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please find the list below. August 2019: Mid-Atlantic Developer Conference, Baltimore, US, August 1-2, 2019 MySQL Community team is a Bronze sponsor of this Developer conference. Our MySQL Community Manager, David Stokes will be giving 2 sessions as follows: "MySQL & GIS" scheduled for Aug 1 @11:30-12:30pm "MySQL without the SQL — Oh My!" Aug 2 @10:15-11:15am Please do not ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; (Last Updated On: July 23, 2019) Introduction In this article, we are going to see how we can sort an SQL query result set using an ORDER BY clause that takes a RANDOM function provided by a database-specific function. This is a very handy trick, especially when you want to shuffle a given result set. Note that sorting a large result set using a RANDOM function might turn out to be very slow, so make sure you do that on small result sets. If you have to shuffle a large result set and limit ... Read More