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 …
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]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
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]This is my next blog series. Im going to write about how I automated many complex tasks in MySQL with Rundeck. In my last series, I have explained RunDeck basics. You can find those articles here. In this blog Im writing about how I automated MySQL archive for multiple tables in one Rundeck job. Challeange …
The post MySQL With DevOps 1 – Automate Database Archive appeared first on SQLgossip.
