Tag: DBA

Feed: Databasejournal.com - Feature Database Articles. Author: . The Database Administrator (DBA) is usually a technical professional who supports one or more hardware and software platforms that provide application solutions. However, technical details such as SQL tuning, hardware and software upgrades, and database designs tend to be tactical in nature.  It is essential that the DBA also maintain a strategic outlook in order to get ahead of potential problems. This article addresses two of these strategies: knowing application breaking points and preparing for future enhancements to big data applications. Big Data Applications The database administrator is usually an expert on ... Read More

Feed: Planet MySQL. Author: MySQL Performance Blog. Dave Avery  | March 15, 2017 |  Posted In: MySQL PREVIOUS POST Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus! In this Percona Live featured session, we’ll meet Evan Elias, Director of Engineering, Tumblr. His session is Automatic MySQL Schema Management with Skeema. Skeema is a new open source ... Read More

Feed: Planet PostgreSQL. Citus is a distributed database that extends (not forks) PostgreSQL for large workloads. One challenge associated with building a distributed relational database (RDBMS) is that they require notable effort to deploy and operate. To remove these operational barriers, we’ve been thinking about offering Citus as a managed database for a while now. Naturally, we were also worried that providing a native database offering on AWS could split our startup’s focus and take up significant engineering resources. (Honestly, if the founding engineers of the Heroku Postgres team didn’t join Citus, we might have decided to wait on this.) ... Read More

Feed: Planet MySQL. Author: Daniel van Eeden. Intro In a set of blog posts I will explain to you how different attacks on the network traffic of MySQL look like and what you can do to secure your systems againt these kinds of attacks. How to gain access To gain access to MySQL network traffic you can use tcpdump, dumpcap, snoop or whatever the tool to capture network packets on your OS is. This can be on any device which is part of the connnection: the server, the client, routers, switches, etc. Besides application-to-database traffic this attack can also be ... Read More

Feed: Planet MySQL. Author: Frederic Descamps.  Earlier this week,  MySQL Shell 1.08 has been released. This is the first Release Candidate of this major piece of MySQL InnoDB Cluster. Some commands have been changed and some new ones were added. For example the following useful commands were added: dba.checkInstanceConfiguration() cluster.checkInstanceState() dba.rebootClusterFromCompleteOutage() So let’s have a look on how to use the new MySQL Shell to create a MySQL InnoDB Cluster. Action Plan We have 3 blank Linux servers: mysql1, mysql2 and mysql3 all running rpm based Linux version 7 (Oracle Linux 7, CentOS 7, …). We will install the required ... Read More

Feed: Planet MySQL. Author: MySQL Performance Blog. Dave Avery  | March 6, 2017 |  Posted In: MySQL, Technical Webinars PREVIOUS POST Please join Percona’s Principal Technical Services Engineer, Sveta Smirnova as she presents “Troubleshooting Issues with MySQL Character Sets ” on March 9, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8). Many MySQL novices find MySQL character sets support puzzling. But after you understand how it is designed, you will find it much more powerful than many other competing database solutions. MySQL allows to specify a character set for every object, and change it online. For years this has helped to ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Shay Pal. Contributed by Richard Gartner. Richard is a data scientist with greater interest in database management. Currently, he runs a private DBA firm in California.  Taking advantage of analytics in the business world goes beyond consuming terabytes of data and using ‘easy-through’ techniques to arrive into conclusions. An analysed data, well presented, should be able to help in real-time decision-making process. Transforming raw data into crisp insights that can be used in the decision making process is the complicated part. Presenting the final outcomes in palatable ways for the board of directors, ... Read More

Feed: Planet MySQL. Author: Daniel van Eeden. Running out of disk space is something which, of course, should never happen as we all setup monitoring and alerting and only run well behaved applications. But when it does happen we want things to fail gracefully.So what happens when mysqld runs out of disk space?The answer is: It dependsIt might start to wait until disk space becomes available. It might crash intentionally after a 'long semaphore wait' It might return an error to the client (e.g. 'table full') It might skip writing to the binlog (see binlog_error_action ) What actually happens might ... Read More

Feed: Database Trends and Applications : All Articles. Way back in the summer of 2014, I told you about how I used DB-Engines to determine the popularity of various data management tools and vendor platforms.At that time, I explained how I used DB-Engines.com and to see where the overall trends that I’m interested in are headed. Staying up with the trends isn’t just for fashionistas!We are the Champions, My FriendThe surprise came when Microsoft SQL Server was announced as the DBMS of the year for 2016 by DB-Engines.com. For the 12 months of 2016, SQL Server experienced a steep rise ... Read More

Feed: Blog Post – Corporate – DataStax. Author: Diego Ferreira. This post is one in a series of quick-hit interviews with companies using DataStax Enterprise (DSE) for key parts of their business. In this interview, we talked with Luis Valles, VP of Engineering at Liquid Grids. DataStax: Hello Luis, thanks a lot for your time today! Could you tell us a bit about Liquid Grids and your role at the company? Liquid Grids: Liquid Grids develops a technology platform for the healthcare vertical. It allows users to get insights about diseases and how they affect people around the world by ... Read More