FrenchTech SAAS
33.5K views | +0 today
FrenchTech SAAS
Les news de l'univers SAAS et FrenchTech
Curated by Mickael Ruau
Your new post is loading...
Your new post is loading...

Popular Tags

Scooped by Mickael Ruau
March 21, 2013 4:29 PM
Scoop.it!

Book Review: SQL Antipatterns (2010, Pragmatic Bookshelf)

Book Review: SQL Antipatterns (2010, Pragmatic Bookshelf) | FrenchTech SAAS | Scoop.it
SQL Antipatterns helps you to avoid the pitfalls of database programming.
No comment yet.
Scooped by Mickael Ruau
March 21, 2013 4:27 PM
Scoop.it!

MariaDB Crash Course: Safari Books Online

MariaDB Crash Course: Safari Books Online | FrenchTech SAAS | Scoop.it
9780132842341 - MariaDB Crash Course - This first-to-market tutorial covers everything beginners need to succeed with MariaDB, the open, community-based branch of MySQL.
No comment yet.
Scooped by Mickael Ruau
March 21, 2013 4:07 PM
Scoop.it!

MySQL Reference Architectures for Small to Extra Large Websites

MySQL Reference Architectures for Small to Extra Large Websites | FrenchTech SAAS | Scoop.it
Oracle has published MySQL Reference Architectures for Massively Scalable Web Infrastructure, a whitepaper outlining recommended topologies for different types and sizes of websites using MySQL for data storage.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:24 AM
Scoop.it!

Raspberry PI ~ 04 : Configurer en serveur | IdleBlog

Raspberry PI ~ 04 : Configurer en serveur | IdleBlog | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:23 AM
Scoop.it!

Lier un serveur MSSQL à un serveur MySQL | .: bordel-de-nerd :.

Lier un serveur MSSQL à un serveur MySQL | .: bordel-de-nerd :. | FrenchTech SAAS | Scoop.it
J'ai eu besoin dans le cadre professionnel de lier un serveur Microsoft MSSQL en production à un serveur MySQL en développement.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:20 AM
Scoop.it!

Percona - Wikipedia, the free encyclopedia

Percona, Inc. is a software company specializing in database support, development and training. The company was founded in 2006 by Vadim Tkachenko[1] and Peter Zaitsev,[2] and its headquarters is in Pleasanton, California. The company provides database consultancy and development to customers including the BBC, Groupon, RightNow Technologies, Answers.com and 37signals.[3]

In November 2012, the telecommunications company Telefónica announced that Joyent appliances with Percona Server would be used for its cloud computing service Instant Servers.[4][5]

In December 2012, Percona, SkySQL and The Monty Program AB, led by MySQL's creator Monty Widenius, announced the formation of the MariaDB Foundation to oversee the development of MariaDB.[6][7]

Mickael Ruau's insight:

Percona Server is a fork of the MySQL relational database. It employs the company's replacement database engine XtraDB,[8] a replacement for Oracle InnoDB

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:19 AM
Scoop.it!

MySQL table_cache, information_schema, and open files limit | Geeks Worldwide

MySQL table_cache, information_schema, and open files limit | Geeks Worldwide | FrenchTech SAAS | Scoop.it
Recently, on our production servers we started seeing strange behavior by MySQL server while running queries on information_schema. Before getting into the gory details, I'd first explain the environment then the problem and its solution.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:18 AM
Scoop.it!

Comparison of MySQL database engines - Wikipedia, the free encyclopedia

This is a comparison between the two primary database engines (InnoDB and MyISAM) for the MySQL database management system (DBMS). A database engine (or "storage engine") is the underlying software component that a DBMS uses to create, read, update and delete (CRUD) data from a database.

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:17 AM
Scoop.it!

The MySQL CSV Storage Engine | FromDual

The MySQL CSV Storage Engine | FromDual | FrenchTech SAAS | Scoop.it
Mickael Ruau's insight:

A little summary about the MySQL CSV table engine:

The SQL-Demo script (930 byte) for the following article.The CSV converter to convert normal CSV files into a CSV format which is for MySQL acceptable.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:16 AM
Scoop.it!

MySQL Storage Engine based on PHP - Johannes Schlüter

MySQL Storage Engine based on PHP - Johannes Schlüter | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:13 AM
Scoop.it!

Aria (storage engine) - Wikipedia, the free encyclopedia

Aria is a storage engine for the MariaDB and MySQL relational database management systems. Its goal is to make a crash-safe alternative to MyISAM. It is not yet transactional but plans to add proper support for database transactions at some point in the future. The long-term goal is for Aria to be the default transactional and non-transactional storage engine for MySQL. It has been in development since 2007 and was first announced by Michael "Monty" Widenius on his blog.[1] Aria is used for internal temporary tables in MariaDB, a community-developed branch of the MySQL database led by Widenius, and is also included in Percona Server. MySQL is not shipped with MariaDB.

The Maria project is hosted on Launchpad.

Aria was initially named 'Maria', as a reference to Monty's youngest child.[2] It was renamed Aria in 2010 to avoid confusion with the main database it is developed for (MariaDB).[3]

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:08 AM
Scoop.it!

MySQL Storage Engines

Data in MySQL is stored in files (or memory) using a variety of different techniques. Each of these techniques employs different storage mechanisms, indexing
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:07 AM
Scoop.it!

MySQL :: MySQL 5.6 Reference Manual :: 14.12 Overview of MySQL Storage Engine Architecture

