System News
back3 4 5 6 7 8 9 10 11 12 13 next
Archived MySQL Articles
17 Nov 2016
open to premium members only
About cloud lock-in and open source databases [58110]
By Severalnines, November 17th, 2016

Severalnines blogs, "The cloud is no longer a question of if, but of when. Many IT leaders, however, find that one consistent barrier to their adoption of the cloud is vendor lock-in. What do you do when you are forced to stay with a provider that no longer meets your needs?

But is cloud lock-in a problem?..."
(Get More Information . .)

11 Nov 2016
open to premium members only
Testing MySQL 8 [57808]
By Dave Stokes, November 11th, 2016

Dave blogs, "MySQL 8 is now available for testing. The list of features is impressive and I am sure many PHP developers will be interested in having a true data dictionary, invisible indexes, and more. Right now it is in a milestone release. I am still doing a lot of work with 5.7 and found a great way to have 8 around when I needed by using Docker. Follow the Docker install guide for your platform of choice and then run ..."
(Get More Information . .)

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

 
back3 4 5 6 7 8 9 10 11 12 13 next