What a great place for informal interactions, strengthening the network, and hearing the latest news from the grapevine! Last weekend 1.-3. Feb 2019, over 8000 developers met in Brussels for FOSDEM 2019. For the overall atmosphere, take a look at this 1:05 long video by Sofia Ek. MariaDB Foundation was present with six staff people […]
The post FOSDEM Reflections / MySQL – MariaDB DevRoom appeared first on MariaDB.org.
Most software applications nowadays involve some dynamic data storage for extensive future reference in the application itself. We all know data is stored in a database which falls into two categories that are: Relational and Non-relational DBMS.
Your choice of selection from these two will fully depend on your data structure, amount of data involved, database performance and scalability.
Relational DBMS store data in tables in terms of rows such that they use Structured Querying Language (SQL) making them a good choice for applications involving several transactions. They include MySQL, SQLite, and PostgreSQL.
On the other hand, NoSQL DBMS such as …
[Read more]
Glimpse of MySQL Enterprise Data Masking
Abstract- Many organizational production
environment unwittingly breach sensitive information which causes
harm of reputation, brand name and million of dollar losses etc.
hence database environments will require some form of
sanitization in order to render the informational content
anonymous. In this paper, we outline research towards a business
challenge-why mask your data and the business value- benefits of
masked data. We describe a definition of concept, performance
measurements of sql query with/without masked data and limitation
of data masking with current release of MySQL.
…
Those of you who know me know that I don’t travel often.
So it’s kind of a big deal, at least for me, that I will be at OpenWorks in NYC later this month!!!
If you’re planning on attending, please stop by and say “hi”! I’ll be helping in the Security Workshop on Monday, or you can find me at one of the Expert Bars Tuesday and Wednesday.
If you’re on the fence about attending, please message (or email) me for a significant discount code (if that might help you decide or help persuade your manager!).
Anyway, I’m excited to be going, and I hope to see you there!
Dates: February 25th – February 27th
Oracle’s website shows End of life for MySQL 5.5 as of Jan 20th of 2019, so hurry up and upgrade!
I am working building some demos for Cloud SQL and one of the requirements I had was to run MySQL 5.7 and WordPress as my sample application. The demo consisted on migrating from a single VM environment with WordPress and MySQL running alongside. The narrative: the site got popular and the database became the bottle neck because of all the shared resources between them and the application. The proposed solution? A minimal downtime migration to Cloud SQL, moving the data layer to a dedicated server.
I am going to be doing this demo a lot of times, so I needed some way to automate it. I thought of doing through Docker. I am not Docker proficient, and to begin with I asked …
[Read more]Join Percona CEO Peter Zaitsev as he presents Percona Software News and Roadmap Update on Wednesday, February 6, 2019, at 11:00 AM PST (UTC-8) / 2:00 PM EST (UTC-5).
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software. Topics include Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and Percona Monitoring and Management.
During this …
[Read more]I would like to highlight a less known MySQL SQL command, analyze how it works and understand some of the decisions that need to be made when using it.
Let’s start with the basics: The Reference Manual.
It does have a lot to say about LOAD DATA.…
Facebook Twitter Google+ LinkedIn
MySQL Server 8.0.15, a new version of the popular Open Source Database Management System, has been released. This release is recommended for use on production systems. For an overview of what’s new, please see http://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html For information on installing the release on new servers, please see the MySQL installation documentation at http://dev.mysql.com/doc/refman/8.0/en/installing.html This server release […]
Recently we had a customer who came to us for help with monitoring their InnoDB cluster setup. They run a 5.7 InnoDB cluster and suffered from a network outage that split up their cluster leaving it with no writeable primaries. As part of their incident followup, they asked us for methods to monitor this cluster.
I had tested before with InnoDB clusters (in both 8.0 and 5.7 variants) and I was confident that we could parse the cluster node “role” (read-write aka primary vs. read-only aka secondary) from the performance_schema tables. As it turned out, this feature is not in 5.7 but only 8.0. However, the docs on this are wrong for 5.7 as these docs suggest that the performance_schema.group_replication_members table would show PRIMARY and SECONDARY role of each cluster node. I have submitted a …
[Read more]