Posts Tagged ‘mysql’

The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]

MySQL replication is a real-time mechanism that automatically copies or replicates data from one server to another backup server. Database administrators can use the master-slave replication procedure to replicate or copy data from multiple servers at the same time. This allows the database administrator to create a continuous live backup of the database. They can […]

Welcome back to Docker Bootcamp.  In this post, we’ll set up multiple containers and link them, so they function together.  For example, you could have one container for a database server and another for a web server hosting a content management system.  Remember, containers are specialized and can only run one piece of software.  Linking […]

MySQL has been a very popular DBMS and was chosen for many application systems since it is open source and easy to use. In NoSQL, MongoDB is becoming popular and is being applied in application development and the big data analytics field. In one of my colleague’s blog posts, he discusses that we built an […]

As an instrumental containerization tool in the DevOps technologies, Docker is useful and being widely applied in the continuous integration (CI), continuous delivery (CD) and auto deployment practice. Perficient China portal team has just completed a Liferay application dockerization. This implementation makes our entire application/instance to be lightweight in the deployment and lay the foundation […]

Microsoft FIM (Frontend Identity Manager) is a popular enterprise product which is allowing to automate user creation, provisioning and de-provisioning in Microsoft Active Directory. FIM has many out-of-the-box extension connectors which allows for connecting FIM to external systems (like external user catalogs), including a set of web services. When out-of-the-box connectors are not sufficient, it’s […]

Oracle recently released it’s January 2015 Critical Patch Update that includes 169 new security fixes across the following product groups: Oracle Database Oracle Fusion Middleware Oracle Fusion Applications Oracle Enterprise Manager Oracle Applications – E-Business Suite Oracle Applications – Oracle Supply Chain, PeopleSoft Enterprise, JD Edwards Product Suite, Siebel and iLearning Oracle Communications Industry Suite Oracle Retail […]