Author: MySQL Planet

Feed: Planet MySQL; Author: Mark Callaghan; This has results for IO-bound Linkbench on a large server. I previously shared results for in-memory & low-concurrency Linkbench.tl;drCompression doesn't hurt MyRocks performance MyRocks matches or beats InnoDB performance with much better efficiency ConfigurationI used my Linkbench repo and helper scripts to run sysbench with maxid1=1B, loaders=4 and requestors=16 so there will be 4+1 concurrent connections doing the load (4 for link/count tables, 1 for node table) and 16 connections running transactions after the load finishes. My linkbench repo has a recent commit that changes the Linkbench workload and results with that change are labeled new config while results without the change ... Read More

Feed: Planet MySQL; Author: Serge Frezefond; Comparing Oracle MySQL Group Replication and Galera Cluster through a probability perpective seems quite interesting.At commit time both use a group certification process that requires network round trips. The required time for these network roundtrips is what will mainly determined the cost of a transaction. Let us try to compute an estimate of the certification process cost. The duration of these network roundtrips duration can be model by random variable with an associated probability distribution law. For Galera all nodes take part in the process so the time taken is dimensioned by the worst ... Read More

Feed: Planet MySQL; Author: Codership; Join Galera Cluster team!  Both jobs are key positions at Codership. You will influence a great deal to Galera Cluster user experience.  We have thousands of users.Galera Cluster QA EngineerThe QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.TasksContinuously refine the QA process to improve product qualityTroubleshoot and work with the development team to isolate issuesCreate ... Read More

Feed: Planet MySQL; Author: Satej Sahu; With the next version of MySQL that is MySQL 8, there is a very nice feature of creating "roles" which can be assigned certain privileges and then these roles can be assigned to users, thus helping us in maintaining the principle of least privilege. It makes our life as developers and DBAs easier as we do not have to remember what are the specific privileges assigned to different users. These "roles" can simply be assigned or de-assigned from users as necessary.The setup process is pretty easy and intuitive.1. Create Role:CREATE ROLE 'read', 'write', 'read_write';Which ... Read More

Feed: Planet MySQL; Author: René Cannaò; ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!But not only! In today's release, ProxySQL 1.4.3, the most important feature is surely the support for ClickHouse as a backend!Clients can still connect to ProxySQL using the MySQL Protocol, and ProxySQL will query ClickHouse.Because of this, the above statement needs to be edited: ProxySQL doesn't support only MySQL! Support for ClickHouse is available only in packages for Ubuntu 16, Debian 9, CentOS 7, and Fedora 24, where the package name includes clickhouse.It is possible to download it here.ClickHouse ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.Cloud:Introducing managed SSL for Google App EngineUsing Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot ApplicationClusterControl in the Cloud – All Our ResourcesMonitoring Amazon Aurora Audit Events with Amazon CloudWatchIntegrating Teradata with Amazon Redshift Using the AWS Schema Conversion ToolOracle:Demo App for REST enabled SQLThe Insurance of Oracle APEX – Can Your Low Code Framework Do This?Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; We are happy to announce that MySQL team is part of the OpenSource Lisbon 2017 as Gold sponsor. You can find our experts at the booth in expo area as well as you can listen the MySQL talk on Oracle MySQL: "How are you doing?" given by Mario Beck, the MySQL Sales Consulting Manager for EMEA. Mark your calendars for September 28, 2017 for OS Lisbon 2017!!! See more details at OS Lisbon 2017 ... Read More

Feed: Planet MySQL; Author: René Cannaò; In the two previous blog posts about ProxySQL Cluster we described how to setup a Cluster, how to add users/rules and propagate them across the Cluster, how to provision new nodes, how to re-sync nodes after they have been out of the Cluster, and some features in the roadmap, especially around the concept of core nodes vs satellite nodes.We also mention that there are 4 modules/tables that currently ProxySQL Cluster is able to sync: mysql_query_rules mysql_servers mysql_users proxysql_servers We covered 3 of these, and the last one missing is how to sync mysql_servers, related ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; As continue of the previous blog posted on Aug 17, 2017, please find below a list conferences & events where you can find MySQL Community team or MySQL experts during the period of second half of September till end of December. The ones which are new are marked below. Please be aware that the list does not have to be final and during the time more events could be added or some of them removed.  Madison PHP, Madison, US, Sep 22-23, 2017​ MySQL Community team is supporting this PHP conference as Community partner. Oracle ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; September 14, 2017 gh-ost 1.0.42 is released and available for download. JSON MySQL 5.7's JSON data type is now supported. There is a soft-limitation, that your JSON may not be part of your PRIMARY KEY. Currently this isn't even supported by MySQL anyhow. Performance Two noteworthy changes are: Client side prepared statements reduce network traffic and round trips to the server. Range query iteration avoids creating temporary tables We're not running benchmarks at this time to observe performance gains. 5.7 More tests validating 5.7 compatibility (at this time GitHub runs MySQL 5.7 in production) ... Read More