Skip to main content

Magento Session Data choose (file system or database )

Filesystem Session storage

Remember that innocuous setting during Magento install that asks you if you want to store your sessions on disk or in the database? Well if you are like me, you normally choose filesystem, not knowing any better and having never bothered to test or research the consequences (until now)

The benefits of file-based sessions for Magento are simplicity, stability and durability. It's simple because you don't have to do anything to set it up. It's stable because most modern filesystems use journaling to make sure that in the event of a system crash your session data is consistent. It's also durable, because a system restart will not cause you to lose your session data. Coming back to a webstore a week later and not having your items in your cart is annoying, right?

To enable file-based storage, choose it during installation or in your app/etc/local.xml file simply make sure you have a session_save tag like this:

1
<session_save><![CDATA[files]]></session_save>

Note: Look in app/etc/local.xml.additional for examples but ignore the comment about empty defaulting to files, you need the word files in there.

I have performance benchmarked filesystem storage in the Benchmark section below.

Database Session storage

Database session storage is the other storage type, the one you probably didn't choose during install, and forgot to circle back round and find out if you should have. With database session storage the session data is stored in the Magento MySQL database. The connection used is the same as the core connection.

One of the key benefits of using database sessions is the clustered environment support. In a filesystem based session storage scheme, if you have more than one Magento frontend node in a cluster, they will need to share session data (unless you use a loadbalancer with sticky sessions) and the database gives you that capability quite easily.

Databases also have good stability and durability during crashes and reboots.

One of the problems with database session storage is that it adds more load to the database. On large catalog sites with many SKUs, or busy sites with lots of sessions, this can hurt the database performance.

To use the database for session storage simply have this in your local.xml:

1
<session_save><![CDATA[db]]></session_save>

Check out the benchmarks below to see how well database session storage performs.





Regards,

 
 HERY PURNAMA
 MCDBA, ITILF, PMP, CISA
 IT & Management Trainer

 http://www.inhousetrainer.net
 inhousetrainer@yahoo.com , hery.purnama@gmail.com
 Call/ SMS/WA :  081.223344.506 | PinBB : 7DC633AA
 
 Blog :
 inhousetrainer.blogspot.com
 freelance-it-trainer.blogspot.com
 
 Social Net :
 facebook.com/inhousetrainer
 twitter.com/inhousetrainer
 instagram.com/inhousetrainer
 
 

Comments

Post a Comment

Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick

Popular posts from this blog

Laravel Training Purnama Academy

Nov 2018 Purnama Academy 0838-0838-0001 Kursus Laravel Training Center INdonesia, jakarta, Bandung, Bogor, Semarang, Yogya, Palembang kalimantan, surabaya visit www.purnamaacademy.com , Laravel - Online Courses, Classes, Training, Tutorials on Lynda https://www.lynda.com/Laravel-training-tutorials/2779-0.html Learn how to use Laravel, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Top Laravel Courses Online - Updated November 2018 | Udemy https://www.udemy.com/topic/laravel/ Whether you're interested in developing web apps in the Laravel PHP framework, or building a RESTful API with Laravel, Udemy has a course to help you ... PHP Laravel Framework | Brainmatics.Com brainmatics.com/php-laravel-framework/ Translate this page Laravel merupakan framework PHP yang dirancang untuk membangun situs web ... Pada training ini diharapkan mampu membantu meningkatkan kemampuan ... Dec 3 - Dec 6 Brainmatics Laravel training - Laracasts htt...
10 comments
Detail Alamat »

inspiring Training Center | www.purnamaacademy.com

Pencarian Inspiring Training Center Ditemukan Dengan Beberapa Hasil Sesuai Kata Kunci Training Center Bandung Dan Plus Beberapa Hasil Lainnya Untuk Inspiring Training Center , Silahkan Akses Www.purnamaacademy.com Untuk Halaman Yang Ditemukan Perihal Training Center Bandung Dan Sumber Informasi Bukan Hoax Untuk Training Center Bandung Agar Mendapat Penjelasan Detail Terkait Inspiring Training Center Yang Trending Per Hari Ini Dan Dapat Membantu Anda Mendapatkan Informasi Menyeluruh Terkait Pencarian Training Center Bandung, Terima Kasih . Informasi Lainnya Dari Contact.my.id Yang Mungkin Anda Butuhkan Dan Bermanfaat Sambil Membaca Ulasan Berita Inspiring Training Center Tersebut Antara Lain : Www.purnamaacademy.com | Informasi WATO.xyz Click To Chat Untuk Plugin Whatsapp Chat Di Web Anda - How To Create Link Using Www.wato.xyz Very Simple
Post a Comment
Detail Alamat »

Bisnis Paling Populer 2012

TEMPO.CO, Jakarta - Sektor industri pangan, industri jasa dan perhotelan, serta pertambangan dan energi diperkirakan bakal mengalami booming pada 2012. Permintaan di dalam negeri terhadap industri jasa, perhotelan, serta makanan di dalam negeri akan meningkat. »Adapun pertambangan dan energi karena permintaan di beberapa negara yang tidak terkena krisis juga cukup besar,” tutur Didik J. Rachbini, Kepala Lembaga Pengkajian, Penelitian, dan Pengembangan Ekonomi (LP3E) Kadin Indonesia, di Jakarta, Rabu, 28 Desember 2011. Menurutnya, pertumbuhan kelompok masyarakat yang memiliki daya beli tinggi saat ini cukup besar. Sehingga, permintaan terhadap sektor jasa dan produk makanan maupun perhotelan akan terus bertumbuh. Dia menyebut, sektor konsumsi masih akan menyumbang sekitar 60 persen dari pertumbuhan ekonomi. »Namun, bila pemerintah tidak bisa menjaga kondisi yang nyaman bagi kalangan usaha, maka pertumbuhan industri di dalam negeri akan di bawah target pemerintah,” kata Didik. Dia menyeb...
Post a Comment
Detail Alamat »