ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Database Administration Best Practices
Posted on 2014-01-03
Hello,
I work as a software engineer/ sysadmin and am currently moving into DBA land. I'm tasked to come up with at least 5-10 best practices for our MySQL database environment running on centos 6.5 in AWS. We currently run two MySQL database servers for our web-based SAAS application in master-master replication, with a disaster recovery database as a slave of one of the masters. We also have this exact setup in our stack for a different piece of the application, so in total 6 database servers.
I'm wondering if anyone has any suggestions for what we should be doing or what we can adopt as best practices for managing and maintaining database environments. If there are any DBAs out there that could share their expertise that would be very much appreciated!
Thank you!
I work as a software engineer/ sysadmin and am currently moving into DBA land. I'm tasked to come up with at least 5-10 best practices for our MySQL database environment running on centos 6.5 in AWS. We currently run two MySQL database servers for our web-based SAAS application in master-master replication, with a disaster recovery database as a slave of one of the masters. We also have this exact setup in our stack for a different piece of the application, so in total 6 database servers.
I'm wondering if anyone has any suggestions for what we should be doing or what we can adopt as best practices for managing and maintaining database environments. If there are any DBAs out there that could share their expertise that would be very much appreciated!
Thank you!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
4 Comments
https://dev.mysql.com/tech-resources/articles/mysql-administrator-best-practices.html ?
First is done by scripts (couple of them on the web)
Second - just read through.
Third - ask your boss to restore the DBbackup to his desktop... try again until it works...
First is done by scripts (couple of them on the web)
Second - just read through.
Third - ask your boss to restore the DBbackup to his desktop... try again until it works...
Active 1 day ago
Also use MySQL Tuner to make adjustments to increase performance and stability etc., http://majorhayden.com/
These are great answers. Thank you.
I'm looking for more suggestions about cleanup and optimization tasks that I can run on the databases safely and automcatically through a cron job. As a side project, I run a forum software called Invision Power Board that has regular cleanup tasks that run every so many hours such as clearing sleeping connections, running optimize-table, etc. This is not related to the SAAS application and runs on a different stack.
Just wondering if these are things that can normally be run safely or if they are ok to run only because of the way IPB setup their application.
Also would like to know about any more automatic cleanup tasks I can run.
I'm looking for more suggestions about cleanup and optimization tasks that I can run on the databases safely and automcatically through a cron job. As a side project, I run a forum software called Invision Power Board that has regular cleanup tasks that run every so many hours such as clearing sleeping connections, running optimize-table, etc. This is not related to the SAAS application and runs on a different stack.
Just wondering if these are things that can normally be run safely or if they are ok to run only because of the way IPB setup their application.
Also would like to know about any more automatic cleanup tasks I can run.
Usually protocol takes care of idle connections (if iptables kill them in 12h or Linux kernel in 2 days)
Optimize table delays access to table while running.
They know better that their app is broken and needs to close idle connections. Or that is so non-realtime that it can wait to optimize biggest table.
Optimize table delays access to table while running.
They know better that their app is broken and needs to close idle connections. Or that is so non-realtime that it can wait to optimize biggest table.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Happy holidays! Your Ops team can pack their bags. IT management and IT management tools are dead.
Or at least that’s according to a new blog from Tech Target on AWS’s new Managed Services (MS) offering.
This article shows the steps required to install WordPress on Azure.
Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan.
WordPress is no exception and requires an App Service Plan and Database to install
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Get a first impression of how PRTG looks and learn how it works. This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
- Linux
- Windows OS
- Networking
- Paessler
- Network Management
- Network Analysis, Network Operations
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 2 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.