Connect with us

Featured

Oracle releases new MySQL

Published

on

Oracle has announced the general availability of MySQL 5.7, the latest version of what it claims is the world’s most popular open source database.

The new version delivers greater performance, scalability and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases.

“MySQL 5.7 delivers a wide range of innovations allowing developers, database administrators and DevOps teams to build and manage next-generation Web and cloud-based applications capable of processing ever increasing volumes of data,” said Tomas Ulin, vice president, MySQL Engineering, Oracle.

“MySQL 5.7 builds upon Development Milestone Releases that have enabled users to preview, test and provide feedback during the development process – and as a result, this release has been a collaborative process involving many members of the MySQL community.”

“Booking.com’s initial testing of the Development Milestone Releases has shown promising improvements that will enable us to perform online configuration and schema changes with less downtime,” said Nicolai Plum, senior systems architect, Booking.com. “The multi-source and parallel replication improvements in MySQL 5.7 GA will help us to continue scaling our global e-commerce business with ease and we look forward to deploying it soon.”

Key enhancements in MySQL 5.7, which deliver greater performance and scalability, include:

·       Enhanced Speed: In benchmark tests using SysBench Read-only Point-Selects, at 1,024 connections, MySQL 5.7 delivered 1,600,000 queries per second (QPS) —  3x faster than MySQL 5.6.

·       Optimized InnoDB: New capabilities include increased performance and concurrency, enhanced on-line operations, spatial indexes, native partitioning and more.

·       More Robust Replication: Enhancements to MySQL’s replication features include multi-source replication, enhanced Global Transaction Identifiers (GTIDs), and improved multi-threaded slaves for better scalability and availability.

·       Enhanced Optimizer: A new MySQL optimizer dynamic cost model provides better query performance and greater user control.

Primary manageability enhancements within MySQL 5.7 include:

·       New Native JSON Data Type and JSON Functions: Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns.

·       Performance Schema: Enables instrumentation for memory, transactions, stored routines, prepared statements, replication and locks.

·       MySQL SYS Schema: Provides helper objects that answer common performance, health, usage and monitoring questions.

·       Improved Security: Delivers easier and safer instance initialization, setup and management.

·       Expanded Geographic Information System (GIS) Support for Mobile Applications: Provides spatial index support in InnoDB, GeoJSON and GeoHash support.

Also now generally available is the new MySQL Router, which simplifies application development by intelligently routing queries to MySQL databases for increased performance and uptime. MySQL Router also provides cross-language support for MySQL Fabric, making it simpler to manage groups of MySQL databases and delivering both high availability and scalability through automated data sharding.

For early testing and feedback, MySQL Group Replication is available at http://labs.mysql.com. Group Replication delivers active/active write-anywhere replication clusters to MySQL, with support for automatic conflict detection and resolution.

Featured

Smash hits the Nintendo Switch

Super Smash Bros. delivers what the fans wanted in the latest “Ultimate” instalment, writes BRYAN TURNER.

Published

on

Super Smash Bros. Ultimate, the latest addition to the popular Nintendo Smash series, has landed on the Nintendo Switch with a bang, selling 5-million copies in the first week of its release. The game has been long-anticipated since the console’s release, as many fans consider iy to be a Nintendo staple. And the wait was well worth it.

It features 74 playable fighters, 108 stages, almost 1300 Spirit characters to collect while playing, and a single-player Adventure mode that took about three days (or 28 hours) of gameplay to complete. The game offers far more gameplay than its predecessors, making it the Smash game that gives its players the best bang for their buck.

For those new to the game, the goal is to fight opponents and build up their damage score (draining their health) to knock them off the stage eventually. This makes the game seem chaotic, as many players jump around the platforms as if they were on quicksand, in order to avoid being hit by the other players.

It also services two kinds of players: the competitive and the casual.

Competitive players can be matched on the online service by skill ranking to enjoy playing with similarly high-skilled opponents. This is especially important in e-sports training for the game, and for players wanting to master combos against other human players. The casual gamer is also catered for, with eight-player chaos and button-mashing to see who comes out luckiest. This segment is also important for those wanting to learn how to play.

Training mode is also a place to go for those learning to play. It offers “CPU” players that are graded by intensity to train as a single player to learn a character’s moves, combos and general fighting style. More challenging CPU players can also be used by competitive players to train when there isn’t a Wi-Fi connection available.

Direct Play features in this game, allowing two players with two Switch consoles to play against each other over a direct connection – no Wi-Fi needed. This is especially useful to those who want to have a social gaming element on the go, similar to that of the cable connector of the Gameboy.

Click here to read Bryan Turner review of Super Smash Bros. Ultimate.

Previous Page1 of 3

Continue Reading

Competitions

Win Funko Fortnite in Vinyl

Gadget and Gammatek have nine Funko Fortnite figurines to give away.

Published

on

A Funko Pop figurine based on a character set is indicative of reaching the heights of pop culture. It is no surprise, then, that the world’s biggest online game, Fortnite, has its own line of Funko Pop figurines. The Funkos are modeled on the characters in game, including Drift, Ragnarok, Dark Vanguard, Volar, Tracera Ops, and Sparkle Specialist.

Now, local Funko distributor Gammatek has released the Fortnite figurines in South Africa. To celebrate, Gadget and Gammatek are giving away a set of three Funko Fortnite figurines to each of three readers (9 figurines in total). To enter, first click on your favourite Funko Pop on the next page and post the Tweet that appears. Then, follow Gadget on Twitter.

You can put the tweet in your own words, but entries must have the competition’s hashtag (#FunkoFortnite) and mention @GadgetZA to be considered valid.

Click here to select the Funko Fortnite character you want to tweet.

Previous Page1 of 2

Continue Reading

Trending

Copyright © 2018 World Wide Worx