Blog

  • Baseline linux server v1 - part 2 Following the last post here is a set of scripts to monitor linux generic performance counters as well as MySQL.The data that will be gathered will be done according to your request. Data from CPU and / or memory and / or disk io and / or MySQL. The data generated will be dispatched to different csv files according to your configuration choices (by hour, day, week, month). This is mainly to ease the process when you will be in the process comparing a specific time frame with what people are saying abnormal activity against what was considered normal activity from historic baseline. Script installation step: make sure that all the prerequisites and requirements are fulfilled (prerequisites document) extract all the script ...
    Posted Feb 23, 2014, 8:18 PM by Ricardo Fonseca
  • The importance of having baseline of your servers - part 1 Intro I decided to discuss about this matter after one of those event where some people argue that performance decreased a lot on one of our MySQL server. To give you a little bit of context, the company where I work use largely the agile model. Not only for developers but sysadmin and dba as well. The event cited above occurred after a sprint release, but was it related, how could I be sure ?? Was it just some limitations on our system that had been reach, was it because some fundamental changes occurred in the way the applications was used that was generating a high load on the server ?? From there I had two axes to focus on to be ...
    Posted Feb 23, 2014, 8:18 PM by Ricardo Fonseca
  • Guess who's back As a first post since quite a while, I start little and write a post with the information in regards my updated resume including all my latest role and qualifications.We will find all the current data / experiences within the document :resume-enAnd you will be able to find previous employment information following the link :resume-en-pevious-employmentTalk to you soon with a post talking about the importance of a baseline.Thank you.Ricardo
    Posted Feb 7, 2014, 11:16 PM by Ricardo Fonseca
  • Installation SQL Server 2008 Manual / Automatic IntroductionThis post is here to provide a canvas for SQL Server 2008 installation , it fit most of the installation need. and describe brief information on every step on what option to select and why. We take two perspective in this post the manual installation , step by step with print screen and the automatic installation process with a configuration template file where you specify the default directories and account name and password.Please note that I for all account names and password are virtual and use only as illustration. It will be up to you to set the values according to account credential that fit the best for your business.Pre-RequisitesNew local admin account account name : dbadmin account ...
    Posted Feb 17, 2011, 6:01 PM by Ricardo Fonseca
  • High availability / High scalability pros and cons Following my last post, I summarize here a list of the pros and cons of the different solutions previously discussed.High availability / scalability modeProsConsReplication- Transactional- Merge- Snapshot- Peer-to-peer[x] Data availability[x] High scalability[x] Can be mixed with db mirroring[x] Good Reporting Solution[x] Little down time[x] No automatic fail over[x] Possible Data Loss[x] Latency on secondary server[x] Adv. Setup [x] Adv. Troubleshooting[x] Schema drivenLog Shipping[x] Data availability[x] High scalability[x] Easy Setup (FileSystem)[x] Easy Troubleshooting[x] can be mixed with db mirroring[x] Good Reporting Solution[x] Little down-time[x] Same database can have multiple destination server[x] No automatic fail over ...
    Posted Sep 11, 2010, 9:13 PM by Ricardo Fonseca
  • High availability / High scalability solutions I have been asked a couple of times now what is the best solution for my environments in terms of availability, scalability. And as my experience grows I tend to answer with the famous "it depends". Why, well because regarding your needs (reporting server , load balance load across multiple server(s), hot fail-over server , data-warehouse server etc...) a solution may fit best for a customer and another one will suit best another customer. As in the real life, describing the purpose of your secondary server will drive 80% of the requirements to answer correctly the question. The last 20% will go with related business requirements and possibilities in terms of infrastructure and $. I have listed below and describe ...
    Posted Sep 11, 2010, 9:09 PM by Ricardo Fonseca
Showing posts 1 - 6 of 13. View more ยป