System News
back5 6 7 8 9 10 11 12 13 14 15 next
Archived MySQL Articles
07 Nov 2016
open to premium members only
MySQL Cluster and real-time requirements [57813]
By Mikael Ronstrom, November 7th, 2016

Mikael writes, "This blog gives some background to the decisions made when designing the storage engine NDB Cluster used in MySQL Cluster around how to support real-time requirements (or as I sometime refer to it, predictable response time requirements).

When analysing the requirements for NDB Cluster based on its usage in telecom databases two things were important. The first requirement is that we need to be able to respond to queries within a few milliseconds (today even down to tens of microseconds). The second requirement is that we need to do this while at the same time supporting a mix of simple traffic queries combined with a number of more complex queries running at the same time..."
(Get More Information . .)

03 Nov 2016
open to premium members only
MySQL Replication: All the Severalnines Resources [57629]
by Severalnines

Severalnines blogs, "As many of you will know, MySQL Replication has become an instrumental part of scale-out architectures in LAMP environments. MySQL offers plenty of solutions when there is a need to scale out, the most common being to add read replicas. The major bottleneck for our data is generally not so much oriented around writing our data but more around reading it back. Therefore the easiest way to scale MySQL is to add replicas for reading.

We've produced a number of resources during the course of this year aimed at helping users to get started with MySQL Replication and/or get more out of their existing setups..."
(Get More Information . .)

03 Nov 2016
open to premium members only
MySQLArchitecture And Components [57630]
By Lalit

Lalit blogs, "This blog post is all about new MySQL 5.7 physical, logical architecture and it's components.In this blog post, I will try to explain things in flow including data processing and SQL execution in MySQL with the help of diagrams.

Unlike the other databases ,MySQL is a very flexible and offers different kinds of storage engines as a plugin for different kinds of needs.Because of this, MySQL architecture and behavior will also change as per the use of storage engines, for example transactional 'InnoDB' and non-transactional 'MyISAM' engines data storage and SQL execution methods will be different and within the server it will use engine specific components like memory and buffers depending on type storage engine will get used for the SQL operation.

Will discuss more about InnoDB, since it's default and main storage engine for MySQL..."
(Get More Information . .)

29 Oct 2016
open to premium members only
MySQL Support Engineer's Chronicles, Issue #2 [57426]
By Valeriy Kravchuk

Valeriy blogs, "It's time to continue my new series that I've started 2 weeks ago. I'd like to start with a reminder that it's time to send your talks for "MySQL and Friends Devroom" at FOSDEM 2017 - the only MySQL-related event next year that I plan to attend in any case. It seems we have one more week to submit, but I've already filled in all the details for the 'main' talk, 'Understanding MyRocks locks and deadlocks'. I'd like to apply my usual source code reading and gdb breakpoints approach in case if by the end of January, 2017 official documentation still misses important details. Official MySQL manual is still the process of improving with regards to explaining InnoDB locks, and I am happy to admit that this week yet another my related documentation request, Bug #71735, 'Manual does not explain locks set by SELECT ... FOR UPDATE properly', was closed..."
(Get More Information . .)

28 Oct 2016
open to premium members only
Blog Series: MySQL Configuration Management [57427]
Percona, October 28th, 2016

Dimitri Vanoverbeke blogs, "MySQL configuration management remains a hot topic, as I've noticed on numerous occasions during my conversations with customers.

I thought it might be a good idea to start a blog series that goes deeper in detail into some of the different options, and what modules potentially might be used for managing your MySQL database infrastructure.

Configuration management has been around since way before the beginning of my professional career. I, myself, originally began working on integrating an infrastructure with my colleagues using Puppet..."
(Get More Information . .)

28 Oct 2016
open to premium members only
MySQL Connector/NET 7.0.6 m5 development has been released [57433]
InsideMySQL.com, October 28th, 2016

"MySQL Connector/Net 7.0.6 is the third development release that expands cross-platform support to Linux and OS X when using Microsoft's .NET Core framework. Now, .NET developers can use the X DevAPI with .NET Core and Entity Framework Core (EF Core) 1.0 to create server applications that run on Windows, Linux and OS X. We are very excited about this change and really look forward to your feedback on it!" - MySQL Release Engineering
(Get More Information . .)

 
back5 6 7 8 9 10 11 12 13 14 15 next