MySQL :: MySQL 5.6 Reference Manual :: 14.12 Overview of MySQL Storage Engine Architecture | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 21, 2013 4:28 PM
Scoop.it!

The Pragmatic Bookshelf | SQL Antipatterns

The Pragmatic Bookshelf | SQL Antipatterns | FrenchTech SAAS | Scoop.it
title: SQL Antipatterns: Avoiding the Pitfalls of Database Programming, by: Bill Karwin, isbn: 9781934356555, date: 2010-06-17
No comment yet.
Scooped by Mickael Ruau
March 21, 2013 4:08 PM
Scoop.it!

How to Optimize a MySQL Server - Hardware Secrets

How to Optimize a MySQL Server - Hardware Secrets | FrenchTech SAAS | Scoop.it
How to Optimize a MySQL Server
Hardware Secrets
If you have a MySQL server, chances are that it is not running at the top of the performance it can deliver.
No comment yet.
Scooped by Mickael Ruau
March 21, 2013 4:05 PM
Scoop.it!

MySQL and MariaDB Database Books

MySQL and MariaDB Database Books | FrenchTech SAAS | Scoop.it
Programming book reviews, programming tutorials,programming news, C#, Ruby, Python,C, C++, PHP, Visual Basic, Computer book reviews, computer history, programming history, joomla, theory, spreadsheets and more.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:23 AM
Scoop.it!

MySQL :: MySQL 5.0 Reference Manual :: 5.2.2 Le mode SQL du serveur

MySQL :: MySQL 5.0 Reference Manual :: 5.2.2 Le mode SQL du serveur | FrenchTech SAAS | Scoop.it
Mickael Ruau's insight:

Le serveur MySQL peut fonctionner avec différent modes SQL, et, depuis MySQL 4.1, il peut appliquer ces modes au niveau de la connexion du client. Cela permet aux applications d'adapter le comportement du serveur en fonction de leur attentes.

Le mode définit quelle syntaxe SQL MySQL doit supporter, et quels types de vérification il doit faire. Cela rend plus facile l'utilisation de MySQL dans différents environnement, et la connexion avec les autres serveurs de base de données.

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:21 AM
Scoop.it!

Exporting and importing data between MySQL and Microsoft excel - w3resource

Exporting and importing data between MySQL and Microsoft excel - w3resource | FrenchTech SAAS | Scoop.it
In this page we will discuss how to import data from Microsoft Excel to MySQL and how to export data from MySQL to Microsoft Excel.
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:19 AM
Scoop.it!

Calpont - Wikipedia, the free encyclopedia

Calpont is a database management software company based in Frisco, TX. Calpont makes InfiniDB, a scalable, software-only columnar database[1] for analytic applications.[2] InfiniDB has been selected as finalist in the Best Database Solution category at the 26th and 27th SIIA Annual CODiE Awards.[3][4]

InfiniDB Enterprise is a scalable database built for Big Data analytics, business intelligence, data warehousing and other read-intensive applications.[3] InfiniDB's column-store architecture enables very quick load and query times.[5] Its massive parallel processing (MPP) technology scales linearly with any type of storage hardware,[6] growing as analytic needs and data volumes grow.

By storing and managing data based on columns rather than rows, column-oriented architecture overcomes query limitations that exist in traditional row-based RDBMS. Only the necessary columns in a query are accessed, reducing I/O activities by circumventing unneeded rows.[7] This enables it to[clarification needed] with very large data volumes (Terabytes to Petabytes), commonly referred to as Big Data.

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:18 AM
Scoop.it!

Using MyISAM in production - MySQL Performance Blog

Using MyISAM in production - MySQL Performance Blog | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:17 AM
Scoop.it!

Aria FAQ

Aria FAQ | FrenchTech SAAS | Scoop.it
This FAQ explains what to expect of the Aria storage engine (below
referred to only as 'Aria'). MariaDB, the MySQL release that
includes Aria, is explained on its own page.
No...
Mickael Ruau's insight:

Aria is a new storage engine for MySQL® and MariaDB which is developed with the goal of being the default transactional AND non-transactional storage engine for MariaDB and MySQL.


What is the current goal of Aria 1.5 (current version)?

To make a crash-safe alternative to MyISAM. That is, when mysqld restarts after a crash occurs, Aria will recover all tables to the state as of the start of a statement or at the start of a previous LOCK TABLES.


No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:16 AM
Scoop.it!

MySQL PHP Storage Engine in Launchpad

MySQL PHP Storage Engine in Launchpad | FrenchTech SAAS | Scoop.it
No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:15 AM
Scoop.it!

Create a Storage engine for MySQL using PHP « VT's Tech Blog

Create a Storage engine for MySQL using PHP « VT's Tech Blog | FrenchTech SAAS | Scoop.it
Mickael Ruau's insight:

MySQL 5.1 has a plugin interface to easily add storage engines. PHP can easily embedded into other applications. So why not combine these two things? – Writing a MySQL Storage Engine which reads data by calling a PHP script.

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:10 AM
Scoop.it!

Product Category - MySQL

Product Category - MySQL | FrenchTech SAAS | Scoop.it
Buy Oracle licenses and support on the Oracle online store
Mickael Ruau's insight:

Les tarifs de MySql

No comment yet.
Scooped by Mickael Ruau
March 17, 2013 6:07 AM
Scoop.it!

MySQL :: MySQL Internals Manual :: 24 Writing a Custom Storage Engine

MySQL :: MySQL Internals Manual :: 24 Writing a Custom Storage Engine | FrenchTech SAAS | Scoop.it
No comment yet.