Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Last week I presented the following session at the pre-FOSDEM MySQL Day:
MySQL Shell : the best DBA tool ? from Frederic Descamps
The audience seemed very interested on how the MySQL Shell can be extended.
During the presentation I showed how I extended the MySQL Shell with two new modules in Python:
Both projects are on github and are waiting for ideas, feature requests, pull requests, …
Here is …
[Read more]
The next two weeks are a big change for me compared to the last
two weeks. The last two weeks I was in Belgium and now I am
in Miami before heading to the Dominican Republic. The one
thing in common is that I am speaking on the MySQL Document
Store.
SunshinePHP has become a favorite conference for
many PHP developers for many reasons and this morning I will be
running a three hour tutorial on using the PECL MySQL X DevAPI
and the MySQL Document Store with PHP and then have a one hour
talk later in the show. Plus I am joined by the amazing Kathy
Forte who will speak on Driving Innovation With MySQL 8.0 and
Docker.
Pycaribbean
is a new show hoping to foster a growing developer community into
the area. And i will be showing how to use the MySQL
Document Store with Python.All opinions …
MySQL Server has a feature where you can insert data into a table from a file with the data delimited by commas, tabs, or another delimiter. This is particularly useful when you need to bulk import data, for example when restoring a backup or migrating data from one system to another including from another database product than MySQL. The mysqldump backup utility is an example of a program that supports exporting the data to delimited text files.
The statement to load the data is LOAD DATA INFILE. By default the file must
be server-side and MySQL …
In this post, we’ll cover Percona’s thoughts about the current MySQL community discussion happening around MySQL LOCAL INFILE security issues.
This post is released given the already public discussion of this particular issue, with the exploitation code currently redacted to ensure forks of MySQL client libraries have sufficient time to implement their response strategies.
This post has been updated to now include previously redacted content, in line with responsible disclosure sufficient time has passed to allow forks to update and get those updates out for circulation.
Background
MySQL’s
LOCAL INFILE
feature is fully documented by Oracle MySQL, and there is a legitimate use for the
LOCAL INFILE
feature to upload data to a …
[Read more]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]