With MySQL 5.7, our goal is to be secure by default. This means that without having to change configuration settings or perform any additional steps, your fresh installation should be safe for production use.
As part of this security initiative, MySQL 5.7 shipped with a new feature where user accounts will be disabled if the password has not been changed in a number of days.…
We have discussed about the conceptual data model, logical data model, normalization and denormalization techniques and we discussed about installing and running up with MySQL community server. What will be next? Once we build the data model and decided the database server, the next process will be start developing the physical database. What is needed to develop physical database? We need a common language to communicate with both the developer and database server. Here, comes the structure query language. So in this post we are going to see about the …
[Read more]This is a followup to my previous post Apache Spark with Air ontime performance data.
To recap an interesting point in that post: when using 48 cores with the server, the result was worse than with 12 cores. I wanted to understand the reason is was true, so I started digging. My primary suspicion was that Java (I never trust Java) was not good dealing with 100GB of memory.
There are few links pointing to the potential issues with a huge HEAP:
http://stackoverflow.com/questions/214362/java-very-large-heap-sizes
…
This Log Buffer Edition begins with some great blog posts from Oracle, goes through SQL Server and then ends with MySQL.
Oracle:
How Uber’s infrastructure works with Schemaless, the datastore using MySQL that’s kept Uber Engineering scaling since October 2014. This is part two of a three-part series on Schemaless; part one is on designing Schemaless.
In Project Mezzanine: …
The post The Architecture of Schemaless, Uber Engineering’s Trip Datastore Using MySQL appeared first on Uber Engineering Blog.
Last week I got an assignment where I need to install MySQL
server on client’s machine, after checking the system
requirements, I came to know that, the machine contains the 64
bit windows operating system. So I thought to download MySQL
community server for windows 64 bit operating system, but I found
that the website provides only 32 bit installer for windows, and
for 64 bit operating system, the website provides the zip file
for download. My client needs to manage the MySQL products by
himself; he was expecting software where he can manage all MySQL
products at one place, so we need MySQL installer in that
machine. So I decided to install MySQL server on windows machine
using MySQL installer web community. In this post, let me go
through the step by step guide to install MySQL server on windows
machine.
After reading this completely you can answer the following
question:
Earlier today advisories were sent out regarding OpenSSH versions 5.4 through 7.1., informing users about a security bug in the software. In essence, the advisory instructed people to add the
UseRoaming no
option to their ssh_config file, with a promise for further information to be made available shortly.
Add undocumented "UseRoaming no" to ssh_config or use "-oUseRoaming=no" to prevent upcoming #openssh client bug CVE-2016-0777. More later.
— markus (@msfriedl) January 14, 2016
The post on the security issue at OpenBSD Journal can be seen here: http://undeadly.org/cgi?action=article&sid=20160114142733 …
[Read more]Transport Layer Security (TLS, also often referred to as SSL) is an important component of a secure MySQL deployment, but the complexities of properly generating the necessary key material and configuring the server dissuaded many users from completing this task. MySQL Server 5.7 simplifies this task for both Enterprise and Community users. Previous blog posts have detailed the changes supporting Enterprise builds; this blog post will focus on parallel improvements made to MySQL Community builds.
Introducing …
[Read more]Hi all, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere to MySQL, like we described in Hello World post.
We are very proud to do the sixth preview release of MySQL Group Replication, version 0.7.0 based on MySQL Server 5.7.10, which introduces new exciting features, please enjoy the highlights!…