Browsing Category

MySQL

114 posts

Articles related to MySQL, Percona Server, MariaDB

MySQL Certification Free Retake: Get TWO chances to get MySQL Certified

Kedar
December 15, 2009

Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) –…

View Post

Monty: Help Saving MySQL – The Oracle & EC

Kedar
December 14, 2009

And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that…

View Post

Stored procedure to Find database objects

Kedar
December 5, 2009

This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…

View Post

MySQL Stored procedure – Split Delimited string into Rows

Kedar
December 5, 2009

This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…

View Post

MySQL Stored procedure – Execute query if table or Column exists

Kedar
December 5, 2009

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to…

View Post

MySQL master master replication monitor with php code

Kedar
December 4, 2009

For monitoring replication we know a lot of tools and codes – but this one is different because I wrote it 😉 Well this is fairly simple php code for…

View Post