Tag: MySQL 8.0

Feed: Planet MySQL; Author: Peter Gulutzan; MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October. To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake. On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I do not care much about MySQL 8.0.x at the moment, as it's far from being GA and is work in progress. It is not yet used by customers whom I have to support. But I know about many interesting changes and improvements there that, eventually, are going to influence all main forks and kinds of MySQL. So, it would not be wise to ignore MySQL 8.0.c entirely even for me.For this post I decided to briefly check what community reported bugs were fixed in the recent release, 8.0.2, based on release notes. For ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Python 2.1.7 GA is a fifth GA version of 2.1 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.1.7 GA is compatible with MySQL Server versions 5.5 and greater. Python 2.6 and greater as well as Python 3.4 and greater are supported. Python 2.4, 2.5, and 3.1, 3.2, 3.3 are not supported. MySQL Connector/Python 2.1.7 is available for download from: http://dev.mysql.com/downloads/connector/python/#downloads MySQL Connector/Python 2.1.7 (Commercial) will be available for download on the My Oracle Support (MOS) website. This release ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; It's our pleasure to announce that MySQL Community team is supporting multiple shows around the world. Please find a list of conferences & events where you can find us in August & September below: NA&LAD UbuCon LA,Lima, Peru, Aug 18-19, 2017 MySQL Community team is supporting this small Ubuntu conference in LAD as Platinum sponsor.   Pacific Northwest PHP, Seattle, US, Sep 9-11, 2017 You can find our team at the MySQL Community booth in the expo area. Madison PHP, Madison, US, Sep 22-23, 2017 MySQL Community team is supporting this PHP conference ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; TL;DR: unless you know what you are doing, you should always have a primary key on your tables when replicating in RBR (and maybe even all the time). TL;DR2: MariaDB 10.1 has an interesting way to protect against missing a primary key (innodb_force_primary_key) but it could be improved.A few weeks ago, I was called off hours because replication delay on all the slaves from a replication chain was high and growing.  It was not the first time this happened on that chain, so I thought right away that this was probably an UPDATE or DELETE of many ... Read More

Feed: Planet MySQL; Author: Severalnines; Replication in MySQL has been around for a long time, and has been steadily improving over the years. It has been more like evolution rather than revolution. This is perfectly understandable, as replication is an important feature that many depend on - it has to work. In the last MySQL versions, we’ve seen improvements in replication performance through support for applying transactions in parallel. In MySQL 5.6, parallelization was done on schema level - all transactions which have been executed in separate schemas could be executed at once. This was a nice improvement for those ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr This blog post was related to the change we implemented in the Group Replication’s monitoring (performance_schema tables) and how sys schema should be changed to modify the view used by ProxySQL according. However, I used my labs machines that I was using for different purposes too and some changes I made hid a problem that avoid ProxySQL to work with the new defaults in MySQL 8.0.2. Thank you Andy for discovering this. In fact the new collation default (utf8mb4_0900_ai_ci) is ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; In MySQL 8.0.2 DMR we will introduce features which make managing undo tablespaces easier in InnoDB. The main improvement is that you can now create and drop undo tablespaces at any time.  You can change the config file setting before any startup, whether recovery is needed or not.  And you can either increase or decrease the number of undo tablespaces while the engine is busy. innodb_undo_tablespaces:  Undo Tablespaces contain Rollback Segments which in turn contain undo logs.  Undo Logs are used to ‘rollback’ transactions and to create earlier versions of data which ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Group Replication: who is the primary master – updated! – lefred's blog: tribulations of a MySQL Evangelist Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the visibility of Group Replication extending the performance_schema tables (see his article). Thanks to these improvements, it’s now very easy to find which host is acting a Primary-Master. This is the query you can use: mysql-sql> SELECT ... Read More

Feed: Planet MySQL; Author: Lukas Eder; In recent months, there had been some really exciting news from the MySQL team: These two SQL standard language features are among the most powerful SQL features that are available from most other databases. I frequently include them in conference talks about SQL (see my article about 10 SQL Tricks That You Didn’t Think Were Possible), and as well in the Data Geekery SQL Masterclass. With MySQL 8.0 now supporting these exciting features, the masterclass will be including MySQL as well (along with Oracle, SQL Server, PostgreSQL, and DB2). And, of course, these features ... Read More