Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 36364 10 Older Entries
How I became a Data Engineer
+0 Vote Up -0Vote Down

Pardon me if my memory fails a bit, I am trying to recount the events as they happened, but my memory is not my strongest suit.

I think I had a bit of different path than most PHP Software Developers. My first job was at a company that had their own CRM and they wanted a web version of some parts of the system. At that time, I had only “experience” with ASP and Microsoft Access (I know, tough). They wanted it to be with PHP, the difference I think came when they said they wanted the integration to run directly into the database. The web app would write directly into the DB. The CRM system was written using Delphi and Firebird. So I learned the PHP and my …

  [Read more...]
Avoiding MySQL ERROR 1784 when replicating from 5.7 to 5.6
+0 Vote Up -0Vote Down

Recently I upgraded some MySQL databases from 5.6 to 5.7, but -- for boring reasons unique to my environment -- I had to leave one replica on version 5.6. I knew there was a chance that the 5.7 -> 5.6 replication wouldn't work, but I decided to try it out to see if (and why) it would fail. Once I upgraded the master, replication failed, so I checked the error log on the replica and found these messages:

[ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF. Error_code: 1784 [ERROR] Slave I/O: Relay log write failure: could not queue event from master, …

  [Read more...]
Develop By Example – Document Store: working with collections using Node.js
Employee_Team +0 Vote Up -0Vote Down

In the previous blog post we explained how to create schemas and collections. In this one we are going to explain how to work with collections: adding, updating and deleting documents.

The following code demonstrates how to add a single document to an existing collection:

var mysqlx = require('mysqlx');
  host: 'host',
  port: '33060',
  dbUser: 'root',
  dbPassword: 'my pass'
}).then(function (session) {
  var schema = session.getSchema('mySchema');
  var coll = …
  [Read more...]
Comparison of database encryption methods (for data at rest)
+0 Vote Up -0Vote Down

I recently came across a project where we had to evaluate different techniques suited for encryption of PII data at rest. Database is MySQL community 5.6, Red Hat enterprise OS. We had to encrypt (mask) PII information of customers. As of now data is hosted in local cloud. But we may have future plans to move to a third party cloud like Amazon.

We are talking about two threats, internal and external. Internal - we have support team accessing the database the data for fixes and reporting (slave) Also DBA or Linux root user who have special privileges. So PII needs to be masked from them. External - Mainly …

  [Read more...]
Creating Migrations with Liquibase
+0 Vote Up -0Vote Down


Liquibase is a versioning tool for databases. Currently, it's on version 3.5 and is installed as a JAR. It has been on the market since 2006, and recently completed its 10th anniversary. In its feature list we have:

  • Code branching and merging
  • Multiple database types
  • Supports XML, YAML, JSON and SQL formats
  • Supports context-dependent logic
  • Generate Database change documentation
  • Generate Database "diffs"
  • Run through your build process, embedded in your application or on demand
  [Read more...]
Planets9s - Watch our webinar replays for the MySQL, MongoDB and PostgreSQL DBA
+0 Vote Up -0Vote Down

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Watch our webinar replays for the MySQL, MongoDB and PostgreSQL DBA

Whether you’re interested in open source datastores such as MySQL, MariaDB, Percona, MongoDB or MySQL; load balancers such as HAProxy, MaxScale or ProxySQL; whether you’re in DB Ops or DevOps; looking to automate and manage your databases… Chances are that we have a relevant webinar …

  [Read more...]
FieldTop - find columns that might overflow soon
+1 Vote Up -0Vote Down

Table of Contents

  [Read more...]
The Value of Database Support
+0 Vote Up -0Vote Down

In this post, I’ll discuss how database support is good for your enterprise.

Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car insurance. You must purchase car insurance before the incident happens, or insurance won’t cover the damage. In fact, most places around the world require automobile insurance. Similarly, many organizations that leverage production-use technology have their …

  [Read more...]
Press Release: Severalnines boosts US healthcare provider’s IT operations
+0 Vote Up -0Vote Down

Accountable Health Inc uses ClusterControl to outcompete larger rivals

Stockholm, Sweden and anywhere else in the world - 20/07/2016 - Severalnines, the provider of database infrastructure management software, today announced its latest customer, Accountable Health INC (AHI). This move comes at a time when technology is disrupting healthcare globally with the introduction of self-service medicine kiosks and virtual medical consultations.

AHI is a US-based company which helps pharmaceutical and healthcare firms to enhance their business and …

  [Read more...]
Decoded: A Day in the Life of a Database Administrator
+1 Vote Up -0Vote Down

Companies know they need a database administrator, but they probably don’t have any clue about what they actually do. The primary duty for a MySQL server DBA is not waking up in a panic because the phone rang so much it fell off the nightstand during their on-call nights. Outside of that situation, a DBA’s function typically revolves around making sure the data is safe, sound and in one piece when the business needs it. Organizations use different database setups to try to confuse new database administrators, even though they typically involve the same day-to-day tasks.

  [Read more...]
Showing entries 1 to 10 of 36364 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.