Infrastructure at your Service

All posts by Saïd Mendi

Saïd Mendi
Consultant

Saïd Mendi has more than twenty five years of experience in programming, database infrastructure management, engineering, and optimization. He is specialized in MySQL, Oracle & Sybase technologies such as standardization, backup & recovery, tuning, high availability, monitoring, service management & support. Saïd Mendi is MySQL 5.6  OCP, Oracle 11g/12C OCP &  ITIL Foundation V3. Prior to joining dbi services, Saïd Mendi was Application Manager at Swisscom IT Services in Basel. He also worked as Unix/Linux IT Administrator, Oracle & Sybase DBA at Crossair/Swiss in Basel. Saïd Mendi holds a BTS degree in Information Systems from France.   logo Oracle Certified Professional_Oracle DBA 12cMy SQL DBA
Saïd Mendi
m17bannernew

Welcome to M|17, part 2

By | Database Administration & Monitoring | No Comments

Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate This exam was offered free of charges to all registered attendees As I wrote over, it was really experimental because all candidates faced many problems First, as this exam was proctored, the authentification process was very, very slow, essentially due…

 
Read More
Saïd Mendi
m17bannernew

Welcome to M|17

By | Database Administration & Monitoring | No Comments

Welcome to the MariaDB’s first user conference On the 11th, started at 09:00 this big event at the Conrad Hotel in New York, closed to the One World Trade Center After the short registration process where we received a full bag of goodies (mobilephone lens,Jolt charger, cap,note block,…) we could choose between 3 workshops. – Scaling and Securing MariaDB for High Availability – MariaDB ColumnStore for High Performance Analytics – Building Modern Applications with MariaDB…

 
Read More
Saïd Mendi

From MySQL (Oracle) to Postgres using the EDB Migration Toolkit

By | Database Administration & Monitoring | No Comments

Why should you migrate? If your current MySQL database does not offer some needed functionnalities according to your business as: – more security – more high availibilty options (hot standby) – Strong Data Warehouse capabilities If you want to consolidate the number of different instances (Postgres, MySQL, MS-SQL,…) If you want to reduce administrative costs by using fewer database platforms Which tool should you use? the migration Toolkit command-line from EnterpriseDB that can be found…

 
Read More
Saïd Mendi

MariaDB: audit plugin

By | Database Administration & Monitoring | No Comments

Why should you Audit your MySQL Instances? First to provide you a way to track user accessing sensible data Secondly to investigate on suspicious queries in all your critical databases Thirdly to comply with law and industry standards The MariaDB Audit Plugin can help you to log all or part of the server activity as: – who was connected and at which time – which databases and tables were accessed – which action/event (CONNECT, TABLE,…)…

 
Read More
Saïd Mendi

MySQL 8.0.0 DMR – First impression

By | Database management | One Comment

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First of all, when you remember the size of earlier versions, it is more & more gluttonous, see below mysql-5.0.96-linux-x86_64-glibc23.tar.gz    121.2M mysql-5.1.72-linux-x86_64-glibc23.tar.gz    127.8M mysql-5.5.52-linux2.6-x86_64.tar.gz            177.2M mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz    299.7M mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz   611.8M mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz is around 1Gb and uncompressed 3.6Gb (Oups…) At…

 
Read More
Saïd Mendi

Linux – How to check the exit status of several piped commands

By | Operation systems | No Comments

As piping in bash commands is common and very usefull, controling the exit status of each piped commands in bash scripting can be vital, especially for backups. I was checking by a customer the backups of a critical MySQL instance and was surprised even stunned that the return status of all of them was always  successfull when tested but physically on disk, the dumps were all empty. No valid backups since a long time meaning…

 
Read More