Thursday, November 30, 2017
Magento 2 local setup - Version 2
it seems the following docker image works better for magento 2 local development
To Clean up docker image, volume, etc (Optional)
# docker system prune
# stop all containers:
# docker kill $(docker ps -q)
# remove all containers
# docker rm $(docker ps -a -q)
# remove all docker images
# docker rmi $(docker images -q)
# remove all volumes
#docker volume rm $(docker volume ls -f dangling=true -q)
- git clone https://github.com/markoshust/magento2-docker.git
- cd magento2-docker
- docker-compose run --rm setup
after this command the DB setup would have completed and will have just the DB Image
- Un comment docker-compose.override
- mv docker-compose.override.yml.dist docker-compose.override.yml
- docker-compose up -d app
This will create another 2 docker container, so we should have 3 containers running.
- cp CONTAINER ID:/var/www/html ./ . ( this is the container id of magento2docker_phpfpm_1)
- http://m2.localhost:8000/index.php
- Admin : http://m2.localhost:8000/index.php/admin_16wb2m/
Sample HelloWorld Module
Follow the steps in
Connecting to Database
Wednesday, November 29, 2017
Monday, November 27, 2017
Magento 2
https://www.udemy.com/mastering-magento-2/
https://u.magento.com/fundamentals-of-magento-2-development#.WhbBqrT81-U
http://mageclass.com/screencast-a-gentle-introduction-to-magento-2-for-magento-1-developers/
https://www.magestore.com/magento-2-tutorial/
https://www.thedash.com/
Install Docker
https://docs.docker.com/docker-for-mac/install/
11/25
https://github.com/clean-docker/Magento2 (This works)
https://rafaelstz.github.io/magento2/Install-Magento2-Docker-Development.html
Other Good Images
https://github.com/fballiano/docker-magento2
Magento Data Volumes
https://github.com/mageinferno/magento2-docker-compose
https://github.com/loganstellway/magento2-docker-swarm
Tutorials
http://mageclass.com/screencast-a-gentle-introduction-to-magento-2-for-magento-1-developers/
https://alankent.me/category/magento/
https://www.youtube.com/watch?v=tRmraOgVWtk
https://firebearstudio.com/blog/the-ultimate-magento-2-tutorial.html
Books
https://www.safaribooksonline.com/library/view/magento-2-development/9781785289897/
https://www.safaribooksonline.com/library/view/mastering-magento-2/9781785882364/
https://www.safaribooksonline.com/library/view/learning-magento-2/9781783288250/
https://www.safaribooksonline.com/library/view/magento-2-cookbook/9781785887062/
Video Tutorials
https://u.magento.com/fundamentals-of-magento-2-development#.WiLIG7Q-d24
https://www.safaribooksonline.com/library/view/magento-2-testing/9781787282308/
https://firebearstudio.com/blog/magento-2-video-tutorials.html
Build & Release
Less Vs Saas
https://github.com/SnowdogApps/magento2-frontools
Tech Stack
- Varnish
- Redis
- Elastic Search
- Gulp
- Docker
- How to upgrade new version of Magento.
- Composer how does it work for custom Module.
- Php Storm
- Testing
- Code Migration
- Database Migration
- 50% traffic is on mobile , how to optimize for mobile
Saturday, November 25, 2017
Magento 2 Local Setup
2. Install Docker Edge Channel
3. Once Docker Installed Execute this command
Reference : https://rafaelstz.github.io/magento2/Install-Magento2-Docker-Development.html
4. Log Into docker Image
docker exec -ti m2docker_apache_1 bash
5. Install Magento
composer create-project --repository-url=https://repo.magento.com/ magento/project-community-edition magento2
6. Get Mysql Ip
docker inspect m2docker_db_1 | grep IPAddress
7. Start the setup of Magento2
8. Docker Tips
The first time installation might not work right if so if you wanted to clean up docker use these handy commands
# stop all containers:
# docker kill $(docker ps -q)
# remove all containers
# docker rm $(docker ps -a -q)
# remove all docker images
# docker rmi $(docker images -q)
9. How to setup Php Storm and edit the files in the container
ToDo: Need to research how to setup docker volumes so that files can be shared and edited.
10. Linkshttp://localhost:8080/
http://localhost/
http://localhost:8025/#
http://localhost/magento2/
http://localhost/magento2/admin_6p1kqi/
11.How the edit the magento2 files
under the directory there is a mapping folder src
m2-docker/src/magento2
ToDo:
these Steps can be further simplified with just one command docker-compose up;
Sunday, November 5, 2017
Sunday, October 22, 2017
Monday, October 9, 2017
Sunday, October 8, 2017
Saturday, October 7, 2017
Sunday, October 1, 2017
Saturday, September 30, 2017
Wednesday, September 27, 2017
Monday, September 25, 2017
Sunday, September 10, 2017
Sunday, August 27, 2017
Monday, August 21, 2017
SQL Server
SQL Server:
Number of tables and sizes (Credit : stack overflow)
SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, s.Name, p.Rows
ORDER BY
t.Name
Size of Index
SELECT
i.[name] AS IndexName,
t.[name] AS TableName,
SUM(s.[used_page_count]) * 8 AS IndexSizeKB
FROM sys.dm_db_partition_stats AS s
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id]
AND s.[index_id] = i.[index_id]
INNER JOIN sys.tables t ON t.OBJECT_ID = i.object_id
GROUP BY i.[name], t.[name]
ORDER BY i.[name], t.[name]
Subscribe to:
Posts (Atom)