Resultados 1 a 4 de 4
  1. #1
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    14,992

    [EN] Oracle Announces General Availability of MySQL 5.7

    Up to 3x faster than MySQL 5.6 in benchmark tests

    Group Replication delivers active/active write-anywhere replication clusters to MySQL, with support for automatic conflict detection and resolution.

    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


    Redwood Shores, Calif.—Oct 19, 2015




    Oracle today announced the general availability of MySQL 5.7, the latest version of 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.”

    Ulin will provide an overview of what’s new in MySQL 5.7 during the upcoming MySQL Central @ OpenWorld “State of the Dolphin” address in San Francisco on Monday, October 26 at 4.00 pm. Additionally, a webcast will be held on November 11, 2015, at 9.00 a.m. US Pacific Time.

    “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.

    MySQL 5.7 is scheduled to be available for download at http://dev.mysql.com/downloads/ on October 26, 2015. Terms, conditions and restrictions apply.
    https://www.oracle.com/corporate/pre...ga-101915.html
    Última edição por 5ms; 19-10-2015 às 14:21.

  2. #2
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    14,992
    Gabriel Linder
    ‏@pfctl

    #MySQL 5.7.9 on #Power8 : 246kqps with vanilla configuration (just increased max_connections)... not bad.

    #PostgreSQL 9.4 was running #pgbench at 198kqps (just increased max_connections, too)


    IBM POWER8 S822L
    192 cores - 2 processors, 24 cores per processor, 4 threads per core (SMT4)
    512 GB RAM
    (1.599,00 € HT/mois Frais d'installation: 1.500,00 €)


    Se correr a IBM pega, se ficar a Oracle come.

  3. #3
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    14,992

    Getting Started with MySQL Cluster 7.4

    1 billion writes per minute, 200 Million QPS on Commodity Hardware

    Frazer Clement, MySQL Cluster Technical lead, Oracle
    Bernhard Ocklin, Director MySQL Cluster Engineering, Oracle

    Do you have performance demands that a database can’t scale to meet—especially one as simple as MySQL? And if it were even possible, would it require top-of-the-range servers and storage? We previously demonstrated that MySQL Cluster could scale to 1 billion writes per minute, and MySQL Cluster 7.4 exceeded 200 million queries per second (QPS), all with open source software running on commodity servers. Discover how MySQL Cluster achieves this scalability while also delivering in-memory performance, 99.999 percent availability, active-active update-anywhere geographic redundancy, ACID transactions, and both SQL and NoSQL access. Finally, this session offers some tips on getting MySQL Cluster up and running so that you can try it out for yourself.
    Download presentation

  4. #4
    WHT-BR Top Member
    Data de Ingresso
    Dec 2010
    Posts
    14,992
    Citação Postado originalmente por 5ms Ver Post
    1 billion writes per minute, 200 Million QPS on Commodity Hardware
    Serto.


Permissões de Postagem

  • Você não pode iniciar novos tópicos
  • Você não pode enviar respostas
  • Você não pode enviar anexos
  • Você não pode editar suas mensagens
  •