(Shlomi Noach) With the unintended impression of becoming live blogging, we now follow up on Solving the non-atomic table swap, Take II and Solving the Facebook-OSC non-atomic table swap problem with a safe, blocking, atomic solution
Tag: Open Source
Pipelining versus Parallel Query Execution with MySQL 5.7 X Plugin
(Alexander Rubin) In this blog post, we’ll look at pipelining versus parallel query execution when using X Plugin for MySQL 5.7.
How to make sure that ‘password’ is not a valid MySQL password
(Dave Stokes) Password management is an issue for many. It is not uncommon for an organization to require you to changing your password on a regular basis and many have rules on the length and content of passwords.
MySQL 5.7, utf8mb4 and the load data infile
(Alexander Rubin) In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile.
Develop By Example – New MySQL Document Store Series
(Francisco Tirado) Examples are a great way to learn new things. As many of you may or may not know we’ve added some new things to MySQL Server 5.7.12 and the ecosystem around it, extending it to allow you to use the MySQL as a Document Store. Meeting the challenge meant expanding Developer Interf
MySQL Password Security Changes for PHP Developers
(Dave Stokes) MySQL 5.7 introduced many new facets to password security. The first thing most notice is that you are assigned a random root password at installation time. You then have to search the log file for this random password, use it to login, and then change it.
Q: Does MySQL support ACID? A: Yes
(Ronald Bradford) I was recently asked this question by an experienced academic at the NY Oracle Users Group event I presented at.
The need for parallel crash recovery in MySQL
(Vadim Tkachenko) In this blog, I will discuss how parallel crash recovery in MySQL benefits several processes.
5 Database Insights Easy to See with VividCortex SaaS Monitoring
(Ewen Fortune) There are manifold ways to collect, visualize, and analyze data… but not all methods are equally useful. VividCortex, however, is singular as a database-centric SaaS monitoring platform, and it’s designed to provide you with powerful insights into your system that are both inherently
Migrate from MS SQL Server to MySQL
(Alexander Rubin) In this blog series, I will share my experiences as I migrate commercial databases (i.e., Microsoft SQL or Oracle) to open source (MySQL). More specifically, we will look at how you can migrate from MS SQL Server to MySQL.
