Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Oracle MySQL Group; Oracle Live. On Wednesday, December 2, the world’s most popular open source database takes a leap forward in the cloud. Edward Screven, Oracle’s chief corporate architect, will share MySQL innovation that enables you to reduce cost and complexity while accelerating business insights.  We have really exciting news for MySQL users, including some amazing testimonials from early adopters who will share their experiences. And, yes of course, there will be benchmarks! Join us on this very special day in the history of MySQL. Watch the live event, and following the announcement, join us for a ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; -- Use sakila database. USE sakila;   -- Add a prequel_id column to the sakila.film table. ALTER TABLE film ADD (series_name varchar(20)), ADD (series_number int unsigned), ADD (prequel_id int unsigned);   -- ALTER TABLE film   -- Set primary to foreign key local variable. SET @sv_film_id = 0;   -- Insert Harry Potter films in sakila.film table with classic values clause. INSERT INTO film ( title , description , release_year , language_id , original_language_id , rental_duration , rental_rate , length , replacement_cost , rating , special_features , last_update , series_name , series_number , prequel_id ... Read More

Feed: Planet MySQL; Author: Mirko Ortensi; MySQL highly available solutions, InnoDB Cluster (it uses InnoDB storage engine and is based on Group Replication plugin) and NDB Cluster (NDB storage engine), offer high scalability and redundant topologies. InnoDB Cluster can be configured with up to 9 replicas, in single primary configuration or multi-primary. NDB Cluster instead, while being a much different solution, offers the chance to have up to 4 data nodes replicated for a single shard of data (or node group) and up to a total number of 144 nodes. Redundancy ensures that multiple copies of data exist and are ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Ansible is a tool to automate servers configuration management. It is produced by Red Hat and its is open source software released under the terms of the GNU GPL. It is entirely possible to use Ansible to automate MariaDB deployments and configuration. This page contains generic information for MariaDB users who want to learn, or evaluate, Ansible. Design Principles Ansible allows us to write playbooks that describe how our servers should be configured. Playbooks are lists of tasks. Tasks are usually declarative. You don't explain how to do something, you declare what ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Some of JSON functions accept JSON Path expressions. MariaDB defines path as follows: JSON Path Syntax path : '$' [step]* The $ symbol represents the context item. The search always starts from the context item, because of that the path always starts with $. Then, it is followed by zero or more steps, which select element(s) in the JSON document. A step may be one of the following: Object member selector Array element selector Wildcard selector Object member selector To select member(s) in a JSON object, one can use one of the ... Read More

Feed: Planet MySQL; Author: Severalnines; Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing how to protect your application from them alone will not be sufficient - especially when you’re running MySQL. Today we are going to look at a different side of security - we are going to look into how to properly secure MySQL. As MySQL security is a pretty big thing, treat this post as the start of a series of ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Syntax CAST(expr AS type) Description The CAST() function takes a value of one type and produces a value of another type, similar to the CONVERT() function. The type can be one of the following values: The main difference between CAST and CONVERT() is that CONVERT(expr,type) is ODBC syntax while CAST(expr as type) and CONVERT(... USING ...) are SQL92 syntax. In MariaDB 10.4 and later, you can use the CAST() function with the INTERVAL keyword. MariaDB starting with 5.5.31Until MariaDB 5.5.31, X'HHHH', the standard SQL syntax for binary string literals, erroneously worked in ... Read More

Feed: Planet MySQL; Author: Airton Lastori; The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a base clock frequency of 2.25 GHz and max boost of up to 3.4 GHz, and have better networking and more RAM. MySQL Database Service customers can start to use them today and enjoy higher performance and flexibility for diverse MySQL workloads. The MySQL Database Service E3 offers up to 64 OCPUs (128 virtual cores) and 1 TB of RAM. This ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Logical backup’s are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.22 it is not possible to make a backup of single table using MySQL Shell.MySQL Shell’s new table dump utility  util.dumpTables() from this we can take the dump of the specific tables of the  schema using this utility.it works in the same way as the instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas() ... Read More

Feed: Planet MySQL; Author: Johannes Schlüter; Recently the MySQL Database Service (MDS) was launched in Oracle Cloud Infrastructure (OCI). As Cloud is about automation you don't have to use the Web Console to configure your instances, but can do it via API, for instance with the oci command line tool or your favorite programming language. However often it is nice to define the world in a declarative way ("I want a network, like this, and a MySQL database like that") and let the tool figure out how to align the reality in the cloud with your wish. A tool doing ... Read More