Infrastructure at your Service

Tag

MySQL Archives - Page 3 of 3 - Blog dbi services

Grégory Steulet

Mysqldump issue – SELECT command denied to user

By | Database management | One Comment

During one of my last MySQL mission, I encountered a “security error” with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning: ERROR 1449 (HY000) at line 1860: The user specified as a definer (‘cdadmin’@’%’) does not exist Following the migration,…

Read More
Grégory Steulet

MySQL Data High Availability with semi-synchronous replication

By | Hardware & Storage | No Comments

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, by default, MySQL replication is asynchronous.  Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one. In the specific context of MySQL such behavior means that the MySQL Master writes transactions/events to the local binary logs, however it has no idea when the slave(s) will get and process them. Of course such configuration can lead, in case of failover, to some transaction loss since there is no guaranty that the transactions have been transmitted on the standby server(s).

Read More
Grégory Steulet

Saving time and increasing service availability with MySQL Enterprise Monitor 2.3

By | Hardware & Storage | 3 Comments

Nowadays MySQL Databases are encapsulated into many mission critical software solutions. Lots of companies host one or many MySQL databases in their data center, sometimes even without knowing it except when the MySQL service is no more available. In order to increase this service availability it is mandatory to have a monitoring solution. Regardles of you are using MySQL Server, MySQL replication or cluster the Oracle/MySQL monitoring solution is called MySQL Enterprise Monitor.

Read More
Grégory Steulet

Stop looking for Oracle and MySQL documentation: use the dbi services firefox add-ons!

By | Database management | 2 Comments

Are you often trying to find some functionalities into ORACLE 10gR2, ORACLE 11gR2 or MySQL documentation ? Of course each time you are looking for this documentation you find unofficial documentation which is never corresponding to the version you are looking for.. we have the solution, three firefox add-ons that will allow you to easily find the right official Oracle or MySQL documentation you are looking for.

Read More
Grégory Steulet

MySQL Workbench 5.2: changing the life of MySQL developers and DBAs

By | Application integration & Middleware | 2 Comments

MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities:

1.    SQL Development: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser stand-alone application.

2.    Data Modeling: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas

3.    Server Administration: Helps to configure a database server, to setup user accounts and browse status variables and server logs

 

Let’s have a look deeper in each of those features:

Read More