System News
back1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
06 Jan 2017
open to premium members only
Easy-To-Use Perl Scripts To Backup Your MySQLl Database With Mysqldump And Ftp The Files To A Remote Server [59468]
By Tony Darnell, January 6th, 2017

Tony writes, "Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have data which is important to your business, then you should take a look at the MySQL Enterprise Edition - and use MySQL Enterprise Backup instead. The MySQL Enterprise Backup allows you to backup your database without the table locking you get with mysqldump. And, it is extremely fast - especially when you have to restore your database. Here is a sample speed comparison between MySQL Enterprise Backup and using mysqldump:..."
(Get More Information . .)

06 Jan 2017
open to premium members only
Using MySQL to Output JSON [59470]
By Dave Stokes, January 6th, 2017

Dave, "MySQL has had a JSON data type since version 5.7 was released way back in '15. But did you know you could produce JSON output from non-JSON columns? It is very simple and saves a lot of time over trying to format it in your application.

World Database

We will be using the good old World database that MySQL has used for years in documentation, examples, and in the classroom. Starting with a simple query we will build up to something more complex..."
(Get More Information . .)

29 Dec 2016
open to premium members only
Percona Live Featured Tutorial with Oystein Grovlen - How to Analyze and Tune MySQL Queries for Better Performance [59320]
Percona, December 29th, 2016

"Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we'll highlight some of the tutorial speakers that will be at this year's Percona Live conference. We'll also discuss how these tutorials 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 tutorial, we'll meet Oystein Grovlen, Senior Principal Software Engineer at Oracle. His tutorial is on How to Analyze and Tune MySQL Queries for Better Performance. SQL query performance plays a big role in application performance. If some queries execute slowly, these queries or the database schema may need tuning. I had a chance to speak with Oystein and learn a bit more about the MySQL query tuning:.."
(Get More Information . .)

29 Dec 2016
open to premium members only
MSSQL To MySQL Data Migration Using MySQL Workbench 6.3 [59324]
By LALIT, December 29th, 2016

LALIT blogs, "Recently I was testing data migration from MSSQL to MySQL using MySQL Workbench. My aim was to include data with all datatype available in MSSQL for migration. In this following blog post will see data migration prerequisites, migration steps and few common errors..."
(Get More Information . .)

27 Dec 2016
open to premium members only
How to Perform Efficient Backup for MySQL and MariaDB [59326]
By Ashraf Sharif, December 27th, 2016

"All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal. Backups are usually planned according to your restoration requirement. Data loss can be full or partial, and you do not always need to recover the whole dataset. In some cases, you might just want to do a partial recovery by restoring missing tables or rows. In this case, you will need a combination of Percona Xtrabackup, mysqldump and binary logs to cover the different cases..."
(Get More Information . .)

21 Dec 2016
open to premium members only
MySQL on AWS: RDS vs EC2 [59157]
By Gabriel Ciciliani, December 21st, 2016

"When moving your MySQL instances to AWS, you would probably have to deal with this decision. This article will highlight some of the key factors that need to be considered in order to help you determine which is the most cost-effective solution for serving your data..."
(Get More Information . .)

 
back1 2 3 4 5 6 7 8 9 10 11 next